Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-3689

Preloading fails with JdbcBinaryCacheStore on DB2

    Details

      Description

      I use the JdbcBinaryCacheStore with preloading enabled, when I test it on DB2 I get an exception of type:

      06.11.2013 16:27:51 *ERROR* [main] DataManipulationHelper: ISPN008007: SQL error while fetching all StoredEntries (DataManipulationHelper.java, line 253)
      com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=?;r_quota" FETCH FIRST;<space>, DRIVER=4.13.80
      	at com.ibm.db2.jcc.am.id.a(id.java:677)
      	at com.ibm.db2.jcc.am.id.a(id.java:60)
      	at com.ibm.db2.jcc.am.id.a(id.java:127)
      	at com.ibm.db2.jcc.am.fo.c(fo.java:2653)
      	at com.ibm.db2.jcc.am.fo.d(fo.java:2641)
      	at com.ibm.db2.jcc.am.fo.a(fo.java:2090)
      	at com.ibm.db2.jcc.am.go.a(go.java:7639)
      	at com.ibm.db2.jcc.t4.cb.h(cb.java:141)
      	at com.ibm.db2.jcc.t4.cb.b(cb.java:41)
      	at com.ibm.db2.jcc.t4.q.a(q.java:32)
      	at com.ibm.db2.jcc.t4.sb.i(sb.java:135)
      	at com.ibm.db2.jcc.am.fo.ib(fo.java:2059)
      	at com.ibm.db2.jcc.am.go.sc(go.java:3555)
      	at com.ibm.db2.jcc.am.go.b(go.java:4344)
      	at com.ibm.db2.jcc.am.go.fc(go.java:741)
      	at com.ibm.db2.jcc.am.go.executeQuery(go.java:711)
      	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      	at org.infinispan.loaders.jdbc.DataManipulationHelper.loadSome(DataManipulationHelper.java:245)
      	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.loadLockSafe(JdbcBinaryCacheStore.java:312)
      	at org.infinispan.loaders.LockSupportCacheStore.load(LockSupportCacheStore.java:167)
      	at org.infinispan.loaders.CacheLoaderManagerImpl.loadState(CacheLoaderManagerImpl.java:285)
      	at org.infinispan.loaders.CacheLoaderManagerImpl.preload(CacheLoaderManagerImpl.java:238)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:203)
      	at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:886)
      	at org.infinispan.factories.AbstractComponentRegistry.invokeStartMethods(AbstractComponentRegistry.java:657)
      	at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:646)
      	at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:549)
      	at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:217)
      	at org.infinispan.CacheImpl.start(CacheImpl.java:582)
      	at org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:686)
      	at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:649)
      	at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:545)
      

      I looks like you cannot use a parameter to set your query limit in case of DB2 9.7.5 at least

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                mircea.markus Mircea Markus
                Reporter:
                nfilotto Nicolas Filotto
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: