Getting MySQL error java.sql.SQLException: Cannot convert value '2018-10-17 13:02:07.000000' from column 2 to TIMESTAMP.

[Former Member]

Exception in thread "TaskExecutor-master-314" de.hybris.platform.persistence.hjmp.HJMPException: java.sql.SQLException: Cannot convert value '2018-10-17 13:02:07.000000' from column 2 to TIMESTAMP. at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState.setStateFromResultSet(GenericBMPBean.java:1329) at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState.(GenericBMPBean.java:1221) at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityStateCacheUnit.compute(GenericBMPBean.java:1965) at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:305) at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:278) at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:180) at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityStateCacheUnit.getEntityState(GenericBMPBean.java:1937) at de.hybris.platform.persistence.GenericBMPBean.ejbFindByPrimaryKey(GenericBMPBean.java:845) at de.hybris.platform.persistence.framework.PersistencePool.findEntityByPK(PersistencePool.java:288) at de.hybris.platform.persistence.SystemEJB.findRemoteObjectByPKInternal(SystemEJB.java:102) at de.hybris.platform.persistence.SystemEJB.findRemoteObjectByPK(SystemEJB.java:84) at de.hybris.platform.core.WrapperFactory$2.compute(WrapperFactory.java:445) at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:305) at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:278) at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:180) at de.hybris.platform.jalo.JaloItemCacheUnit.getCached(JaloItemCacheUnit.java:110) at de.hybris.platform.core.WrapperFactory.getCachedItem(WrapperFactory.java:462) at de.hybris.platform.jalo.JaloSession.lookupItem(JaloSession.java:1817) at de.hybris.platform.jalo.JaloSession.getItem(JaloSession.java:1903) at de.hybris.platform.task.impl.DefaultTaskService.getScheduledItem(DefaultTaskService.java:1481) at de.hybris.platform.task.impl.DefaultTaskService.process(DefaultTaskService.java:1532) at de.hybris.platform.task.impl.DefaultTaskService.processInTenant(DefaultTaskService.java:1511) at de.hybris.platform.task.impl.DefaultTaskService$5.run(DefaultTaskService.java:1379) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) at de.hybris.platform.core.threadregistry.RegistrableThread.internalRun(RegistrableThread.java:145) at de.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:135) Caused by: java.sql.SQLException: Cannot convert value '2018-10-17 13:02:07.000000' from column 2 to TIMESTAMP. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1337) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:576) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6754) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6073) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6111) at de.hybris.platform.jdbcwrapper.ResultSetImpl.getTimestamp(ResultSetImpl.java:407) at de.hybris.platform.persistence.property.JDBCValueMappings$DefaultDateTimestampValueReaderWriter.readValue(JDBCValueMappings.java:1641) at de.hybris.platform.persistence.property.JDBCValueMappings$DefaultDateTimestampValueReaderWriter.readValue(JDBCValueMappings.java:1) at de.hybris.platform.persistence.property.JDBCValueMappings$AbstractValueReaderWriter.getValue(JDBCValueMappings.java:525) at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState.setStateFromResultSet(GenericBMPBean.java:1305) ... 27 more

==================

Below MySql(5.7) data base configuration i did in local.properties

db.url=jdbc:mysql://localhost:3306/MyDB?useUnicode=true&useFastDateParsing=false&zeroDateTimeBehavior=convertToNull&autoReconnect=true&characterEncoding=UTF-8&characterSetResults=UTF-8

db.driver=com.mysql.jdbc.Driver

db.username=Test

db.password=testdbpwd

mysql.optional.tabledefs=CHARSET=utf8 COLLATE=utf8_bin

mysql.tabletype=InnoDB

[Former Member · Accepted solution]

Can you please check the version of the JDBC connector you are using, mysql-connector-java-5.1.46.jar should work just fine. Can you please try with that once and confirm

[Former Member · Accepted solution]

Thanks Himanshu.

I have used 5.7 connector then issue got resolve. Old version is not compatible therefore getting error during server startup.