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

runawfe | erickv | 4 years ago
  1. 0

    SQL Action Handler + IF in statement

    runawfe | 4 years ago | erickv
    java.sql.SQLException: Unexpected token: IF in statement
  2. 0

    ERRO JPA + JSF

    Google Groups | 6 years ago | Roan
    org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    [jboss-user] [Beginners Corner] - javax.ejb.EJBException: javax.persistence.PersistenceExcepti

    jboss.org | 11 months ago
    javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Community • View topic - problems with hbm2ddl using hsqldb

    hibernate.org | 11 months ago
    java.lang.AssertionError: javax.el.ELException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
  6. 0

    Insert of received audt messages fails with: {noformat} java.sql.SQLException: 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=?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:344) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561) at org.hibernate.loader.Loader.doQuery(Loader.java:661) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) ... 54 more {noformat}

    JIRA | 1 decade ago | Gunter Zeilinger
    java.sql.SQLException: 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=?]

    8 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Unexpected token: IF in statement

      at org.hsqldb.jdbc.Util.throwError()
    2. HSQLDB
      jdbcConnection.prepareStatement
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      3. org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      3 frames
    3. JBoss Application Server Connector
      WrappedConnection.prepareStatement
      1. org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:449)
      2. org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:437)
      3. org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243)
      3 frames
    4. ru.runa.wf
      SQLActionHandler.execute
      1. ru.runa.wf.SQLActionHandler.execute(SQLActionHandler.java:93)
      1 frame
    5. org.jbpm.graph
      Node.enter
      1. org.jbpm.graph.def.Action.execute(Action.java:127)
      2. org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:282)
      3. org.jbpm.graph.def.GraphElement.executeActions(GraphElement.java:239)
      4. org.jbpm.graph.def.GraphElement.fireAndPropagateEvent(GraphElement.java:211)
      5. org.jbpm.graph.def.GraphElement.fireEvent(GraphElement.java:194)
      6. org.jbpm.graph.def.Transition.take(Transition.java:134)
      7. org.jbpm.graph.def.Node.leave(Node.java:447)
      8. org.jbpm.graph.exe.ExecutionContext.leaveNode(ExecutionContext.java:135)
      9. org.jbpm.graph.node.Decision.execute(Decision.java:162)
      10. org.jbpm.graph.def.Node.enter(Node.java:357)
      10 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    7. Hibernate
      JavassistLazyInitializer.invoke
      1. org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:173)
      1 frame