Hi, we have random errors with the Access Driver 3.1 on the windows platform (JDK 1.6.0_05). We open an empty MDB and start creating and altering tables. Sometimes the test completes, sometimes it aborts (never at the same point but usually on an ALTER TABLE command) with the following error:
Failed to create table _temp_1217608366179 because it exists.
Please note that we NEVER issued a command to create such a table, this must be something that the driver does in the background. The timestamp in the temporary table name always change but the error remains the same.
Please find hereunder a complete log4j dump
ALTER TABLE value_range MODIFY id integer PRIMARY KEY
[main] (MdbConverter_HXTT.java:88) ERROR - Failed to alter table value_range! For more information, please use SQLException.getNextException().
[main] (MdbConverter_HXTT.java:89) ERROR - Error Code:393216
[main] (MdbConverter_HXTT.java:90) ERROR - SQL State:60000
[main] (MdbConverter_HXTT.java:91) ERROR - java.sql.SQLException: Failed to alter table value_range! For more information, please use SQLException.getNextException().
[main] (MdbConverter_HXTT.java:88) ERROR - Failed to create table _temp_1217608366179 because it exists.
[main] (MdbConverter_HXTT.java:89) ERROR - Error Code:786710
[main] (MdbConverter_HXTT.java:90) ERROR - SQL State:S0001
[main] (MdbConverter_HXTT.java:91) ERROR - java.sql.SQLException: Failed to create table _temp_1217608366179 because it exists.
|
Changed. It seems that your PC is too quicken so that HXTT Access tried to create two tables in 1 ms. Please download the latest package.
# v3.1.004 supports WITH ROLLUP, WITH CUBE, and GROUPING(expression).
# v3.1.004 supports bitwise logical operator(&, |, ~, ^, <<, >>), BITAND(x, y), and BIT_COUNT(x).
|
|
Are you telling us that the driver's correct operation depends on how fast is the computer where it runs? Can't you put some sync primitive so that the driver just works independently from the processor's speed ?
|
|
The old package used Systmem.currentTime() as a unique temporary table name:) The latest package has changed.
|
Main
webmaster@hxtt.com