wood burning stoves 2.0*
The moose likes JDBC and the fly likes SQL Syntax Error for MySQL but not sure where... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Syntax Error for MySQL but not sure where..." Watch "SQL Syntax Error for MySQL but not sure where..." New topic
Author

SQL Syntax Error for MySQL but not sure where...

Ron Ingram
Ranch Hand

Joined: Mar 11, 2011
Posts: 63
Can someone spot my error? I cannot seem to figure it out. Could be my jdbc driver, I'm currently using 5.1.14 jdbc driver.



Ron Ingram
Ranch Hand

Joined: Mar 11, 2011
Posts: 63
This is the actual stacktrace:
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

My guess: the comma at line 52 (in your posted code).
Ron Ingram
Ranch Hand

Joined: Mar 11, 2011
Posts: 63
That was it! Must have been a copy & paste error for the last update variable.

Thank you for your help. R
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: SQL Syntax Error for MySQL but not sure where...
 
Similar Threads
Derby Embedded Database: errors in connection code
BMP, Jboss, and mysql configuring
Out of Memory when testing a BMP Bean
What is wrong?
Filtering Result Sets based on selectable links (a href:)