• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc:odbc insert error fails with code -3502

 
Jon Dornback
Ranch Hand
Posts: 137
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Jon Dornback
Ranch Hand
Posts: 137
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found the problem. In my infinite wisdom, I had used the SQL reserved word "order" as a column name.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic