BUG记录：

jdk1.7 + mysql 5.6
使用hibernate存储数据时 报错：

2016-05-27 17:29:21,218 (SysUserService.java:454) ERROR - 注册用户保存出错：org.springframework.dao.DataIntegrityViolationException: could not insert: [com.tydic.vop.hb.SysUser]; SQL [insert into SYS_USER (CREATE_SYS_USER_ID, ABILITY_MNG_AGENT_ID, USER_ACCT, USER_NAME, LG_PASSWD, CREATE_TIME, EXPIRE_DATE, LAST_UPD_TIME, CONTACT_PHONE, EMAIL, BELONG_DEPARTMENT, JOB, IS_SMS_VALD, MNG_TYPE, LAST_LOGIN_TIME, DELETE_FLAG, DESCRIBES, REGISTER_ROLE_ID, VALID_FLAG) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [com.tydic.vop.hb.SysUser]    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:648)    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)    at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)    at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:737)    at com.tydic.commons.HibernateDaoHelper.save(HibernateDaoHelper.java:65)    at com.tydic.commons.AbstractDaoSupport.save(AbstractDaoSupport.java:139)    at com.tydic.vop.user.dao.SysUserDao.toSave(SysUserDao.java:36)    at com.tydic.vop.user.service.SysUserService.registerUser(SysUserService.java:451)    at com.tydic.vop.user.service.SysUserService$$FastClassByCGLIB$$f9c48800.invoke(<generated>)    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:701)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:634)    at com.tydic.vop.user.service.SysUserService$$EnhancerByCGLIB$$1db55bcd.registerUser(<generated>)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:606)    at com.tydic.commun.mng.VOPServiceSkeleton.service(VOPServiceSkeleton.java:46)    at com.tydic.commun.mng.VOPServiceMessageReceiverInOut.invokeBusinessLogic(VOPServiceMessageReceiverInOut.java:47)    at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)    at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)    at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:173)    at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:173)    at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:144)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)    at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230)    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)    at java.lang.Thread.run(Thread.java:745)Caused by: org.hibernate.exception.DataException: could not insert: [com.tydic.vop.hb.SysUser]    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2329)    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2836)    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268)    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:117)    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)    at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:677)    at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:669)    at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:665)    at org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:740)    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)    ... 63 moreCaused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2039-01-01 00:00:00' for column 'EXPIRE_DATE' at row 1    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3964)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)    at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)    at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)    at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)

原因 ：

//A timestamp. The range is '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' //UTC. TIMESTAMP values are stored as the number of seconds since the epoch ('1970-01-01 00:00:00' UTC). //A TIMESTAMP cannot represent the value '1970-01-01 00:00:00' because that is equivalent to 0 seconds from //the epoch and the value 0 is reserved for representing '0000-00-00 00:00:00', the “zero” TIMESTAMP value.