MySQL Syntax Exception

I have following SQL :

UPDATE TABLE_NAME SET FIELD_NAME = FIELD_NAME -1 WHERE ANOTHER_FIELD_NAME= 311;

I get success when i run this query directly from query browser.

However, through my java program, when i create a preparedStatement and call its execute() method it throws following MySQL Syntax Exception.

Other Details :

MySQL Connector Jar - mysql-connector-java-5.1.15-bin.jar
MySQL Version : 5.1
OS : CentOs 5.1

Ketul Parikh wrote:I have following SQL :

UPDATE TABLE_NAME SET FIELD_NAME = FIELD_NAME -1 WHERE ANOTHER_FIELD_NAME= 311;

I get success when i run this query directly from query browser.

However, through my java program, when i create a preparedStatement and call its execute() method it throws following MySQL Syntax Exception.

Other Details :

MySQL Connector Jar - mysql-connector-java-5.1.15-bin.jar
MySQL Version : 5.1
OS : CentOs 5.1

can you post the code where you create the preparedStatement?

and post the Syntax Exception? I think you forgot to paste it in there.

Tim McGuire wrote:

can you post the code where you create the preparedStatement?

and post the Syntax Exception? I think you forgot to paste it in there.