[crk_16]

Facing “execution completed with warning” exception when trying to load CLOB data into string…
IBATIS is only sometimes able to retrieve the clob correctly, but failing at other times.
Mapping in ibatis sql map file
<result property=”data” column=”column” jdbcType=”CLOB” />

Stack trace is as follows…
Caused by: java.sql.SQLException: execution completed with warning
at oracle.jdbc.driver.DatabaseError.newSqlException(DatabaseError.java:80)
at oracle.jdbc.driver.DatabaseError.newSqlException(DatabaseError.java:98)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:817)
at oracle.jdbc.driver.T4C8TTIClob.read(T4C8TTIClob.java:181)
at oracle.jdbc.driver.T4CConnection.getChars(T4CConnection.java:2008)
at oracle.sql.CLOB.getChars(CLOB.java:326)
at oracle.sql.CLOB.getSubString(CLOB.java:223)
at com.ibatis.sqlmap.engine.type.ClobTypeHandlerCallback.getResult(ClobTypeHandlerCallback.java:31)
at com.ibatis.sqlmap.engine.type.CustomTypeHandler.getResult(CustomTypeHandler.java:52)
at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMappingValue(BasicResultMap.java:516
)
at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicResultMap.java:275)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:354)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:179)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:16
9)

Help on this will be really appreciated

[Loyal Water]

Moving to Off Topic >> Software Development.

[Author]

Posts