java.sql.SQLException: statement is not in batch mode

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.

  • db:: 4.14::ODI interface fails with error pj
    via by Unknown author,
  • ODI-1228: statement is not in batch mode Error
    via by Alvaro Soares,
  • Abacus Freezing at 30%
    via by Wallace Chan,
  • Help Running ABACUS
    via by David Gemperline,
    • java.sql.SQLException: statement is not in batch mode at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlExceptionSQL(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source) at oracle.odi.runtime.agent.execution.sql.SQLCommand.end(SQLCommand.java:267) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:156) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:1) at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:113) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82) at java.lang.Thread.run(Thread.java:662) Caused by: org.hsqldb.HsqlException: statement is not in batch mode at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) ... 19 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown User
    Unknown User2 times, last one,
    ivanszkypeter
    ivanszkypeter24 times, last one,
    marcbouvierdav
    marcbouvierdav12 times, last one,
    Axelo
    Axelo2 times, last one,
    92 more bugmates