java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • SQL Action Handler + IF in statement
    via runawfe by erickv
    ,
  • ERRO JPA + JSF
    via by Roan,
  • 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}
    via by Gunter Zeilinger,
  • Problem when a CMP-finder gets to much results
    via by Oliver Rensen,
    • java.sql.SQLException: Unexpected token: IF in statement 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:449) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:437) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243) 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) at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:173)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    5 more bugmates