当前位置: 代码迷 >> Java Web开发 >> 正在使用的系统坏掉了,帮忙看看啥有关问题
  详细解决方案

正在使用的系统坏掉了,帮忙看看啥有关问题

热度:96   发布时间:2016-04-17 10:26:24.0
正在使用的系统坏掉了,帮忙看看啥问题
tomcat启动后提示这个,

[WARN] 2012-03-28 19:40:54,296 com.mchange.v2.resourcepool.BasicResourcePool - c
om.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@4e1a93 -- Acquisition A
ttempt Failed!!! Clearing pending acquires. While trying to acquire a needed new
 resource, we failed to succeed more than the maximum number of allowed acquisit
ion attempts (60). Last acquisition attempt exception:
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 ja
va.net.SocketException: No buffer space available (maximum connections reached?)
: connect
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
  at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
  at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:135)
  at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:182)
  at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:171)
  at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
  at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
Pool.java:1014)
  at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc
ePool.java:32)
  at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicRe
sourcePool.java:1810)
  at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(T
hreadPerTaskAsynchronousRunner.java:255)

------解决方案--------------------
服务器跟数据库服务器之间的网络应该有问题。

在服务器上用 telnet <ip> <port> 看一下网络是否通畅
------解决方案--------------------
你的数据库连接不通。看看IP是否ping得通
------解决方案--------------------
认真检查一下。端口sqlserver默认是使用1433,除非你改成了1435.
连接常见问题:1. TCP/IP连接失败--> 端口问题
2.数据库服务未开启问题 3.jdbc.jar没导入问题。
------解决方案--------------------
打开“SQL Server配置管理器”--------》SQL Server2005网络配置-----》SQLEXPRESS的协议------》TCP/IP(双击)----》ip地址---->选择最下面的IPAll配置tcp动态端口:1433配置好了重启服务重新连接
  相关解决方案