Hi All!
Again a problem! We are using Oracle thin JDBC drivers to talk to Oracle
8.0.5.0 on Solaris using a dynamic connection pool. We are running out of
connections (limit = 100) even though we have no more than 2 or 3 people
using the servlet at any time, and we are being careful to shrink the pool
when fewer users are 'logged in'.
We have traced the connection pool and logged the connects and disconnects
to a file, and there are never more than 5 connections open at the same
time. Our DBA tells us each time Oracle runs out of connections there are
100 connections registered to 'JDBC'. Rebooting the servlet server doesn't
help either.
We are using IBM WebSphere 2.02 with MS IIS 4 on WinNT 4 SP5, but have kept
our code generic for use (if necessary) on other platforms.
Any help would be most appreciated - this is a reall worry (and in the land
of "No Worries!" that's not good).
Many thanks,
Mark Foley
EDS (Australia)
Tel: +61-2-6275 6494
e-mail1: [EMAIL PROTECTED]
e-mail2: [EMAIL PROTECTED]
___________________________________________________________________________
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
