org.springframework.dao.TransientDataAccessResourceException: Error attempting to get column 'create_time' from result set.? Cause: java.sql.SQLException: Zero date value prohibited
; SQL []; Zero date value prohibited; nested exception is java.sql.SQLException: Zero date value prohibited
?? ?at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:108)
?? ?at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
?? ?at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
?? ?at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
?? ?at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
?? ?at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399)
?? ?at com.sun.proxy.$Proxy13.selectOne(Unknown Source)
?? ?at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:165)
?? ?at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:69)
?? ?at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
?? ?at com.sun.proxy.$Proxy14.queryByIdWithSeckill(Unknown Source)
?? ?at cn.codingxiaxw.dao.SuccessKilledDaoTest.queryByIdWithSeckill(SuccessKilledDaoTest.java:37)
?? ?at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
?? ?at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
?? ?at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
?? ?at java.lang.reflect.Method.invoke(Unknown Source)
?? ?at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
?? ?at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
?? ?at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
?? ?at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
?? ?at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:73)
?? ?at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:82)
?? ?at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:73)
?? ?at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
?? ?at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:224)
?? ?at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:83)
?? ?at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
?? ?at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
?? ?at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
?? ?at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
?? ?at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
?? ?at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
?? ?at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:68)
?? ?at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
?? ?at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:163)
?? ?at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
?? ?at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
?? ?at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:538)
?? ?at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:760)
?? ?at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:460)
?? ?at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:206)
Caused by: java.sql.SQLException: Zero date value prohibited
?? ?at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)
?? ?at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
?? ?at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)
?? ?at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)
?? ?at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)
?? ?at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:99)
?? ?at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:937)
?? ?at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:980)
?? ?at com.mchange.v2.c3p0.impl.NewProxyResultSet.getTimestamp(NewProxyResultSet.java:3394)
?? ?at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
?? ?at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
?? ?at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
?? ?at java.lang.reflect.Method.invoke(Unknown Source)
?? ?at org.apache.ibatis.logging.jdbc.ResultSetLogger.invoke(ResultSetLogger.java:68)
?? ?at com.sun.proxy.$Proxy18.getTimestamp(Unknown Source)
?? ?at org.apache.ibatis.type.DateTypeHandler.getNullableResult(DateTypeHandler.java:39)
?? ?at org.apache.ibatis.type.DateTypeHandler.getNullableResult(DateTypeHandler.java:28)
?? ?at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:66)
?? ?at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyAutomaticMappings(DefaultResultSetHandler.java:434)
?? ?at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:344)
?? ?at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:298)
?? ?at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:273)
?? ?at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:246)
?? ?at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:160)
?? ?at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
?? ?at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)
?? ?at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
?? ?at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
?? ?at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
?? ?at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
?? ?at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
?? ?at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)
?? ?at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)
?? ?at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73)
?? ?at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
?? ?at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
?? ?at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
?? ?at java.lang.reflect.Method.invoke(Unknown Source)
?? ?at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
?? ?... 35 more
Caused by: com.mysql.cj.exceptions.DataReadException: Zero date value prohibited
?? ?at com.mysql.cj.result.SqlTimestampValueFactory.createFromTimestamp(SqlTimestampValueFactory.java:91)
?? ?at com.mysql.cj.result.SqlTimestampValueFactory.createFromTimestamp(SqlTimestampValueFactory.java:44)
?? ?at com.mysql.cj.result.BaseDecoratingValueFactory.createFromTimestamp(BaseDecoratingValueFactory.java:58)
?? ?at com.mysql.cj.result.BaseDecoratingValueFactory.createFromTimestamp(BaseDecoratingValueFactory.java:58)
?? ?at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeTimestamp(MysqlTextValueDecoder.java:183)
?? ?at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:73)
?? ?at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:233)
?? ?at com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91)
?? ?at com.mysql.cj.jdbc.result.ResultSetImpl.getNonStringValueFromRow(ResultSetImpl.java:628)
?? ?at com.mysql.cj.jdbc.result.ResultSetImpl.getDateOrTimestampValueFromRow(ResultSetImpl.java:641)
?? ?... 68 more