hibernate throwing: An unexpected token "" was found following ""

Question

I have a native SQL query that i want to run through hibernate, but throws an error:

org.hibernate.exception.SQLGrammarException:
could not execute native bulk manipulation query
Caused by: 
com.ibm.db2.jcc.am.SqlSyntaxErrorException: An unexpected token ""
was found following "".  Expected tokens may include:  "NQ_EXE_ID = 12345"

the code i run to perform update is:

SQLQuery updateQuery = getSession().createSQLQuery(updateSql);
System.out.println(updateQuery.getQueryString());    
updateQuery.executeUpdate();

during debug i can see inside the SQLQuery object and the sql is: (which runs fine in db2)

UPDATE some_table SET DEST_FLDR = 'some_value' ,
LST_CHG_TMS = CURRENT TIMESTAMP
WHERE SUB_RUN_ID = 111111    
AND INQ_EXE_ID = 12345   ;

if i manually run the sql produced by the code above, it will execute fine. However when i try to do it through hibernate it throws the 'syntaxErrorException'. Any ideas? Thanks

Do you really have that semi-colon at the end of the query? If yes, then remove it. — JB Nizet, Oct 02 '13 at 12:26
HAAA! oh my god, what a jackass ;) that was it. funny though, it ran with the semi-colon no problem when i manually executed it through my Db manager. Thanks! — cianBuckley, Oct 02 '13 at 12:29
What is your hibernate dialect for db2 in your configuration? — erencan, Oct 02 '13 at 12:29
@JB Nizet put your answer in the answers part, and not here in the comments. — AngocA, Oct 02 '13 at 12:55

score 7 · Answer 1 · answered Oct 02 '13 at 13:27

7

The problem is caused by the semicolon at the end of the query. The PostgreSQL SQL tool you use wants it because it allows separating multiple queries, but to execute individual queries via a Java statement, the semi-colon must not be there.

answered Oct 02 '13 at 13:27

JB Nizet

678,734
91
1,224
1,255

hibernate throwing: An unexpected token "" was found following ""

1 Answers1