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

hivmr.com | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    db:: 4.14::ODI interface fails with error pj

    hivmr.com | 11 months ago
    java.sql.SQLException: statement is not in batch mode
  2. 0

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

    Oracle Community | 5 years ago | user591315
    java.sql.SQLException: statement is not in batch mode
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

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

    Oracle Community | 4 years ago | 903386
    java.sql.SQLException: statement is not in batch mode
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. org.hsqldb.HsqlException

    statement is not in batch mode

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)
    2. org.hsqldb.error.Error.error(Unknown Source)
    2 frames
  3. HSQLDB
    JDBCPreparedStatement.executeBatch
    1. org.hsqldb.jdbc.Util.sqlExceptionSQL(Unknown Source)
    2. org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
    2 frames
  4. oracle.odi.runtime
    DataMovementTaskExecutionHandler.handleTask
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.end(SQLCommand.java:267)
    2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:156)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:1)
    4. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:113)
    4 frames
  5. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
    5 frames
  6. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
    1 frame
  7. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  8. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  9. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame