默认数据源连接失败

怎能不摇头

新下载的BeX5_V3.7，已启动 MYSQL 数据库，并保持 命令窗口未关闭。通过 首选项->studio配置->数据源 对默认的数据源 测试连接，提示连接失败；用“配置初始化其它数据库.bat”配置MYSQL 数据库，测试连接一样提示失败。
导致tomcat启动后，用system或demo 登录时 tomcat报错（数据库连接方面错误）。

求大神解答！

jishuang

apache-tomcat\bin\catalina.bat中JAVA_OPTS变量加上-Djava.net.preferIPv4Stack=true的配置
在初始化工具toosl/init/catalina.bat 中加上配置

怎能不摇头

jishuang 发表于 2018-3-16 16:52
apache-tomcat\bin\catalina.bat中JAVA_OPTS变量加上-Djava.net.preferIPv4Stack=true的配置
在初始化工具t ...

apache-tomcat\bin\catalina.bat中JAVA_OPTS变量设置 如图：
在初始化工具toosl/init/ 下 没有发现 catalina.bat 文件，在initDatabase.bat 增加 -Djava.net.preferIPv4Stack=true 配置，如图：


不知道是否设置正确，按照该设置，对默认的数据源 测试连接 仍然连接失败！

jishuang

增加了配置后重新执行了吗？

怎能不摇头

jishuang 发表于 2018-3-19 10:07
增加了配置后重新执行了吗？

重新启动 MYSQL 和 studio  后， 重新测试了 数据源连接，仍然是一样的报错

jishuang

是设置后通过tools下的批处理重新配置数据源了吗？

怎能不摇头

jishuang 发表于 2018-3-19 10:24
是设置后通过tools下的批处理重新配置数据源了吗？

执行 tools\init\initDatabase.bat 配置的数据源 连接测试成功，
studio中 首选项/studio配置/数据源 连接测试失败！

直接打开 http://localhost:8080 ，用 demo或system 登录 失败。

2018-03-19 10:46:04 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2018-03-19 10:46:04 加载模块：/UI2/system/components/justep/window/server ...
2018-03-19 10:46:04 加载模块：/UI2/system/components/justep/window/server
2018-03-19 10:46:04 加载模块：/UI2/system/components/justep/model/server ...
2018-03-19 10:46:04 加载模块：/UI2/system/components/justep/model/server
2018-03-19 10:46:04 加载模块：/UI2/system/components/justep/contents/server ...
2018-03-19 10:46:04 加载模块：/UI2/system/components/justep/common/server ...
2018-03-19 10:46:04 加载模块：/UI2/system/resources ...
2018-03-19 10:46:04 加载模块：/UI2/system/resources
2018-03-19 10:46:04 加载模块：/UI2/system/components/justep/common/server
2018-03-19 10:46:04 加载模块：/UI2/system/components/justep/contents/server
2018-03-19 10:46:04 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2018-03-19 10:46:04 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2018-03-19 10:46:05 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2018-03-19 10:46:05 加载模块：/UI2/system/service/common ...
2018-03-19 10:46:05 加载模块：/UI2/system/service/common
2018-03-19 10:46:06 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2018-03-19 10:46:06 加载模块：/UI2/system/components/justep/data/server ...
2018-03-19 10:46:06 加载模块：/UI2/system/components/justep/data/server
2018-03-19 10:46:06 加载模块：/UI2/system/components/justep/input/server ...
2018-03-19 10:46:06 加载模块：/UI2/system/components/justep/input/server
2018-03-19 10:46:06 加载模块：/UI2/system/components/justep/button/server ...
2018-03-19 10:46:06 加载模块：/UI2/system/components/justep/button/server
2018-03-19 10:46:06 加载模块：/UI2/system/components/justep/select/server ...
2018-03-19 10:46:06 加载模块：/UI2/system/components/justep/select/server
2018-03-19 10:46:06 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2018-03-19 10:46:06 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2018-03-19 10:46:06 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2018-03-19 10:46:12 加载模块：/UI2/portal/base/login ...
2018-03-19 10:46:12 加载模块：/UI2/portal/base/login
2018-03-19 10:46:12 加载模块：/system/logic/code/interceptor ...
2018-03-19 10:48:22 执行sql: insert into SA_Log  (sProcessName, sStatusName, sActivity, sAction, sOperatingSystem, version, SID, sProcess, sCreatorPersonName, sCreateTime, sActivityName, sActionName, sParameters, sIP, sTypeName, sDeviceType, $clientName ) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue ), binds: [系统调用, 失败, mainActivity, loginAction, WINDOWS_7, 0, A99251AC66EB48DFA5B10D6980E8DBBE, /SA/OPM/system/systemProcess, system, 2018-03-19 10:46:12.254, 系统, 登录, ******, 0:0:0:0:0:0:0:1, 操作日志, Computer]失败
com.justep.exception.BusinessException: 编码: JUSTEP150055; 提示: 在模块"/system/data"下获取数据库连接出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.Transaction.getConnection(Unknown Source)
        at com.justep.system.data.Transaction.getConnection(Unknown Source)
        at com.justep.system.interceptor.LogBefore.execSqlUpdate(Unknown Source)
        at com.justep.system.interceptor.LogBefore.loginLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.doActionLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.execute(Unknown Source)
        at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (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.)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.justep.system.data.Transaction.getConnectionWithJndi(Unknown Source)
        ... 29 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 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.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)
        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:628)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2249)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2280)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 32 more
Caused by: java.net.SocketException: Connection reset
        at java.net.SocketInputStream.read(SocketInputStream.java:209)
        at java.net.SocketInputStream.read(SocketInputStream.java:141)
        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100)
        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143)
        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173)
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2923)
        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:560)
        ... 49 more

jishuang

studio的窗口——首选项——studio配置——Tomcat中加上这个配置看看

怎能不摇头

jishuang 发表于 2018-3-19 11:24
studio的窗口——首选项——studio配置——Tomcat中加上这个配置看看

已更新配置，重启tomcat后，仍然 提示错误  （还是无法连接数据源的错误）

jishuang

直接到tomcat的bin目录下启动startup.bat看看