oracle jdbc driver 11.2.0.3.0,Oracle JDBC 11.2.0.2.0 doesn't support NVARCHAR2: Invalid column type

最新推荐文章于 2022-12-21 08:35:11 发布

东坡不改了

最新推荐文章于 2022-12-21 08:35:11 发布

阅读量458

点赞数

文章标签： oracle jdbc driver 11.2.0.3.0

ODI_11.1.1.3

Oracle JDBC driver version 11.1.0.7.0 (ojdb6.jar) raises an error while mapping over 100 columns in one interface:

17173 : 99999 : java.sql.BatchUpdateException: Not all return parameters registered17173 : 99999 : java.sql.SQLException: Not all return parameters registered

java.sql.BatchUpdateException: Not all return parameters registered

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9467)

at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)

at com.sunopsis.sql.SnpsQuery.executeBatch(SnpsQuery.java:527)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeUpdate(SnpSessTaskSql.java:3038)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java:729)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2815)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:322)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:246)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:237)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:794)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

at java.lang.Thread.run(Thread.java:736)

After updating driver version to 11.2.0.2.0, this problem was solved.

But this driver does not support data type "NVARCHAR2":

17004 : 99999 : java.sql.SQLException: Invalid column type

java.sql.SQLException: Invalid column type

at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8761)

at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8259)

at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8820)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:238)

at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java:2165)

at com.sunopsis.sql.SnpsQuery.addBatch(SnpsQuery.java:122)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeUpdate(SnpSessTaskSql.java:3034)