[infinispan-issues] [JBoss JIRA] (ISPN-3689) Preloading fails with JdbcBinaryCacheStore on DB2

Preloading fails with JdbcBinaryCacheStore on DB2 -------------------------------------------------- Key: ISPN-3689 URL: https://issues.jboss.org/browse/ISPN-3689 Project: Infinispan Issue Type: Bug Security Level: Public(Everyone can see) Components: Loaders and Stores Affects Versions: 5.2.7.Final, 6.0.0.CR1 Environment: DB2 9.7.5 Reporter: Nicolas Filotto Assignee: Mircea Markus Fix For: 7.0.0.Alpha4, 5.2.9.Final I use the {{JdbcBinaryCacheStore}} with preloading enabled, when I test it on DB2 I get an exception of type: {code} 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) {code} I looks like you cannot use a parameter to set your query limit in case of DB2 9.7.5 at least