本地无法连接远程mysql数据库_jdbc,mysql_配置数据源可以连接本地数据库，无法连接远程数据库，jdbc,mysql,java - phpStudy...

最新推荐文章于 2023-10-06 15:06:10 发布
最新推荐文章于 2023-10-06 15:06:10 发布
阅读量289 收藏
点赞数
文章标签： 本地无法连接远程mysql数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_31321361/article/details/113719890
版权
在尝试使用C3P0数据源连接远程数据库时遇到APPARENTDEADLOCK异常，尝试调整maxStatements和maxStatementsPerConnection参数无效。日志显示因主机不可达导致的CommunicationsException。问题可能与网络连接、数据库配置或C3P0配置有关。检查网络连接稳定性，确认数据库服务器是否正常运行，同时审查C3P0配置以优化资源池行为。
摘要由CSDN通过智能技术生成

配置数据源可以连接本地数据库，无法连接远程数据库

问题：

我的目标是访问远程数据库，操作远程数据库。现在我使用了C3P0数据源，是可以访问本地数据库，可以早增删改查等操作。但我将数据库换为服务器上的数据库的时候，报APPARENT DEADLOCK问题，有朋友知道怎么解决这个问题吗？

尝试

我自己首先搜索答案C3P0错误APPARENT DEADLOCK!!!解决 ，添加maxStatements和maxStatementsPerConnection到我的配置文件中再次尝试，还是不行。

然后又搜索了c3p0 APPARENT DEADLOCK!!! 错误参考 ，里面也是说把maxStatements设置为0

其他的解决方法也不大行。

我出现的异常

十二月 07, 2016 9:30:43 下午 com.mchange.v2.log.MLog

信息: MLog clients using java 1.4+ standard logging.

十二月 07, 2016 9:30:43 下午 com.mchange.v2.c3p0.C3P0Registry banner

信息: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]

十二月 07, 2016 9:30:43 下午 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager

信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempt

s -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure

-> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.

c3p0.impl.DefaultConnectionTester, dataSourceName -> 1bqvvjb9k1occ65kc53q2e|f7df584, debugUnreturnedConnectionStackT

races -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnore

UnresolvedTransactions -> false, identityToken -> 1bqvvjb9k1occ65kc53q2e|f7df584, idleConnectionTestPeriod -> 0, ini

tialPoolSize -> 5, jdbcUrl -> jdbc:mysql://123.206.16.183:3306/dbWaterColInfo, maxAdministrativeTaskTime -> 0, maxCo

nnectionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxSt

atementsPerConnection -> 100, minPoolSize -> 5, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, p

referredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin

-> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies ->

false ]

十二月 07, 2016 9:31:03 下午 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run

警告: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@55a54ea0 -- APPARENT DEADLOCK!!! Creating eme

rgency threads for unassigned pending tasks!

十二月 07, 2016 9:31:03 下午 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run

警告: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@55a54ea0 -- APPARENT DEADLOCK!!! Complete Sta

tus:

Managed Threads: 3

Active Threads: 3

Active Tasks:

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@304cf82d (com.mchange.v2.async.ThreadPoolAsynchronousRun

ner$PoolThread-#1)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@d396b21 (com.mchange.v2.async.ThreadPoolAsynchronousRunn

er$PoolThread-#2)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@34a84a4f (com.mchange.v2.async.ThreadPoolAsynchronousRun

ner$PoolThread-#0)

Pending Tasks:

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@14a6a38b

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@483b0544

Pool thread stack traces:

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]

java.lang.Thread.sleep(Native Method)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)

com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]

java.lang.Thread.sleep(Native Method)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)

com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]

java.lang.Thread.sleep(Native Method)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)

com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

十二月 07, 2016 9:31:12 下午 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run

警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@304cf82d -- Acquisition Attempt Failed!!! Clearing pen

ding acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of a

llowed acquisition attempts (30). Last acquisition attempt exception:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException

MESSAGE: Host is down

STACKTRACE:

