HXTT ACCESS
MS Access file changes not recognised
MarcB
2010-08-10 03:57:42.0
Hello,

We have the 3.0 version of your JDBC Drivers and only now we ran into a problem with them (MS Access).

While we develop our MS Access database and meanwhile create some data transfers with HXTT, we notice that HXTT drivers are not picking up the changes in the database tables (ie. new fields are not showing up and delete fields are still showing up).
I've checked the code we use and we close the connection each time, but that doesn't help at all. We need to shutdown jBoss and start it up again for the JDBC driver to pickup the changes.

At first I thought it was a caching problem so changed the connection string to:

con = DriverManager.getConnection(jdbcUrl+",maxCacheSize=0,delayedClose=0,J2ME=true");

but that doesn't help either.

Any idea what might go wrong??
Re:MS Access file changes not recognised
HXTT Support
2010-08-10 09:20:22.0
>While we develop our MS Access database and meanwhile create some data transfers
>with HXTT, we notice that HXTT drivers are not picking up the changes in the
>database tables (ie. new fields are not showing up and delete fields are still
>showing up).
I tested and failed to recur you issue with HXTT Access v4.0.021. Please let us know your version?
Re:Re:MS Access file changes not recognised
MarcB
2010-08-11 00:45:07.0
We're using v3.0.

I will set up a test with the v4.0.021 if they are downloadable as trial.
Re:Re:Re:MS Access file changes not recognised
MarcB
2010-08-13 03:46:34.0
v4 does indeed solve the problems I described :)


Google