mysql - 无法连接到 WSO2 上的 mysql 数据库
问题描述
我是 WSO2 的新手,并试图在 Windows 机器上连接 MySQL 数据库。我已经按照文件进行了操作,但仍然没有运气。更改 deployment.toml 文件如下
[database.apim_db]
type = mysql
url = jdbc:mysql://localhost:3306/wso2_gateway_api?autoReconnect=true
username = hide
password = hide
driver=com.mysql.cj.jdbc.Driver
[database.shared_db]
type = mysql
url = jdbc:mysql://localhost:3306/wso2_gateway?autoReconnect=true"
username = hide
password = hide
driver=com.mysql.cj.jdbc.Driver
我也在上面创建的数据库上运行了脚本。下面是错误
[2020-02-04 09:55:20,999] INFO - EmbeddedRegistryService Connected to mount at configregistry in 126ms
[2020-02-04 09:55:21,000] INFO - EmbeddedRegistryService Connected to mount at govregistry in 127ms
[2020-02-04 09:55:25,440] ERROR - TransactionManager Failed to start new registry transaction.
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319) ~[jdbc-pool_9.0.16.wso2v1.jar:?]
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212) ~[jdbc-pool_9.0.16.wso2v1.jar:?]
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:739) ~[jdbc-pool_9.0.16.wso2v1.jar:?]
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:671) ~[jdbc-pool_9.0.16.wso2v1.jar:?]
at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) ~[jdbc-pool_9.0.16.wso2v1.jar:?]
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132) ~[jdbc-pool_9.0.16.wso2v1.jar:?]
at org.wso2.carbon.registry.core.jdbc.dataaccess.JDBCTransactionManager.beginTransaction(JDBCTransactionManager.java:80) [org.wso2.carbon.
at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.beginTransaction(EmbeddedRegistry.java:443) [org.wso2.carbon.registry.core_4.5.1.ja
at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.get(EmbeddedRegistry.java:505) [org.wso2.carbon.registry.core_4.5.1.jar:?]
at org.wso2.carbon.registry.core.session.UserRegistry.getInternal(UserRegistry.java:617) [org.wso2.carbon.registry.core_4.5.1.jar:?]
at org.wso2.carbon.registry.core.session.UserRegistry.access$400(UserRegistry.java:61) [org.wso2.carbon.registry.core_4.5.1.jar:?]
at org.wso2.carbon.registry.core.session.UserRegistry$5.run(UserRegistry.java:597) [org.wso2.carbon.registry.core_4.5.1.jar:?]
at org.wso2.carbon.registry.core.session.UserRegistry$5.run(UserRegistry.java:594) [org.wso2.carbon.registry.core_4.5.1.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_45]
解决方案
使用以下 url 解决问题 url = "jdbc:mysql://localhost:3306/wso2_gateway?autoReconnect=true&useSSL=false" 并添加驱动程序如下 driver="com.mysql.cj.jdbc.Driver"
推荐阅读
- react-native - 如何在 cljs 中使用反应导航?
- javascript - 如何从对象数组中检索电子邮件字段?
- java - 如何为我的 Web 服务获取 HTML 数据表单?
- php - 替换functions.php里面wordpress父主题的一个函数
- sql - 在 netezza 中使用“创建外部表”命令时无法获取别名
- java - Android Studio:在不同的活动中使用“OnClick”方法?
- node.js - 如何让 discord.js 机器人检测附件
- powershell - 未选择 PowerShell 表单数据网格
- reactjs - Redux store.getState() 返回初始状态
- c++ - 定义自定义结构类型的数组