ODI 11g Execution Fails with "java.sql.SQLException: statement is not in batch mode"
(Doc ID 1530553.1)
Last updated on MARCH 29, 2024
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 <TASK> (Loading) fails on the target XML connection <TARGET>.
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)
...
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |