I have problem maybe at java.sql.DriverManager.getConnection(DriverManager.java:579)

[Antony7U]

Dear All,
Could you please help me I have a strange issue.
I have created a small program to reproduce the issue.

Test cases:
1) The error comes only with Java runtime 64 bit and with the driver AccessDatabaseEngine_x64.exe
2) If I try to debug (delayed run) the problem does not appear. Seems the problem happens only when the code are run very fast (I run it on sandy bridge with 4 CPU cores).
3) on 64bit it works if I comment out the line 12+13 at Main.jar or also if you clone the lines like create new tblC maybe it cause new delays?!
4)The problem does not appear if I switch to Java runtime 32 bit and MSAccess 32bit driver but that is not acceptable

I get exception:
SEVERE: null
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3906)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5697)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353)
at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(JdbcOdbcConnection.java:1503)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:381)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at testdriver.TBLCont.<init>(TBLCont.java:21)
at testdriver.Main.test(Main.java:12)
at testdriver.Main.main(Main.java:32)

[Antony7U]

I do some new tests and I add a time delay to the code and it does not depend how fast it runs as the println counter(50) stops at same exception position.
But set break point to counter 49 then start debug I do not get the problem seems there is a buffer clear time? or GC?
And seems if I change at that String:
“String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="…”;DriverID=25;"
and that parameter:
DriverID=25 or to DriverID=22
then I get faster (counter 38 ) the error message with “Invalid string or buffer length”
Question is maybe how to free up that buffer?

Maybe it is near too that symptom connection caching parameters:
http://forums.visokio.com/discussion/1087/refresh-from-source-task-of-database-blockodbc-fails-to-execute.
Unfortunately I do not know, how to implement that solution to my project it is undocumented for that MSDriver. Or contact MS Support? I am doubt here is it the driver or the GC or the JVM which cause that problem? Any further idea how to solve it?