打印出拼写的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