Link to home
Start Free TrialLog in
Avatar of CloudStrife209
CloudStrife209

asked on

Java ODBC Updated records not showing

I've put together a small work flow tool to manage some work, the database updates throughout the day, and the records are allocated to a individual to be processed every 30 minutes.

The user refreshes the data when they want to, to get their new records. Here is the strange thing sometimes the updated records won't show for 2-3 hours after they have be updated. This happens seeming at random and I'm not seeing any errors being generated. (I have the console printing to a txt file)

I'm using an ODBC to connect to an MS Access database, I have 6-8 people accessing the database at any one time.
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

Make sure you close database resources after each update
Avatar of CloudStrife209
CloudStrife209

ASKER

All the create connections have a connection close and set to null
I  wasn't actually aware that Access supports concurrent connections. If it does, check on the transaction isolation between concurrent sessions
I'm honestly not sure if this is the issue, i've got it setup so that it connects grabs data assigned to the user and closes the connection process takes less then a second. And while its possible two users could be requesting data from the database at the same time i doubt that it would happen all the time over a period of 3-4 hours.

Also i have transaction level set to default TRANSACTION_READ_COMMITTED
I think i'm going to let the Access people take over - i know very little about it ;)
ASKER CERTIFIED SOLUTION
Avatar of mrcoffee365
mrcoffee365
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Are you sure that you close your connections after you are done with the update?
That question had already been answered in the affirmative Isn't that the case CloudStrife209?