I'm very interested in buying your product, but:
I'm using PreparedStatement.executeBatch(); this works fine on the JDBC-ODBC bridge that ships with Java. But, when I use your software, I open the MS-Access DB after I run my inserts and try to delete a record and get the following error: "The search key was not found in any record"
|
|
What's your sql? Have you built some index on your MDB file? If possible, you can send your mdb sample to webmaster.hxtt@gmail.com .
|
The table has a primary key index. The SQL on this table in my test script that causes the error is:
PreparedStatement insertCollection = con1
.prepareStatement("INSERT INTO UI_COLLECTIONS (PK_OBJECT_ID, PK_COLLECTION_KEY, COLLECTION_VALUE, KEY_TYPE, VALUE_TYPE, PK_VERSION_ID, USER_CODE, LAST_USED_DATE) "
+ "VALUES (?,?,?,?,?,?,?,?)");
PreparedStatement updateCollection = con1
.prepareStatement("UPDATE UI_COLLECTIONS SET COLLECTION_VALUE = ?, VALUE_TYPE = ?, USER_CODE = ?, LAST_USED_DATE = ? WHERE PK_OBJECT_ID = ? AND PK_COLLECTION_KEY = ? AND PK_VERSION_ID = ?");
Where the columns prefixed by "PK_" are primary keys, and thus form an index.
I could send you an MDB but it's very large.
|
|
You can copy your mdb file to temp.mdb file, then remove all tables except for that UI_COLLECTIONS talbe, then delete all rows in UI_COLLECTIONS. Then run Compact/Repair database in Ms Access, then email that mdb file with empty table structure and index information. Then we will produce simulation data to recur your issue. Thanks.
|
Main
webmaster@hxtt.com