commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Phil Steitz (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DBCP-212) PoolingDataSource closes physical connections
Date Fri, 06 Apr 2007 09:29:32 GMT

    [ https://issues.apache.org/jira/browse/DBCP-212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487203
] 

Phil Steitz commented on DBCP-212:
----------------------------------

Can you please provide a little more information on what exactly you are seeing - how exactly
you can tell that the connections are being physically closed? 

I ran the DBCPTester code against postgres and Sybase SQL Anywhere (developer edition, with
the JConnect driver above) and did not see connection leakage or churn.   In each case, I
examined connection logs and there did not appear to be connect-disconnects happening.  Postgres
did not churn processes and the logs showed just 15 connects,  and disconnects only when the
program was terminated.  Same for Sybase.  With Sybase, I did notice a lot of executions of
sp_dba.  This is because the pool periodically  checks isClosed().  The JConnect docs  (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc39001_0605/html/prjdbc/BHCIAIBF.htm)
explain why this triggers sp_dba.  Specifying IS_CLOSED_TEST=INTERNAL eliminates this.  

Are you running Commons Pool 1.3?  With dbcp 1.2.2, you should be.  Could you pls also test
using pool 1.2 with dbcp 1.2.1?  I don't see any difference in my tests using the previous
versions and the changes from pool 1.2 / dbcp 1.2.1 to pool 1.3 / dbcp 1.2.2 should not affect
this; but it would be good to know if the behavior you are seeing is new.

Thanks!

> PoolingDataSource closes physical connections
> ---------------------------------------------
>
>                 Key: DBCP-212
>                 URL: https://issues.apache.org/jira/browse/DBCP-212
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.2.2
>         Environment: Windows XP, Java 1.5.0_06-b05, Sybase ASE 12.5.4, jConnect 6.0.5
EBF 13862
>            Reporter: Marcos Sanz
>         Attachments: DBCPtester.java
>
>
> By executing the attached program and monitoring the process id of the physical connections
at the database server, it is possible to demonstrate that the connections are being actually
physically closed and reopened by the application at a very high rate.

-- 
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: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org


Mime
View raw message