7.4 no refreshRecordFromDatabase with VFP Table

[stefanoni]

Hi at all,

Since Servoy 7.4 it doesn’t refresh the VFP-Table (Visual Foxpro), if I use databasemanager.refreshRecordFromDatabase()

1. I write a VFP-Table-Record with Servoy
2. Update this Record with VFP9
3. databasemanager.refreshRecordFromDatabase()
4. Still the same Values in the Table !

Any workarrounds, ideas, sugesstion are very welcome !

what i tried with no success:
Open a second foundeset instead of refreshRecordFromDatabase() of the actual foundset, reads the
same old data, until i restart the Develeoper, or the Servoyserver.

Thank you

[ROCLASI]

stefanoni:
Since Servoy 7.4 it doesn’t refresh the VFP-Table (Visual Foxpro), if I use databasemanager.refreshRecordFromDatabase()

If it worked before and now it doesn’t then this is a bug.
Did you file an issue in the tracker for this ?

[stefanoni]

thank you.

Jira

No tricky workarround to simulate the reboot of the server ?

[engemann]

We had this with an older version of the dfb driver.
Please ask Servoy for the newest DBF driver from 03. April 2014!

[patrick]

I think this is a caching issue in the driver. Are you using the very latest version (from March)? Please send me an email if you don’t have that.

What happens if you set the connection pool size to 0 in the DB connection? Then, I suppose, your problem disappears?

[patrick]

@engemann:

He is the expert on these issues!

[engemann]

The connection pool should work since the version from 2014-03-04, but only with Prepared Statemens = 0.

Prepared Statements >0 should work since DBF driver from 2014-04-03.

[stefanoni]

before I start stupid try and error:

• I got a driver version 12. may 2014 (not the date posted before)

• Patricks suggested option “connection pool size” doesn’t exist in the mask in the developer where the driver is defined and also not in the servoy.properties.
  also not in the https://wiki.servoy.com/display/public/DOCS/Database+Connections#DatabaseConnections-DimensioningtheConnectionPool.
  maybe you mean “server.10.maxConnectionsActive=30”

• what about engemann’s suggested “Prepared Statemens = 0” in combination with “connection pool size > 0”

Witch combination (driver-version, options) definitively you suggest, or was working in your case ?

Thank you, for make this understandable.

[stefanoni]

OK, I start try and error:

Where can I define the “connection pool size” ?

Thanks for make me this clear.

[stefanoni]

ok,

set Maximum connections idle to 0 (Zero)
but leave Maximum connections by 30

strange values, but it seems to work.

regards

[engemann]

These are my settigns:

Max Connections Active = 30
Max Connections Idle = 30
Connections Idle Timeout = -1
Max Prepared Statements Idle = 100
URL: jdbc:DBF:/D:/PATH/TO/DATEN.DBC?lockType=VFP&versionNumber=30&delayedClose=5&deletesAreVisible=false&emptyStringAsNull=false&emptyDecimalAsZero=true