This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
 
Consider Paul's rocket mass heater.
 
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:)