Uploaded image for project: 'Red Hat Data Grid'
  1. Red Hat Data Grid
  2. JDG-1566

Multiple failures in testing JDBC Library and Cachestore on Oracle DBs

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • JDG 7.2 ER5
    • JDG 7.2 ER3
    • Core
    • None
    • JDG Sprint #10

      Following error appears in many tests on the environment (with some variation):

      &amp#27;[0m&amp#27;[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

              remerson@redhat.com Ryan Emerson
              zhostasa_jira Zdenek Hostasa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: