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

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)