DBCP连接属性 [英] DBCP Connection properties

问题描述

我们很难确定已定义， minIdle ， maxIdle 等。

我们看到以下错误设置

 
 InitialSize = 5 
 maxActive = 50 
 maxIdle = 40 
 maxWait = 2000 
 

 
原因：org.springframework.jdbc.CannotGetJdbcConnectionException：无法获取JDBC连接；嵌套的异常是org.apache.commons.dbcp.SQLNestedException：无法获得连接，池错误org.springframework.jdbc.datasource.DataSourceUtils.getConnection（DataSourceUtils.java:80）中的等待空闲对象
的超时$ b在org.springframework.jdbc.core.JdbcTemplate.execute（JdbcTemplate.java:1001）
在org.springframework.jdbc.core.JdbcTemplate.call（JdbcTemplate.java:1064）
 
 ... 36更多
原因：org.apache.commons.dbcp.SQLNestedException：无法获得连接，池错误org.apache.commons.dbcp.PoolingDataSource超时等待空闲对象
 .getConnection（PoolingDataSource.java:114）
在org.apache.commons.dbcp.BasicDataSource.getConnection（BasicDataSource.java:1044）
在org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection （AbstractRoutingDataSource.java:148）
在org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection（DataSourceUtils.java:111）
在o rg.springframework.jdbc.datasource.DataSourceUtils.getConnection（DataSourceUtils.java:77）
 ... 39更多
原因：java.util.NoSuchElementException：超时等待空闲对象
在org.apache.commons.dbcp.PoolingDataSource.getConnection（PoolingDataSource.java:106）
  p $ p> 
 
解决方案
已解决。问题是由于错误的应用程序代码导致的连接泄漏。编写该应用程序代码是为了访问基础的本机连接以使用Oracle阵列类型，并且未进行适当的管理。将代码更改为使用SimpleNativeJdbcExtractor 
 
 
 
  http://static.springsource.org/spring/docs/2.0.x/api/org/springframework/jdbc/support/nativejdbc/SimpleNativeJdbcExtractor.html  
 
We are having hard time figuring out the properties defined, minIdle, maxIdle etc.

we are seeing the following error with the following setting
InitialSize=5
maxActive=50
maxIdle=40
maxWait=2000


Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1001)
    at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064)

    ... 36 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:148)
    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
    ... 39 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)

解决方案
This is resolved. The issue was connection leak from the bad application code. The application code was written to access the underlying native connection to use Oracle Array Types and not managed properly. Changed the code to using SimpleNativeJdbcExtractor

http://static.springsource.org/spring/docs/2.0.x/api/org/springframework/jdbc/support/nativejdbc/SimpleNativeJdbcExtractor.html

                        
这篇关于DBCP连接属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！