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)
3 回答
-
onetwosix額，我想看sql語句啊，這個是symmetric這個軟件，我用這個軟件同步數據庫時候報出的java連接數據庫這個問題。
醉清風tomorrow
TA貢獻64條經驗 獲得超48個贊
org.jumpmind.db.sql.SqlException: 列名 'store_id' 無效。你把你的sql語句放到數據庫里面運行一下，應該是store_id這個字段沒有或者你寫錯了
-
onetwosix額，我想看sql語句啊，這個是symmetric這個軟件，我用這個軟件同步數據庫時候報出的java連接數據庫這個問題。