java.net.SocketException: Host is down

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:579)

at java.net.Socket.connect(Socket.java:528)

at java.net.Socket.(Socket.java:425)

at java.net.Socket.(Socket.java:241)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182

)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171

)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0Poole

dConnectionPool.java:137)

at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182

)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171

)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0Poole

dConnectionPool.java:137)

at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

十二月 07, 2016 9:31:12 下午 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run

警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@34a84a4f -- Acquisition Attempt Failed!!! Clearing pen

ding acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of a

llowed acquisition attempts (30). Last acquisition attempt exception:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException

MESSAGE: Host is down

STACKTRACE:

java.net.SocketException: Host is down

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:579)

at java.net.Socket.connect(Socket.java:528)

at java.net.Socket.(Socket.java:425)

at java.net.Socket.(Socket.java:241)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182

)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171

)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0Poole

dConnectionPool.java:137)

at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182

)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171

)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0Poole

dConnectionPool.java:137)

at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

十二月 07, 2016 9:31:12 下午 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run

警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@d396b21 -- Acquisition Attempt Failed!!! Clearing pend

ing acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of al

lowed acquisition attempts (30). Last acquisition attempt exception:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException

MESSAGE: Host is down

STACKTRACE:

java.net.SocketException: Host is down

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:579)

at java.net.Socket.connect(Socket.java:528)

at java.net.Socket.(Socket.java:425)

at java.net.Socket.(Socket.java:241)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182

)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171

)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0Poole

dConnectionPool.java:137)

at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago.

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182

)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171

)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0Poole

dConnectionPool.java:137)

at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

下面贴一下正常操作本地数据库时，打印的日志

十二月 07, 2016 9:32:11 下午 com.mchange.v2.log.MLog

信息: MLog clients using java 1.4+ standard logging.

十二月 07, 2016 9:32:11 下午 com.mchange.v2.c3p0.C3P0Registry banner

信息: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]

十二月 07, 2016 9:32:11 下午 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager

信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempt

s -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure

-> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.

c3p0.impl.DefaultConnectionTester, dataSourceName -> 1bqvvjb9k1oce1vc1vntxdw|f7df584, debugUnreturnedConnectionStack

Traces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnor

eUnresolvedTransactions -> false, identityToken -> 1bqvvjb9k1oce1vc1vntxdw|f7df584, idleConnectionTestPeriod -> 0, i

nitialPoolSize -> 5, jdbcUrl -> jdbc:mysql://localhost:3306/dbWaterColInfo, maxAdministrativeTaskTime -> 0, maxConne

ctionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxState

mentsPerConnection -> 100, minPoolSize -> 5, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, pref

erredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin ->

false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> fal

se ]

1

aaa

test1

test1

null

这是我的查询代码:

public void tese1() throws SQLException{

QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());

Object[] arr = qr.query("select * from userInfos_t", new ArrayHandler());

for (Object o : arr) {

System.out.println(o);

}

}

我的配置文件：

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/dbWaterColInfo

root

root

5

30

20

5

0

100

有朋友知道解决方法的话请告知一下，谢谢了。

相关阅读:

点击事件里对于全局变量的操作没有生效

怎么把时间戳以小时结算

页面导航样式

在web调试界面单步调试没问题，但是点击run后批量爬取就会有部分漏爬，为什么？

vue里多维数组的索引值怎么获得

react webpack npm run dev 报错

nginx返回chunked报文的问题

react 引入局部css create-react-app

c/c++ 字符转换

nginx服务器和我们平常用的linux操作系统(centos，ubuntu)有什么区别吗？

karma测试包JASMINE is not defined

在Intellij中使用Gradle时，能查看项目中的依赖关系吗？

typecho markdown 滚动条

安卓app怎样检测是运行在虚拟机里?

迁移数据效率问题

java 坦克大战多人联机里面如何进行数据的交互

怎么把弹出层数据添加到数组的对象元素里？

在一个input框加上一个按钮，按钮上加上一个字体图标，这个字体图标会覆盖部分按钮

条件变量的await()释放锁吗？

Error: Cannot resolve module 'react/lib/ReactMount'

神秘巨星z
关注
本地可以连接数据库，远程连接mysql不成功
一颗青春痘的博客
05-31 3898
版本：Ubuntu16.04一、使用xshell成功连接Linux服务器，然后命令行执行mysql本地连接命令，可以成功登录mysql数据库，但是使用mysql workbench连接不成功，出现错误：ERROR 2003:Can’t connect to MySQL server on ‘xxxx’<10061> 1、查看3306端口是否被占用netstat -apn|grep 3306:查询结
【MySQL】使用JDBC时，无法连接远程MySQL数据库
Jackin 的博客
06-19 1万+
使用JDBC时，无法连接远程MySQL数据库 bind-address 远程连接MySQL 2003 - Can't connect to MySQL server on 'xx.xx.xx.xx' (10061 "Unknown error") 警告: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourc
Mysql无法远程连接解决方案
weixin_33938733的博客
11-27 170
前言 Mysql 版本：5.7.23操作系统：Linux问题描述：只能通过Linux系统账号Root命令行进入数据库，无法使用JDBC，远程连接工具进入数据库。报错：ERROR 1698 (28000): Access denied for user 'root'@'localhost'这个问题明显就是没有开放远程连接授权，所以导致只能使用Linux的Root账号登录。 解决流程 1.找到/etc...
使用Sharding jdbc遇到的两个问题
starinbrook的博客
08-21 3573
sharding jdbc 4.1.0版本支持批量插入，数据库连接池需要使用dbcp2，使用dbcp运行时会报错 AbstractMethodError。 批量插入的方法需要添加@Transactional注解，否则sql执行成功，但数据库中没有数据，也就是事务不提交。 ...
Connection timed out: connect; Communications link failure
weixin_30266829的博客
04-01 216
今天过来启动自己的项目出现如下的问题： 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. 百度了一下，原因如下： 使用Conne...
jdbc.rar_java jdbc_java 数据库 连接_jdbc_jdbc-odbc_数据 插入 删除
09-23
在MyEclipse开发环境中，你可以方便地管理数据源，通过右键点击服务器 -> 新建 -> 数据源，配置数据库连接信息，然后在代码中直接使用这个数据源，简化了数据库连接的创建过程。 总的来说，Java JDBC是Java开发者...
java socket连接mysql数据库_JDBC使用Unix Socket连接MySQL
weixin_30768979的博客
02-24 612
我在Linux上使用–skip-networking选项来使用MySQL。我试图使用JDBC将基于J2EE的应用程序(使用servlet)连接到MySQL数据库。早些时候，当我使用MySQL并禁用了–skip-networking选项时，我连接到数据库的方式如下：Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManag...
Java数据库连接_jdbc-odbc桥连接方式(详解)
08-29
Java数据库连接_jdbc-odbc桥连接方式是一种常用的数据库连接方式，通过jdbc-odbc桥连接方式，可以连接到各种数据库，例如SQL Server、Oracle、MySQL等。下面是对Java数据库连接_jdbc-odbc桥连接方式的详细解释： 一...
jdbc 连接阿里云mysql数据库_java jdbc连接数据库
weixin_39898733的博客
02-06 1317
Java工程师必知词汇：JDBC|名词定义|Java数据库连接，(Java Database Connectivity，简称JDBC)是Java语言中用来规范客户端程序如何来访问数据库的应用程序接口，提供了诸如查询和更新数据库中数据的方法。JDBC也是Sun Microsystems的商标。JDBC是面向关系型数据库的。J...文章千言万语乐此不疲2020-02-12135浏览量Java JDBC...
java-servlet-连接mysql-数据库.docx
05-09
在Java Servlet中连接MySQL数据库涉及多个步骤，包括配置服务器、设置数据源以及编写代码来建立连接。以下是对这些步骤的详细说明： 1. **配置服务器**： 在使用Servlet连接MySQL时，由于Servlet运行在像Tomcat...
PHP无法访问远程mysql的问题分析及解决
12-19
首先说明，远程服务器是可远程访问的。 我遇到的问题是这样的：有A，B，C三台服务器，C为服务器，B可以用PHP成功连接上C机器的mysql，而A机器则不能连接！ 可以说，肯定不是代码有什么问题，服务器上的mysql设置也是没什么问题的，因为B机器都是可以的。 肯定是A机器的设置有问题！ 在网上一顿搜，各种说mysql授权问题的，以及修改php.ini的，修改防火墙的，事实上都不是这些问题导致的。 和这个页面上讨论的问题类似，但是没人给出结果，链接：http://bbs.csdn.net/topics/90284141 最后想到了SELINUX的问题，对比了下AB两台机器，果然设置不一样！估计就
无法连接远程MySQL数据库的解决方案
shhider的专栏
07-20 1034
今天配置服务器的数据库，
JdbcTemplate 查询数据库 + 具名参数 NamedParameterJdbcTemplate
LawssssCat的博客
12-16 1148
JdbcTemplate c3p0 mysql驱动 spring jar包 ID LAST_NAME EMAIL DEPT_ID drop database if exists spring4 ; create database spring4 charset utf8; use spring4 ; create table emp( ID int auto_increment primar...
sharding-jdbc 数据源的采坑
a203206868的博客
10-25 326
sharding-jdbc 数据源采坑
oracle 连接 异常 Acquisition Attempt Failed!!! Clearing pending acquires.
Yannis的技术之路
04-10 1万+
出错代码 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1429b9f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succ
jdbc.zip_JDBC mysql java_mysql jdbc
09-20
"jdbc_mysql_java" 和 "mysql_jdbc" 这两个标签进一步强调了内容的核心，即使用Java语言通过JDBC接口操作MySQL数据库。 **文件名解析：** "www.pudn.com.txt" 可能是来源于pudn.com网站的一个文本文件，可能包含...
MySql_JDBC, Druid数据库连接池以及Template技术所需jar包.zip
11-16
MySQL JDBC、Druid数据库连接池和Template技术是Java Web开发中的关键组件，它们极大地提高了数据库操作的效率和便捷性。让我们深入探讨这些知识点。 首先，MySQL JDBC（Java Database Connectivity）是Java与MySQL...
各位同志，关于c3p0报错：Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a nee
热门推荐
阿呆的数据经历
03-20 2万+
网上很多都有让检查配置文件有没有写错    &lt;property name="jdbcUrl"&gt;jdbc:mysql://localhost:3306/test&lt;/property&gt;    &lt;property name="driverClass"&gt;com.mysql.jdbc.Driver&lt;/property&gt;    &lt;property name
【JDBC】使用c3p0数据库连接池的各种报错警告
musite 小白成长杂记
01-28 4067
使用c3p0数据库连接池的各种报错警告 使用c3p0数据库连接池的时候，先导入了三个jar包在lib 文件夹中， c3p0-0.9.5.2.jar mchange-commons-java-0.2.3.4.jar mysql-connector-java-8.0.13.jar 注意下载的 c3p0 jar包要与mchange-commons-java jar包和mysql-connector-java jar包以及你的mysql版本一致，不一致会报错 然后写c3p0-config.xml配置文
mysql不能远程连接的解决办法
最新发布
qq_24768591的博客
10-06 8164
MySQL默认只监听本地连接,需要在配置文件my.ini或者/etc/my.cnf中设置bind-address为服务器IP,开启网络连接。服务器与远程客户端之间的网络如果出现问题,也会导致无法连接MySQL数据库。如果服务器启用了防火墙,需要设置防火墙打开MySQL默认的3306端口,允许入站连接。检查服务器防火墙设置,开放MySQL的3306端口。或者暂时关闭防火墙进行测试。MySQL默认只允许root用户在本地登录,需要授权远程访问权限。除了root用户,其他用户不具备远程访问权限,需要分别授权。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值