java.sql.SQLException: Value ’0000-00-00′ can not be represented as java.sql.Date 解決方案

項目中出現：

下面的異常Google了一下找到的原因是因為對資料庫的預設日期格式問題，解決方案：

在連接字串後面添加 zeroDateTimeBehavior=convertToNull

OK解決。

org.hibernate.exception.GenericJDBCException: could not execute query<br />at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)<br />at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)<br />at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br />at org.hibernate.loader.Loader.doList(Loader.java:2235)<br />at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)<br />at org.hibernate.loader.Loader.list(Loader.java:2124)<br />at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)<br />at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)<br />at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)<br />at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)<br />at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)<br />at com.mylegist.action.Index.members(Index.java:106)<br />at com.mylegist.action.Index.doPost(Index.java:50)<br />at com.mylegist.action.Index.doGet(Index.java:43)<br />at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)<br />at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br />at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br />at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br />at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br />at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br />at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<br />at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br />at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br />at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<br />at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)<br />at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<br />at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)<br />at java.lang.Thread.run(Thread.java:619)<br />Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date<br />at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)<br />at com.mysql.jdbc.ResultSet.getNativeDate(ResultSet.java:3561)<br />at com.mysql.jdbc.ResultSet.getNativeDate(ResultSet.java:3501)<br />at com.mysql.jdbc.ResultSet.getNativeConvertToString(ResultSet.java:3449)<br />at com.mysql.jdbc.ResultSet.getNativeString(ResultSet.java:4251)<br />at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5428)<br />at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5240)<br />at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5256)<br />at org.hibernate.type.StringType.get(StringType.java:41)<br />at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)<br />at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)<br />at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)<br />at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2114)<br />at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)<br />at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)<br />at org.hibernate.loader.Loader.getRow(Loader.java:1230)<br />at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)<br />at org.hibernate.loader.Loader.doQuery(Loader.java:724)<br />at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)<br />at org.hibernate.loader.Loader.doList(Loader.java:2232)