ODI 11g Execution Fails With "java.sql.SQLException: statement is not in batch mode" (Doc ID 1530553.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.5.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

The execution of an Oracle Data Integrator (ODI) 11g flow to load data into XML fails, and following message is captured in the stack trace:

ODI-1228: Task SS_0 (Loading) fails on the target XML connection xxxxx.
Caused By: java.sql.SQLException: statement is not in batch mode
  at com.sunopsis.jdbc.driver.xml.SnpsXmlPreparedStatementRedirector.executeBatch(SnpsXmlPreparedStatementRedirector.java:711)
...
Caused By: 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)
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms