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'这个类名是不是一样的