Caused by: java.sql.SQLException: 无效的列索引

打印出拼写的sql    delete from XI_CATENTRY where store_id=? and catentry_id in (,?,?,?)

sql语句错误

org.springframework.jdbc.InvalidResultSetAccessException: PreparedStatementCallback; invalid ResultSet access for SQL []; nested exception is java.sql.SQLException: 无效的列索引

    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:224)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
    at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
    at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:815)
    at com.xiu.search.good.GoodSearchIndexHelper.deleteGoodBasicInfo(GoodSearchIndexHelper.java:420)
    at com.xiu.search.good.GoodSearchIndexHelper.cleanData(GoodSearchIndexHelper.java:314)
    at com.xiu.search.good.GoodSearchIndexHelper.updateSearchIndexes4GoodPriceChanges(GoodSearchIndexHelper.java:94)
    at com.xiu.search.good.integration.MultipleGoodsPriceChangedMessageHandlerImpl.execute(MultipleGoodsPriceChangedMessageHandlerImpl.java:194)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: java.sql.SQLException: 无效的列索引
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
    at oracle.jdbc.driver.OraclePreparedStatement.setLongInternal(OraclePreparedStatement.java:4734)
    at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9076)
    at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8843)
    at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9565)
    at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9548)
    at com.xiu.search.good.GoodSearchIndexHelper$3.createPreparedStatement(GoodSearchIndexHelper.java:413)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:585)
    ... 8 more