Hi Mark,
I think you're talking about 'Open cursors exceeded <number>' error. You
will get this error if you don't close your statements inside your servlets.
It's not based on the number of users logged in to the database. Close all
your statements inside your servlet after getting value from the resultset.
One more option is you have to increase the number of open_cursors value in
init.ora file. If open_cursors vairable is not present in
init.ora/initorcl.ora then you put an entry there and restart your oracle
database.
e.g.
Open_Cursors=<number>
- number can be any positive integer.
Hope this would solve your problem.
All the best.
Kumar
-----Original Message-----
From: Mark Foley <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, November 12, 1999 8:54 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
