Robert Ziel wrote:
> 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?
>
It is *not* Tomcat that is using the Oracle connections. Your servlets are
using them. Therefore, the same problem would occur in any servlet container
you run this app in, and it is up to your application to ensure that connections
are used properly.
I would be suspicious of the code in either the application you are running
(does it *really* return allocated connections 100% of the time? Even in the
face of exceptions?) or the connection pool code itself. Without more details,
though, it is impossible to diagnose the problem any further.
If it does turn out to be a Tomcat-specific issue, however, you should address
it to the TOMCAT-USER list, rather than here. Same goes for any other
server-specific issue -- the best place to get help is on the server support
lists (or newsgroups) for that particular server.
>
> Regards,
> Eoin
>
Craig McClanahan
====================
See you at ApacheCon Europe <http://www.apachecon.com>!
Session VS01 (23-Oct 13h00-17h00): Sun Technical Briefing
Session T06 (24-Oct 14h00-15h00): Migrating Apache JServ
Applications to Tomcat
___________________________________________________________________________
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
