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

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12970032#comment-12970032 ] 

RH Bugzilla Integration commented on ISPN-3689:
-----------------------------------------------

Ladislav Thon <lthon at redhat.com> changed the Status of [bug 1087209|https://bugzilla.redhat.com/show_bug.cgi?id=1087209] from ON_QA to VERIFIED

> Preloading fails with JdbcBinaryCacheStore on DB2 
> --------------------------------------------------
>
>                 Key: ISPN-3689
>                 URL: https://issues.jboss.org/browse/ISPN-3689
>             Project: Infinispan
>          Issue Type: Bug
>          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



--
This message was sent by Atlassian JIRA
(v6.2.3#6260)