baasData关联的数据库保存后，报错。

hjn090301

创建一个baasData组件，关联一个数据库，保存后，报错错误信息如下。

SQL执行失败，SQL:SELECT * FROM device_info  LIMIT 0,20
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
        at com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:145)
        at com.mysql.jdbc.ByteArrayRow.getDateFast(ByteArrayRow.java:243)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2012)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:1975)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2031)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:294)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:294)
        at com.justep.baas.data.Transform.resultSetToRow(Unknown Source)
        at com.justep.baas.data.Transform.loadRowsFromResultSet(Unknown Source)
        at com.justep.baas.data.DataUtils.queryData(Unknown Source)
        at com.justep.baas.action.CRUD.query(Unknown Source)
        at waterPressure.FireAlarm__do.querydevice_info(FireAlarm__do.java:363)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
2017-02-21 09:14:18 Action[waterPressure/fireAlarm/querydevice_info]执行失败，SQL执行失败，SQL:SELECT * FROM device_info  LIMIT 0,20
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.baas.data.sql.SQLException: SQL执行失败，SQL:SELECT * FROM device_info  LIMIT 0,20
        at com.justep.baas.data.DataUtils.queryData(Unknown Source)
        at com.justep.baas.action.CRUD.query(Unknown Source)
        at waterPressure.FireAlarm__do.querydevice_info(FireAlarm__do.java:363)
        ... 20 more
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
        at com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:145)
        at com.mysql.jdbc.ByteArrayRow.getDateFast(ByteArrayRow.java:243)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2012)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:1975)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2031)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:294)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:294)
        at com.justep.baas.data.Transform.resultSetToRow(Unknown Source)
        at com.justep.baas.data.Transform.loadRowsFromResultSet(Unknown Source)
        ... 23 more
com.justep.baas.action.ActionException: Action[waterPressure/fireAlarm/querydevice_info]执行失败，SQL执行失败，SQL:SELECT * FROM device_info  LIMIT 0,20
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        ... 16 more
Caused by: com.justep.baas.data.sql.SQLException: SQL执行失败，SQL:SELECT * FROM xxt2_device_info  LIMIT 0,20
        at com.justep.baas.data.DataUtils.queryData(Unknown Source)
        at com.justep.baas.action.CRUD.query(Unknown Source)
        at waterPressure.FireAlarm__do.querydevice_info(FireAlarm__do.java:363)
        ... 20 more
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
        at com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:145)
        at com.mysql.jdbc.ByteArrayRow.getDateFast(ByteArrayRow.java:243)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2012)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:1975)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2031)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:294)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:294)
        at com.justep.baas.data.Transform.resultSetToRow(Unknown Source)
        at com.justep.baas.data.Transform.loadRowsFromResultSet(Unknown Source)
        ... 23 more

hjn090301

二月 21, 2017 9:14:18 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
        at com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:145)
        at com.mysql.jdbc.ByteArrayRow.getDateFast(ByteArrayRow.java:243)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2012)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:1975)
        at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2031)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:294)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:294)
        at com.justep.baas.data.Transform.resultSetToRow(Unknown Source)
        at com.justep.baas.data.Transform.loadRowsFromResultSet(Unknown Source)
        at com.justep.baas.data.DataUtils.queryData(Unknown Source)
        at com.justep.baas.action.CRUD.query(Unknown Source)
        at waterPressure.FireAlarm__do.querydevice_info(FireAlarm__do.java:363)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

这是剩下的错误信息，我关联其他的数据库没有遇到这个情况。求大神帮忙解决一下。

liangyongfei

hjn090301 发表于 2017-2-21 09:18
二月 21, 2017 9:14:18 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.servic ...

请问数据库中，是否有一个日期类型的字段，值是：'0000-00-00'  呢？？

'0000-00-00' can not be represented as java.sql.Date

这个值不能别转化成日期对象

hjn090301

liangyongfei 发表于 2017-2-21 11:15
请问数据库中，是否有一个日期类型的字段，值是：'0000-00-00'  呢？？

'0000-00-00' can not be repres ...

是，有这个字段，那就是不关联这个字段就好了。谢谢可以结贴了。