Exception when updating Oracle NVARCHAR2 columns
ileitch Oct 26, 2012 4:07 PMIs there a workaround for this?
Thanks
Test SQL = “Update Test set TestNVarCharCol=’TESTVARCHAR’”;
26-Oct-2012 1:36:51 PM org.teiid.logging.JavaLogger log
WARNING: Connector worker process failed for atomic-request=vKWKHHO7tamG.0.0.0
org.teiid.translator.jdbc.JDBCExecutionException: 17004 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: ['TESTVARCHAR'] SQL: UPDATE "TESTADMIN"."TEST" SET "TestNVarCharCol" = ?]
at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:211)
at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:71)
at com.lgc.edm.teiid.translator.EdmUpdateExecution.execute(EdmUpdateExecution.java:34)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:276)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:241)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:355)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:144)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:141)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:116)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:245)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Invalid column type
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3088)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3107)
at org.teiid.translator.jdbc.JDBCExecutionFactory.bindValue(JDBCExecutionFactory.java:830)
at org.teiid.translator.jdbc.oracle.OracleExecutionFactory.bindValue(OracleExecutionFactory.java:476)
at org.teiid.translator.jdbc.JDBCBaseExecution.bind(JDBCBaseExecution.java:101)
at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:203)
... 16 more
WARNING: TEIID30020 Processing exception 'TEIID30504 Edm: 17004 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: ['TESTVARCHAR'] SQL: UPDATE "TESTADMIN"."TEST" SET "TestNVarCharCol" = ?]' for request vKWKHHO7tamG.0. Exception type org.teiid.core.TeiidProcessingException thrown from oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134). Enable more detailed logging to see the entire stacktrace.