Hi,
I have downloaded the evaluation version of your JDBC MsAccess driver and I have problem when using it in my program.
I use the last version (05 july 2011) with an Access 97 database.
When executing 2 INSERT statements on the same table, an exception is thrown after the second INSERT :
java.sql.SQLException: Failed to insert a new record into table Definition type:Failed to insert a duplicate key for conflict with record 00000900
But there is no primary key conflict nor unique index conflict in the 2 statements (and there is no other row in the table). If I executes the 2 statements directely with Access, there is no problem to insert the 2 rows, so it's not an referential integrity issue.
After the exception is thrown, I tried to open the database using Access and I can not modify or delete the row inserted by the first request. I have to use the tool "Repair database" in the Access menu, to be able to delete or modify the row.
After using the repair tool, I can execute the second INSERT by JDBC without any problem. But, no other INSERT can be done in the table without using the tool Repair database.
Do you have any idea to resolve the problem ?
I can provide you the database and the Java code I use to reproduce the problem if needed.
Thanks in advance for your reply.
Simon
|
|
Please email your sample. Thanks.
|
I have just sent samples data to support@hxtt.com.
Regards
Simon
|
|
Checked. It's resulted by a GUID column which has a default GENGUID() value, and has a primary key index. Please donwload the latest package, which will simulate GENGUID() to produce unique GUID value.
|
Thank you very much. It resolve the problem with my test database, but when I try to check this new driver version with my real database, the driver throws a SQLFeatureNotSupportedException because I try to execute more than 50 queries.
You previously send us a non limited version (with only one month of validity, but with unlimited number of queries). To be able to validate the driver with our software, before bying a licence, could you please send us, by email, a version of the driver without this limitation.
Thank you
Best regards
Simon
|
|
Sent. Please check your mailbox.
|
Thank you very much.
The correction seems to be ok for this problem.
Regards
Simon
|
Main
webmaster@hxtt.com