baas 调用数据库出错

美景

不知道什么原因   ！！！！提示错误 在mysql用 sql语句  查询也没有错误！！都通！！！

liangyongfei

500错误，需要看tomcat控制台 完整报错信息！ 是什么原因？？详细信息发来看看！

美景

2017-11-03 23:39:40 开始-WINDOW生成中间文件: /UI2/tvdata/index.w
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/window/server ...
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/window/server
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/model/server ...
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/model/server
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/data/server ...
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/common/server ...
2017-11-03 23:39:40 加载模块：/UI2/system/resources ...
2017-11-03 23:39:40 加载模块：/UI2/system/resources
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/common/server
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/data/server
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/panel/server ...
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/panel/server
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/titleBar/server ...
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/titleBar/server
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/select/server ...
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/select/server
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/list/server ...
2017-11-03 23:39:40 加载模块：/UI2/system/components/justep/list/server
2017-11-03 23:39:40 结束-WINDOW生成中间文件: /UI2/tvdata/index.w
2017-11-03 23:39:40 开始-中间文件生成缓存文件: /UI2/tvdata/index.w
2017-11-03 23:39:41 结束-中间文件生成缓存文件: /UI2/tvdata/index.w
2017-11-03 23:39:41 加载模块：/UI2/system/service/common ...
2017-11-03 23:39:41 加载模块：/UI2/system/service/common
2017-11-03 23:39:41 DataUtils.getConnection:java:comp/env/tvdate,jdbc:mysql://127.0.0.1:3306/tvdate, UserName=root@localhost, MySQL Connector Java
2017-11-03 23:39:42 DataUtils.getConnection:java:comp/env/tvdate,jdbc:mysql://127.0.0.1:3306/tvdate, UserName=root@localhost, MySQL Connector Java
2017-11-03 23:39:42 SQL执行失败，SQL:SELECT * FROM sbcr_biao  LIMIT 0,20
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

美景

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 tvdate.Dafsdfa__do.querySbcr_biao(Dafsdfa__do.java:43)
        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-11-03 23:39:42 Action[tvdate/dafsdfa/querySbcr_biao]执行失败，SQL执行失败，SQL:SELECT * FROM sbcr_biao  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 sbcr_biao  LIMIT 0,20
        at com.justep.baas.data.DataUtils.queryData(Unknown Source)
        at com.justep.baas.action.CRUD.query(Unknown Source)
        at tvdate.Dafsdfa__do.querySbcr_biao(Dafsdfa__do.java:43)
        ... 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
2017-11-03 23:39:42 Action[tvdate/dafsdfa/querySbcr_biao]执行失败，SQL执行失败，SQL:SELECT * FROM sbcr_biao  LIMIT 0,20
com.justep.baas.action.ActionException: Action[tvdate/dafsdfa/querySbcr_biao]执行失败，SQL执行失败，SQL:SELECT * FROM sbcr_biao  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)
十一月 03, 2017 11:39:42 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
com.justep.baas.action.ActionException: Action[tvdate/dafsdfa/querySbcr_biao]执行失败，SQL执行失败，SQL:SELECT * FROM sbcr_biao  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)

美景

liangyongfei 发表于 2017-11-2 17:51
500错误，需要看tomcat控制台 完整报错信息！ 是什么原因？？详细信息发来看看！ ...

我发的对吗 》？？是这个吗？

liangyongfei

美景 发表于 2017-11-3 23:42
我发的对吗 》？？是这个吗？

Value '0000-00-00' can not be represented as java.sql.Date
看上去是因为有一个日期类型的字段！值不正确导致的！