aspose file tools*
The moose likes JDBC and the fly likes jdbc:odbc insert error fails with code -3502 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc:odbc insert error fails with code -3502" Watch "jdbc:odbc insert error fails with code -3502" New topic
Author

jdbc:odbc insert error fails with code -3502

Jon Dornback
Ranch Hand

Joined: Apr 24, 2002
Posts: 137
I am calling a preparedstatement that performs inserts on a single table in an access database. However, the insert fails and I can't figure out why - any help is most appreciated. I also tried this as a batch, and that didn't work either.


I have other statements similar to this that work fine, and the values used as parameters are of the correct type. Any suggestions?
[ November 19, 2002: Message edited by: Jon Dornback ]

use the [CODE] tags - it makes it much easier for people to help you.
Jon Dornback
Ranch Hand

Joined: Apr 24, 2002
Posts: 137
I found the problem. In my infinite wisdom, I had used the SQL reserved word "order" as a column name.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc:odbc insert error fails with code -3502
 
Similar Threads
This is driving me crazy
Issue with Date insertion
inserting byte[] into MS Access Database...
SQLException. Generel Error
Inserting date into an MS Access DB