I come across something similar, but not exactly the same. Anyway, here my
experience FYI.
When i first use Oracle JDBC 7 Driver with 7 DB, memory cannot be allocated
from sga after several resultsets are retrieved (to increase the
OPEN_CURSORS parameter in the Ora. init file can help, but i guess it
doesn't solve the dead connection problem). Dead connections were found
even all users exists from the application. These dead connection cannot be
killed even using sqlmgrl by the DBA and db restart becomes the only
solution.
After i close the resultset and statement object everytime after use, the
situation no longer exists.
Joe
----- Original Message -----
From: Mark Foley <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 12, 1999 8:01 AM
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
