java连接数据库报的一个异常看不懂

Question

org.jumpmind.db.sql.SqlException: 列名 'store_id' 无效。

at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:283)

at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:274)

at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:487)

at org.jumpmind.db.sql.JdbcSqlTemplate.queryForObject(JdbcSqlTemplate.java:150)

at org.jumpmind.db.sql.AbstractSqlTemplate.queryForInt(AbstractSqlTemplate.java:66)

at org.jumpmind.symmetric.service.impl.DataService.insertLoadBatchesForReload(DataService.java:878)

at org.jumpmind.symmetric.service.impl.DataService.insertReloadEvents(DataService.java:443)

at org.jumpmind.symmetric.service.impl.DataService.insertReloadEvents(DataService.java:339)

at org.jumpmind.symmetric.service.impl.RouterService.insertInitialLoadEvents(RouterService.java:261)

at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:197)

at org.jumpmind.symmetric.job.RouterJob.doJob(RouterJob.java:40)

at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:180)

at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:224)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Answer 1

把你的sql语句放上来啊

Answer 2

org.jumpmind.db.sql.SqlException: 列名 'store_id' 无效。你把你的sql语句放到数据库里面运行一下，应该是store_id这个字段没有或者你写错了

Answer 3

查一下数据库表里面和类里面'store_id'这个类名是不是一样的