Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data type mismatch MS Access autonumber field

843859May 16 2007 — edited May 16 2007
Hi, im trying to delete a rec from Access from java code.

My SQL is: String query = "Delete from items where item_id='"+dbitem_id+"'";

Where dbitem_id is a Double variable.

Item_id in Access is a autonumber longinteger

Im getting [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. when I run it.

Any idea how I can fix this?
thanks.
Jason
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2007
Added on May 16 2007
2 comments
311 views