                        课程
                    
                        /后端开发
                        
                            /Java
                        
                        /Java高并发秒杀API之业务分析与DAO层

SuccessKilledDaoTest中的queryByIdWithSeckill()报错了，org.springframework.dao.TransientDataAccessResourceException，为什么呢？

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

qq_茶味人生_0

2018-05-24

源自：Java高并发秒杀API之业务分析与DAO层 4-9

关注问题我要回答

3015

操作

收起

2 回答

慕函数9743669 回答被采纳 +2 积分
2018-06-03

原因是create_time字段没有给默认值,因此在插入时,数据库默认为:00000000,全0数值,mysql认为其为无效取值;

解决方式:在数据库链接地址后添加?zeroDateTimeBehavior=convertToNull

2 回复有任何疑惑可以回复我~

收起回答

qq_茶味人生_0 提问者

应该是这个原因，我的mysql是8.0版本的，这个方法好像不管用，最后是DEFAULT CURRENT_TIMESTAMP，取默认值解决的

2018-06-18 回复有任何疑惑可以回复我~

weixin_慕移动7203029
2019-10-05

`create_time` timestamp not null default current_timestamp comment '创建时间'
为什么这样写在执行insertSuccessKilled方法插入时create_time为null？

0 回复有任何疑惑可以回复我~

收起回答

JA_JA

`create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'。检查你创建表success_killed时，有没有设置create_time默认值。

2020-05-18 回复有任何疑惑可以回复我~

0/150

提交

取消

Java高并发秒杀API之业务分析与DAO层

参与学习 87437 人
解答问题 496 个

Java实现高并发秒杀API的第一门课，还等什么，赶快来加入吧

进入课程

本课相似问答

2 回答SuccessKilledDaoTest报错

2 回答SuccessKilledDaoTest为什么在测试的时候会报错

2 回答为什么@Resource注入报错，@Autowired注入就可以呢？？

4 回答执行insertSuccessKilled方法后create_time字段为null，导致queryByIdWithSeckill方法执行错误

2 回答sql连接没错呀，为什么一直报错无法连接呢？求指导

搜索更多本课相关问答

SuccessKilledDaoTest中的queryByIdWithSeckill()报错了，org.springframework.dao.TransientDataAccessResourceException，为什么呢？

我要回答关注问题

热搜

最近搜索清空

SuccessKilledDaoTest​中的queryByIdWithSeckill()报错了，org.springframework.dao.TransientDataAccessResourceException，为什么呢？

2 回答

本课相似问答

SuccessKilledDaoTest​中的queryByIdWithSeckill()报错了，org.springframework.dao.TransientDataAccessResourceException，为什么呢？

SuccessKilledDaoTest中的queryByIdWithSeckill()报错了，org.springframework.dao.TransientDataAccessResourceException，为什么呢？

SuccessKilledDaoTest中的queryByIdWithSeckill()报错了，org.springframework.dao.TransientDataAccessResourceException，为什么呢？