[infinispan-issues] [JBoss JIRA] Commented: (ISPN-480) JDBCBinaryCacheStore generates CacheLoaderException

[Manik Surtani (JIRA)]

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

Manik Surtani commented on ISPN-480:
------------------------------------

Wow this was a real tough one to test (believe it or not!)

The H2 DB engine we use in our unit tests (in-memory database, easy cleanup, etc) didn't report such a glaring error as only binding 2 params instead of 3!  :)

This was pretty obvious after hacking the test suite to run against MySQL instead.

> JDBCBinaryCacheStore generates CacheLoaderException
> ---------------------------------------------------
>
>                 Key: ISPN-480
>                 URL: https://jira.jboss.org/browse/ISPN-480
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Loaders and Stores
>    Affects Versions: 4.1.0.BETA2
>         Environment: linux ubuntu
>            Reporter: Franck Garcia
>            Assignee: Manik Surtani
>            Priority: Critical
>             Fix For: 4.1.0.CR1
>
>
> I tried to copy a Lucene FSDirectory containing 6.3 M documents over an Infinispan Directory using the Lucene Directory.copy method.
> I used JdbcBinaryCacheStore as my store/loader. The following exception is thrown:
> 2010-05-27 11:35:16,263 ERROR (org.infinispan.loaders.jdbc.DataManipulationHelper)[luceneIndex-JdbcBinaryCacheStore-0:] Failed clearing JdbcBinaryCacheStore java.sql.BatchUpdateException: No value specified for parameter 3
>     at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1404)
>     at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>     at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.purgeInternal(JdbcBinaryCacheStore.java:325)
>     at org.infinispan.loaders.AbstractCacheStore$2.run(AbstractCacheStore.java:86)
>     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> (only 2 params are passed but the statement expects 3)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira