I'm testing the trial version of the driver with Hibernate because that is how we will be using it.
I have been able to read without any problems. But when I try to insert a record, I get:
WARN JDBCExceptionReporter - SQL Error: 393216, SQLState: 60000
ERROR JDBCExceptionReporter - Failed to insert a new record into table UDF! For more information, please use SQLException.getNextException().
WARN JDBCExceptionReporter - SQL Error: 143360, SQLState: 23000
ERROR JDBCExceptionReporter - Failed to insert a duplicate key for conflict with record 00029B73
The problem is, there is no such record with that ID in the tables. Is that ID some kind of standard message that I've exceeded the number of queries per session with the driver?
|
>ERROR JDBCExceptionReporter - Failed to insert a duplicate key for conflict with
>record 00029B73
>The problem is, there is no such record with that ID in the tables.
It means that you have a unqiue index restriction on table UDF, and HXTT Access found a duplicate key so that it refuse to do insert operation. If you think there is no such record with that ID in the table, and you can try "reindex all on UDF", then insert sql again. If you failed still, you need to check whether there's other unique index restriction.
|