[infinispan-issues] [JBoss JIRA] Resolved: (ISPN-480) JDBCBinaryCacheStore purgeExpired() SQL statement: not enough params bound

[Manik Surtani (JIRA)]

     [ https://jira.jboss.org/browse/ISPN-480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Manik Surtani resolved ISPN-480.
--------------------------------

    Resolution: Done


> JDBCBinaryCacheStore purgeExpired() SQL statement: not enough params bound
> --------------------------------------------------------------------------
>
>                 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 MySQL
>            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