我把服务部署到公司服务器上，手机端打开报错

hjn090301

http status 500

qiuxinw66

没请求到服务

songhe107

检查一下手机浏览器的cookies 设置看看有没有打卡

hjn090301

songhe107 发表于 2017-7-10 23:15
检查一下手机浏览器的cookies 设置看看有没有打卡

tomcat的错误日志文件如下：


2017-07-10 23:12:15 [http-8080-3] [com.justep.baas.BaasException] ERROR: 获取数据库[java:comp/env/traceuchome]连接失败，可能原因：数据库已经关闭或者数据源配置错误
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?current_date' at line 1)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
        at com.justep.baas.data.DataUtils.getConnection(Unknown Source)
        at com.justep.baas.action.ActionContext.getConnection(Unknown Source)
        at com.justep.baas.action.CRUD.sqlQuery(Unknown Source)
        at waterPressure.WaterPress__do.actionwaterPress(WaterPress__do.java:171)
        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.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:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:724)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?current_date' at line 1
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
        at com.mysql.jdbc.Util.getInstance(Util.java:408)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:332)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1249)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
        ... 25 more
2017-07-10 23:12:15 [http-8080-3] [com.justep.baas.BaasException] ERROR: Action[waterPressure/waterPress/actionwaterPress]执行失败，获取数据库[java:comp/env/traceuchome]连接失败，可能原因：数据库已经关闭或者数据源配置错误
java.lang.reflect.InvocationTargetException
        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.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:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:724)
Caused by: com.justep.baas.data.sql.SQLException: 获取数据库[java:comp/env/traceuchome]连接失败，可能原因：数据库已经关闭或者数据源配置错误
        at com.justep.baas.data.DataUtils.getConnection(Unknown Source)
        at com.justep.baas.action.ActionContext.getConnection(Unknown Source)
        at com.justep.baas.action.CRUD.sqlQuery(Unknown Source)
        at waterPressure.WaterPress__do.actionwaterPress(WaterPress__do.java:171)
        ... 20 more
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?current_date' at line 1)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
        ... 24 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?current_date' at line 1
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
        at com.mysql.jdbc.Util.getInstance(Util.java:408)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)

liangyongfei

hjn090301 发表于 2017-7-11 00:13
tomcat的错误日志文件如下：

首先在本地运行的时候正常的对吧！
部署到公司服务器上，运行就访问不到数据库了！

请问数据源配置文件
apache-tomcat\conf\context.xml
是否修改过了？

hjn090301

liangyongfei 发表于 2017-7-11 10:03
首先在本地运行的时候正常的对吧！
部署到公司服务器上，运行就访问不到数据库了！

修改了，因为我直接在studio端配置数据源数据库连接测试老是失败。
然后，我就直接修改context.xml里面的数据源IP换成服务器的IP。
然后，把该文件context.xml替换服务器Tomcat里面的这个文件。

hjn090301

hjn090301 发表于 2017-7-11 10:16
修改了，因为我直接在studio端配置数据源数据库连接测试老是失败。
然后，我就直接修改context.xml里面的 ...

数据源配置测试连接报如下错

communications link failure
the last packet sent successfully to the server was 0 milliseconds ago
The driver has not received any packets from the server

liangyongfei

hjn090301 发表于 2017-7-11 10:28
数据源配置测试连接报如下错

communications link failure

你确定下
1.tomcat 的机器是否能请求到数据库的服务??，可以用telnet 访问下数据库的3306端口是否正常？

2.  驱动jar包 版本是否对应？？ 换一下数据库对应版本的驱动jar包试试看！

如果代码没问题的话！
这两点满足要求！那么配置context.xml 正确就没问题的！

hjn090301

liangyongfei 发表于 2017-7-11 11:08
你确定下
1.tomcat 的机器是否能请求到数据库的服务??，可以用telnet 访问下数据库的3306端口是否正常？
...

我访问完端口后是这样，这表示是正常吗？
>
5.1.33-community?[X+hN.8oHXch`)Hpz7?v

我的jar驱动包又换了个最新的，还是不行。难道是不匹配？不是高版本的驱动包兼容低版本的数据库。最新的应该没什么问题吧。

liangyongfei

hjn090301 发表于 2017-7-11 14:08
我访问完端口后是这样，这表示是正常吗？
>
5.1.33-community?[X+hN.8o HXch`)Hpz7?v

先看下mysql 版本是多少？？上网搜下这个版本的驱动试试吧！

数据源配置保证正确对吧！

然后重启tomcat

再看下完整访问时完整的报错信息是什么？？