12 Replies Latest reply on Jan 21, 2015 4:16 PM by kchen007

    Exception when updating Oracle NVARCHAR2 columns

    I Leitch Newbie

      Is 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.