I ran into a similar problem using the same version of Oracle. How
interesting!
I told the DBA that my company was using and he said "Oh....hmmm ok. Try it
in about an hour "
I didn't have a problem with it after that.
I realize this is not the answer you were hoping for but it may give you
some insight as to the realm in which this problem will be solved. The only
difference between what you described and my situation was that my data
server was a Sun Solaris e450 (this is not a major issue and I would
recommend pressing, with respect of course, the DBA for the solution. If no
absolution results, call Oracle and ask them about this... I had other
issues that our DBA couldn't get to the end of and the Oracle people were
really cool to deal with.....
Respectfully,
[EMAIL PROTECTED]
----- Original Message -----
From: Mark Foley <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 11, 1999 6:01 PM
Subject: JDBC-Oracle connections not disconnecting
> 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
>
___________________________________________________________________________
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
