java.sql.SQLException: Unexpected token: IF in statement

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via runawfe by erickv
, 1 year ago
Unexpected token: IF in statement
via JIRA by Gunter Zeilinger, 1 year ago
S1000 General error java.lang.ArrayIndexOutOfBoundsException: 2 in statement [select code0_.pk as pk0_, code0_.code_value as code2_0_, code0_.code_designator as code3_0_, code0_.code_meaning as code4_0_, CONCAT(code0_.code_value, '^', code0_.code_designator) as formula0_ from code code0_ where code0_.code_value=? and code0_.code_designator=?]
via Google Groups by Joney, 4 months ago
Unexpected token in statement [select * from message where message_id like ? and message_box like ? and as2_from like ? and as2_to like ? and principal_id like ? and status like ? and trim(upper(is_receipt)) = 'FALSE' order by time_stamp desc LIMIT ? offset ?]
via hsqldb by txie
, 1 year ago
Table not found in statement \[DELETE FROM TradeData\]
via hsqldb by arconet1
, 1 year ago
Unexpected token: ROW_NUMBER in statement [select * from (select row_number() over (partition by....
via Jive Software Open Source by Daryl Herzmann, 1 year ago
Unexpected token: JOIN in statement [DELETE FROM ofPubsubItem LEFT JOIN (SELECT id FROM ofPubsubItem WHERE serviceID=? AND nodeID=? ORDER BY creationDate DESC LIMIT ?) AS noDelete ON ofPubsubItem.id = noDelete.id WHERE noDelete.id IS NULL AND ofPubsubItem.serviceID = ? AND nodeID = ?]
java.sql.SQLException: Unexpected token: IF in statement
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:449)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:437)
at ru.runa.wf.SQLActionHandler.execute(SQLActionHandler.java:93)
at org.jbpm.graph.def.Action.execute(Action.java:127)
at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:282)
at org.jbpm.graph.def.GraphElement.executeActions(GraphElement.java:239)
at org.jbpm.graph.def.GraphElement.fireAndPropagateEvent(GraphElement.java:211)
at org.jbpm.graph.def.GraphElement.fireEvent(GraphElement.java:194)
at org.jbpm.graph.def.Transition.take(Transition.java:134)
at org.jbpm.graph.def.Node.leave(Node.java:447)
at org.jbpm.graph.exe.ExecutionContext.leaveNode(ExecutionContext.java:135)
at org.jbpm.graph.node.Decision.execute(Decision.java:162)
at org.jbpm.graph.def.Node.enter(Node.java:357)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 10 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.