hi,
i have the same problem...
does someone have an answer to this problem???
regards,
Robert
>>> [EMAIL PROTECTED] 09/21/00 01:15pm >>>
Hi,
I have Tomcat3.1 running on an NT client connecting to an NT server running
Oracle 8i. 8.1.6
I have found that when using a ConnectionPool the connections created have a
status of INACTIVE (in v$session) even though a close() has been done on the
connection.
The only way to get the sessions to end is to bounce Tomcat! The obvious
problem here is that with serveral users connecting to the one database it
isn't long before Oracle gives an ORA-0020 Max number of processes exceeded.
Is there some way of getting Tomcat to tell Oracle that it has finished with
the connections and thus let Oracle release them?
Regards,
Eoin
~
"N� h� l� na gaoithe l� na scolb"
T:+353 1 671 0692
F:+353 1 671 0863
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
