commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Niall Pemberton <niall.pember...@gmail.com>
Subject Re: NPE from DBCP connection pool
Date Thu, 08 Oct 2009 22:13:27 GMT
On Thu, Oct 8, 2009 at 8:16 PM, TomStrummer <tomstrummer@gmail.com> wrote:
>
> Anyone ever seen this before?  A NPE from PoolingConnection.normalizeSQL:
>
>> java.lang.NullPointerException
>>         at
>> org.apache.commons.dbcp.PoolingConnection.normalizeSQL(PoolingConnection.java:178)
>>         at
>> org.apache.commons.dbcp.PoolingConnection.createKey(PoolingConnection.java:170)
>>         at
>> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:92)
>>         at
>> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
>>         at
>> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
>>
>
> I've got a BasicDataSource and I'm trying to run a relatively simple query.
> Not sure where the NPE could be coming from.  The SQL statement in question
> is extremely simple, a single-column SELECT with a single JOIN and a WHERE
> clause.  It works fine in a SQL browser.  The query is Oracle 11g, but I'm
> pretty sure that doesn't matter since it doesn't look like the query is
> getting that far.

The sql statement you're passing in has got to be null since the
normalizeSQL() method only does sql.trim(). Also it would make
investigation issues much easier if you specify the version of DBCP
you are using.

Niall

> Note that other queries still work, just this one in particular.  So it's
> not an issue with connections closing or something like that.  Any ideas?
>
> Thanks.
> -Tom
> --

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org


Mime
View raw message