I am getting a SQL syntax error when I try to execute an INSERT...INTO command via JDBC. Unfortunately, the message is not very helpful! Maybe I'm just spoiled by the nice messages that Sun's Java compiler gives for my Java code. Anyway, here is the code that causes the error:
And here is the stack trace for the exception:
The SQLUtil class is a nice little utility that takes care of a lot of the complexities of JDBC for me. Also it makes commonly used code very reusable. I won't post it here unless I need. Most of the methods I use here are delegated directly to a PreparedStatement.
Any ideas what the problem is with my SQL statement?