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

来源：互联网发布：淘宝用户说怎么设置编辑：程序博客网时间：2024/06/11 06:25

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