commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Phil Steitz <phil.ste...@gmail.com>
Subject Re: [dbcp] dbcp, pool and SQLWarnings.
Date Tue, 03 Mar 2015 18:05:08 GMT
On 3/3/15 7:26 AM, Антон Мацюк wrote:
> I am talking about DBCP 1.4 now.

I am not familiar with the internals of BoneCP; but DBCP has been
optimized to reduce the calls to driver setXxx methods.  See
https://issues.apache.org/jira/browse/DBCP-102
https://issues.apache.org/jira/browse/DBCP-234 (not in 1.4)

You are correct below that DBCP-initiated driver setXxx and
clearWarnings calls happen in PoolableConnectionFactory's
activateObject and passivateObject methods.

Phil


>
> 2015-03-03 15:42 GMT+02:00 Phil Steitz <phil.steitz@gmail.com>:
>>
>>
>>
>>> On Mar 1, 2015, at 2:24 PM, Антон Мацюк <denixx.baykin@gmail.com>
wrote:
>>>
>>> Hi!
>>> I have a question about dbcp and pool.
>>> Last two weeks I have examined heapdumps of Tomcat instances that is
>>> used by my apps.
>>> There is situation with BoneCP - it have a LOT of SQLWarnings at each
>>> connection used by it.
>>> With DBCP-app all is normal - there is no SQLWarnings.
>>> Apps are not the same, so there can be difference in connections usage
>>> or usage rate, but both apps use Sybase ASE as database, and ASE
>>> reacts with SQLWarning at each use of setReadonly method.
>>> I can't find if somewhere in dbcp- or pool- projects something calling
>>> clearWarnings before or after connection have been used.
>>> May you please point me to this place in code?
>>> Maybe warnings cleared somewhere, maybe DBCP supress setReadonly, but
>>> finally there is no SQLWarning's in Connections in heapdump of app
>>> which use DBCP.
>>> Is it a passivateObject
>>> http://mail-archives.apache.org/mod_mbox/commons-dev/200306.mbox/%3C00cf01c33667$2358cf20$1ac8a8c0@JOACHIM%3E
>>> ?
>>> Thanks.
>> Which version of DBCP?
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>>> For additional commands, e-mail: dev-help@commons.apache.org
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>> For additional commands, e-mail: dev-help@commons.apache.org
>>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> For additional commands, e-mail: dev-help@commons.apache.org
>
>



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


Mime
View raw message