项目稳定运行了2年,但是就在几天前一直报错
- Java code
17 18:29:08:218[ERROR][com.neili.datebase.GBData-http-80-795]: Gbdate getConnection()数据库连接失败java.sql.SQLException: Couldn't get connection because we are at maximum connection count (100/100) and there are none available
但proxool监控并没有100个连接使用,好几天了,一直无法解决,求朋友帮助
proxool配置
- XML code
#Main Database jdbc-0.proxool.alias=DBPool jdbc-0.proxool.driver-url=jdbc:oracle:thin:@192.168.1.1:1521:DB #jdbc-0.proxool.driver-url=jdbc:oracle:thin:@192.168.1.1:1521:DB jdbc-0.proxool.driver-class=oracle.jdbc.driver.OracleDriver jdbc-0.user=nlcn #jdbc-0.password=USERNAME jdbc-0.password=PASSWORD jdbc-0.proxool.house-keeping-sleep-time=40000 jdbc-0.proxool.house-keeping-test-sql=select 1 from dual jdbc-0.proxool.maximum-connection-count=100 jdbc-0.proxool.minimum-connection-count=10 jdbc-0.proxool.maximum-connection-lifetime=900000 jdbc-0.proxool.simultaneous-build-throttle=5 jdbc-0.proxool.recently-started-threshold=40000 jdbc-0.proxool.overload-without-refusal-lifetime=50000 jdbc-0.proxool.maximum-active-time=60000 jdbc-0.proxool.verbose=false jdbc-0.proxool.trace=false jdbc-0.proxool.fatal-sql-exception=Fatal error jdbc-0.proxool.prototype-count=2 jdbc-0.proxool.statistics-log-level=ERROR jdbc-0.proxool.test-before-use=false jdbc-0.proxool.test-after-use=false
------解决方案--------------------------------------------------------
按照错误信息,是到达最大连接了
------解决方案--------------------------------------------------------
数据库方面有其它的连接吗~ 会不会有坏了的连接没有释放
~
------解决方案--------------------------------------------------------
在项目中也遇到同样的问题,查询未果,使用hibernate自带的c3p0连接池解决了,mark帮顶!