| Description | Synchronizing columns with YEAR datatype in MySQL 5.1 fails with this error: {code} 2010-03-17 05:41:19,445 ERROR [impl.DataLoaderService] [pulljob] Failed to load batch 00000-2291 because: java.text.ParseException: Unable to parse the date: 2010 java.lang.RuntimeException: java.text.ParseException: Unable to parse the date: 2010 at org.jumpmind.symmetric.db.AbstractDbDialect.getTime(AbstractDbDialect.java:1129) at org.jumpmind.symmetric.db.AbstractDbDialect.getObjectValues(AbstractDbDialect.java:1086) at org.jumpmind.symmetric.load.TableTemplate.execute(TableTemplate.java:298) 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.GeneratedMethodAccessor68.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:515) 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) Caused by: java.text.ParseException: Unable to parse the date: 2010 at org.apache.commons.lang.time.DateUtils.parseDate(DateUtils.java:271) at org.jumpmind.symmetric.db.AbstractDbDialect.getTime(AbstractDbDialect.java:1127) ... 26 more {code} |
|---|