File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 18127
    
    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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Syntax Error for MySQL but not sure where...
 
Similar Threads
Out of Memory when testing a BMP Bean
BMP, Jboss, and mysql configuring
Filtering Result Sets based on selectable links (a href:)
Derby Embedded Database: errors in connection code
What is wrong?