[
https://issues.apache.org/jira/browse/DBCP-225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12499420
]
Phil Steitz commented on DBCP-225:
----------------------------------
Based on the stack traces, it looks like you are using pool 1.2, correct? From
the trace it looks like the NPE is occuring when a newly created connection is
being validated. Do you see any connection errors in the database logs?
These should throw SQLExceptions, though, which are not being reported.
Another thing to try is to turn off Oracle's Connection caching (I assume that
is what ConnectionCachingEnabled="true" means).
> getConnection / borrowObject fails with NullPointerException
> ------------------------------------------------------------
>
> Key: DBCP-225
> URL: https://issues.apache.org/jira/browse/DBCP-225
> Project: Commons Dbcp
> Issue Type: Bug
> Affects Versions: 1.2.1, 1.2.2
> Environment: Solaris 10, Oracle 10g RAC
> Reporter: Alexei Samonov
>
> We use dbcp PoolingDataSource in Solaris/Oracle 10g RAC environment and our
> getConnection calls fail sporadically with the following stack trace (1.2.1)
> Caused by: 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)
> ... more
> Caused by: java.util.NoSuchElementException: Could not create a validated
> object, cause: null
> at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:806)
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
> ... 24 more
> This is definitely not a "pool exhausted" situation, it is just being
> reported as pool exhausted. Since NoSuchElementException that you use does
> not allow cause, only Exception message (null) is being printed. With some
> debugging I was able to recover the root exception:
> java.lang.NullPointerException
> at
> org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268)
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:368)
> at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:786)
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
> ...
> Looks like it is trying to borrow/validate DelegatingConnection which
> delegate is null.
> Hoping to resolve the issue we upgraded to 1.2.2 but it did not help. Here is
> is an exception stack trace from 1.2.2:
> org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
> error Could not create a validated object, cause: null
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> ... more
> Caused by: java.util.NoSuchElementException: Could not create a validated
> object, cause: null
> at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:871)
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
> ... 28 more
> We use the following dbcp properties:
> autoCommit="false"
> readOnly="false"
> maxActive="200"
> maxIdle="20"
> minIdle="10"
> minEvictableIdleIime="300000"
> maxWait="200"
> accessToUnderlyingConnectionAllowed="true"
> validationQuery="SELECT 1 FROM DUAL"
> ConnectionCachingEnabled="true"
> FastConnectionFailoverEnabled="true"
> I could not find the existing reported dbcp/object pool bug but I see similar
> reports on the web, for example
> http://forum.java.sun.com/thread.jspa?threadID=713200&messageID=4124915
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
