项目运用当中,在tomcat 中的 conf/server.xml
中配制JNDI
配置如下:
<Resource auth="Container" name="jdbc/ztc" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/ztc">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:sqlserver://192.168.1.99:1433;databaseName=ztc</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>username</name>
<value>ecp</value>
</parameter>
<parameter>
<name>password</name>
<value>123456</value>
</parameter>
但是在运行的时候,因为需要经常性的对数据库进行联接,释放。一会就出现下列异常:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.ytx.ztc.dao.BetbrainOdds45DAOImpl.insertOrUpdateBetbrainOdds45(BetbrainOdds45DAOImpl.java:526)
at com.ytx.ztc.bean.BetbrainCorrentScoreImpl.getOddsByUrl(BetbrainCorrentScoreImpl.java:256)
at com.ytx.ztc.bean.BetbrainCorrentScoreImpl.getData(BetbrainCorrentScoreImpl.java:132)
at com.ytx.ztc.timer.CorrentScoreTimer.run(CorrentScoreTimer.java:28)
at java.util.TimerThread.mainLoop(Timer.java:432)
at java.util.TimerThread.run(Timer.java:382)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:756)
经过网上搜索,才知道是因为,联接池出现异常。所以添加下面的三个属性配制
<!-- default fasle-->
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<!-- set recently request to recall connection -->
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<!-- log infomation log debug .-->
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
OK。问题已经解决!
分享到:
相关推荐
dbcp 连接池不合理的锁导致连接耗尽解决方案 ... nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at org.springframework.jdbc.dataso
主要介绍了阿里dubbo出错提示Thread pool is EXHAUSTED的问题及解决方法,本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友可以参考下
o POOL-152: GenericObjectPool can block forever in borrowObject when the pool is exhausted and a newly created object fails validation. When borrowing an object if a new object is created but ...
使用spring + atomikos+druid配置的分布式事务demo,两种数据源配置方式都可以,使用junit测试没问题,案例中使用的mysql数据库是8.0.11版本,版本不同请自行修改pom.xml和jdbc.properties
主要介绍了Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2611816 bytes)错误的解决方法,需要的朋友可以参考下
php Allowed memory size of 134217728 bytes exhausted
编译时virtual memory exhausted Cannot allocate memory 内存增加.docx
cwb@laptop$ (./a.out | tail -1) & (./a.out | tail -1) mmap: Cannot allocate memory mmap: Cannot allocate memory 121126: Allocated map: 65514, 0x7f93dae09000 121128: Allocated map: 65514, 0x7fbce487...
云服务器编译安装PHP遇到virtual memory exhausted: Cannot allocate memory
今天在百度知道看php相关资料时发现一个网友问一个wordpress安装提示错误的一个问题,说他在安装wordpress安装包时遇到这样一个问题:Fatal error:Allowed memory size of 67108864 bytes exhausted (tried to ...
php解决Allowed memory size of bytes exhausted
travel time and exhausted gasoline. Most navigation systems use the static shortest path routing algorithm or use optional traffic information broadcasted by a centralized Traffic Information Center ...
connection pool exhausted connection refuse by peer 一个个来分析。 LOADING Redis is loading the dataset in memory 这里至少有2种可能 可用内存太小,修改 redis.conf 中的 maxmemory 即可解决 redis 在...
S7A驱动,7.20版本, Version history S7A OPC server and FIX driver for Siemens S7/S5 communication via Ethernet TCP/IP, MPI or Profibus Version 7.20 Date: 26.02.2007 ...
有些朋友新配置的环境或自己新写的程序运行时会碰到fatal error: Allowed memory size of 134217728 bytes exhausted错误,这种问题一个是程序写得不好导致的,另一个是环境配置不好也会出现,像php5.1.27+apache2.2.3...
本文实例讲述了ThinkPHP提示错误Fatal error: Allowed memory size的解决方法。...错误提示:Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 523800 bytes) in /var/w
Exception in thread "main" java.util.concurrent.RejectedExecutionException: Thread pool is EXHAUSTED! Thread Name: test-thredpool-plus, Pool Size: 10 (active: 10, core: 10, max: 10, largest: 10), Task...