Help with JDBC query

I'm getting the following error in an insert, the update works fine. Is there a way to get a more informative error message about the error? Does anyone see a syntax error that I missed? I'm using MySQL 4.1.8 and Connector/J 3.0.16. 19:13:20,906 INFO [STDOUT] -SQLException- 19:13:20,906

Re: Help with JDBC query

You are missing the VALUES clause before the open parenthesis. -Richard At 07:32 PM 1/23/2005, you wrote: I'm getting the following error in an insert, the update works fine. Is there a way to get a more informative error message about the error? Does anyone see a syntax error that I missed? I'm

Re: Help with JDBC query

Hard to tell but is there a space between ) and VALUES? Bob Sent from my Dell Axim X30 -Original Message- From: Jack Lauman[EMAIL PROTECTED] Sent: 1/23/05 9:32:45 PM To: SERVLET-INTEREST@JAVA.SUN.COMSERVLET-INTEREST@JAVA.SUN.COM Subject: Help with JDBC query I'm getting the following

Chanh Le is out of the office.

I will be out of the office starting 1/17/2005 and will not return until 2/7/2005. I am on vacation and back on 02/07/2005. Please contact Paul Bambah and Ravindra Dabbiru for AS400 issues. Thanks. ___ To unsubscribe, send

Re: Help with JDBC query

Oops, my mistake, I see the VALUES clause is there but it seems that the close parenthesis is missing. - ?, ?, ?, ?); } else { -Richard At 07:32 PM 1/23/2005, you wrote: I'm getting the following error in an insert, the update works fine. Is there a way to get a more informative error message