DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29497>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=29497





------- Additional Comments From [EMAIL PROTECTED]  2005-05-19 10:44 -------
I have the same problem on Tomcat 5.0.28, WinXP and Oracle (different versions).

Steps to reproduce:
1) set up a datasource under some specific context, 
   setting parameter maxIdle to 1 or more
2) create an application (servlet) that uses the datasource to open (and close)
a connection
3) run the servlet once
4) check that there is a connection created 
   (e.g. by using Oracle query "select * from v$session")
5) reload the application (using Tomcat Manager or automatic reloading)
6) check that the connection is still open
   (e.g. by using Oracle query "select * from v$session")
7) run the servlet once
8) check that there is a NEW connection created 
   (e.g. by using Oracle query "select * from v$session")

Expected result: 
when reloading the application, the connection pool associated with its context
should be closed and all its connections also closed (step 6).

Remarks:
1) if on step 5 I restart Tomcat server instead of reloading one application,
the connection pool's connections are closed as expected
2) if I set maxIdle to 0 when configuring the datasource (step 1),
then connections are closed immediately when the application releases them.
This indicates that the application closes the used connections correctly.

See also:
http://mail-archives.apache.org/mod_mbox/jakarta-commons-user/200307.mbox/[EMAIL
 PROTECTED]

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to