-
Bug
-
Resolution: Done
-
Major
-
JDG 7.2 ER3
-
None
Following error appears in many tests on the environment (with some variation):
[0m[31m06:13:37,765 ERROR [org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore] (default task-12) ISPN008024: Error while storing string key to database; key: 'key1': java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got BLOB
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
...
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:159)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:144)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:124)
at org.infinispan.persistence.jdbc.mixed.JdbcMixedStore.write(JdbcMixedStore.java:134)
at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:514)
...
at org.infinispan.cache.impl.EncoderCache.put(EncoderCache.java:663)
at com.jboss.datagrid.test.jdbcstore.MixedCacheStoreIT.testPutGetRemoveWithPassivationWithoutPreload(MixedCacheStoreIT.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 932, Position : 112, Sql = MERGE INTO "mix_str___defaultcache" t USING (SELECT :1 datum, :2 timestamp, :3 id from dual) tmp ON (t.id = tmp.id) WHEN MATCHED THEN UPDATE SET t.datum = tmp.datum, t.timestamp = tmp.timestamp WHEN NOT MATCHED THEN INSERT VALUES (tmp.id, tmp.datum, tmp.timestamp), OriginalSql = MERGE INTO "mix_str___defaultcache" t USING (SELECT ? datum, ? timestamp, ? id from dual) tmp ON (t.id = tmp.id) WHEN MATCHED THEN UPDATE SET t.datum = tmp.datum, t.timestamp = tmp.timestamp WHEN NOT MATCHED THEN INSERT VALUES (tmp.id, tmp.datum, tmp.timestamp), Error Msg = ORA-00932: inconsistent datatypes: expected - got BLOB
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 234 more