| Description | "For some reason a incoming batch with equal ""row_data"" and ""old_data"" data fails (no changes, but the trigger has been activated some how). the generated SQL becomes: ""update App.Orders set where `id` = ?"" and this fails. unchanged rows should be skipped. I think this is missing from TableTemplate.update . I'm using MySQL 5.1.42 (MariaDB) with InnoDB on Ubuntu. {code} 2010-03-16 16:26:43,677 ERROR [impl.DataLoaderService] [pulljob] Failed to load batch 00000-621 because: PreparedStatementCallback; bad SQL grammar [update App.Orders set where `id` = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where `id` = 32801' at line 1 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [update App.Orders set where `id` = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where `id` = 32801' at line 1 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867) at org.jumpmind.symmetric.load.TableTemplate.execute(TableTemplate.java:304) at org.jumpmind.symmetric.load.TableTemplate.update(TableTemplate.java:177) at org.jumpmind.symmetric.load.csv.CsvLoader.update(CsvLoader.java:311) at org.jumpmind.symmetric.load.csv.CsvLoader.load(CsvLoader.java:142) at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy12.load(Unknown Source) at org.jumpmind.symmetric.service.impl.DataLoaderService$TransactionalLoadDelegate.doInTransaction(DataLoaderService.java:530) at org.jumpmind.symmetric.service.impl.DataLoaderService$TransactionalLoadDelegate.doInTransaction(DataLoaderService.java:1) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadBatch(DataLoaderService.java:499) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataAndReturnBatches(DataLoaderService.java:207) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadData(DataLoaderService.java:115) at org.jumpmind.symmetric.service.impl.PullService.pullData(PullService.java:63) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy12.load(Unknown Source) at org.jumpmind.symmetric.service.impl.DataLoaderService$TransactionalLoadDelegate.doInTransaction(DataLoaderService.java:530) at org.jumpmind.symmetric.service.impl.DataLoaderService$TransactionalLoadDelegate.doInTransaction(DataLoaderService.java:1) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadBatch(DataLoaderService.java:499) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataAndReturnBatches(DataLoaderService.java:207) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadData(DataLoaderService.java:115) at org.jumpmind.symmetric.service.impl.PullService.pullData(PullService.java:63) at org.jumpmind.symmetric.job.PullJob.doJob(PullJob.java:34) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:84) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462) {code} {code}" |
|---|