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.
Joined: Apr 24, 2002
I found the problem. In my infinite wisdom, I had used the SQL reserved word "order" as a column name.
subject: jdbc:odbc insert error fails with code -3502