Update - Observed the same behaviour on dybnamic portfolio. When i provide the values in the query instead of parameterization updates goes fine.
org.teiid.jdbc.TeiidSQLException: Error Code:TEIID30504 Message:Remote org.teiid.core.TeiidProcessingException: TEIID30504 h2-connector: 90026 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: ['?'] SQL: UPDATE "ACCOUNTS"."PUBLIC"."ACCOUNT" SET "TYPE" = ? WHERE "ACCOUNTS"."PUBLIC"."ACCOUNT"."ACCOUNT_ID" = 19980002]
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:654)
at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:565)
at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:102)
at $Proxy1.read(Unknown Source)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:574)
at org.teiid.jdbc.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:226)
at com.ca.test.ParameterRepalcementOnDynamicPortfolio.main(ParameterRepalcementOnDynamicPortfolio.java:19)
Caused by: [TeiidProcessingException] TEIID30504: Error Code:TEIID30504 Message:Remote org.teiid.core.TeiidProcessingException: TEIID30504 h2-connector: 90026 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: ['?'] SQL: UPDATE "ACCOUNTS"."PUBLIC"."ACCOUNT" SET "TYPE" = ? WHERE "ACCOUNTS"."PUBLIC"."ACCOUNT"."ACCOUNT_ID" = 19980002]
1 [TeiidException] 90026: Error Code:90026 Message:Remote org.teiid.translator.jdbc.JDBCExecutionException: 90026 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: ['?'] SQL: UPDATE "ACCOUNTS"."PUBLIC"."ACCOUNT" SET "TYPE" = ? WHERE "ACCOUNTS"."PUBLIC"."ACCOUNT"."ACCOUNT_ID" = 19980002]
2 [SQLException]Remote org.h2.jdbc.JdbcSQLException: Serialization failed, cause: "java.io.NotSerializableException: org.teiid.query.sql.symbol.Reference" [90026-161]
3 [NotSerializableException]Remote java.io.NotSerializableException: org.teiid.query.sql.symbol.Reference
at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:534)
at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:321)
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:279)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:149)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70)
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82)
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91)
at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:569)
at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68)
at org.teiid.query.processor.proc.ExecDynamicSqlInstruction$1.process(ExecDynamicSqlInstruction.java:196)
at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:379)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:306)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:280)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:149)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:384)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:250)
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.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: [TeiidException] 90026: Error Code:90026 Message:Remote org.teiid.translator.jdbc.JDBCExecutionException: 90026 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: ['?'] SQL: UPDATE "ACCOUNTS"."PUBLIC"."ACCOUNT" SET "TYPE" = ? WHERE "ACCOUNTS"."PUBLIC"."ACCOUNT"."ACCOUNT_ID" = 19980002]
1 [SQLException]Remote org.h2.jdbc.JdbcSQLException: Serialization failed, cause: "java.io.NotSerializableException: org.teiid.query.sql.symbol.Reference" [90026-161]
2 [NotSerializableException]Remote java.io.NotSerializableException: org.teiid.query.sql.symbol.Reference
at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:211)
at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:71)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:288)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:255)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:457)
at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:302)
... 36 more
Caused by: java.sql.SQLException: Remote org.h2.jdbc.JdbcSQLException: Serialization failed, cause: "java.io.NotSerializableException: org.teiid.query.sql.symbol.Reference" [90026-161]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.util.Utils.serialize(Utils.java:239)
at org.h2.value.DataType.convertToValue(DataType.java:945)
at org.h2.jdbc.JdbcPreparedStatement.setObject(JdbcPreparedStatement.java:452)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:957)
at org.teiid.translator.jdbc.JDBCExecutionFactory.bindValue(JDBCExecutionFactory.java:837)
at org.teiid.translator.jdbc.JDBCBaseExecution.bind(JDBCBaseExecution.java:101)
at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:203)
... 41 more
Caused by: java.io.NotSerializableException: Remote java.io.NotSerializableException: org.teiid.query.sql.symbol.Reference
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1180)
at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:346)
at org.h2.util.Utils.serialize(Utils.java:236)
... 47 more