Hi,
Why don't you use a connection pool offered by the servlet container? If
your db is Oracle you have to set this parameter in your db ini (Ex.
orcl.ini) file:
MAX_OPEN_CURSORS=200 or whatever number of cursors you want to keep open. I
think that open resultsets in java correspond to a open cursor in the
database or something like that. So it would be better to close all
resources and free the connection to the pool immediately after you are done
using it.
HTH
Anil
--------------------------------------------
Anil Colin Lobo
Aztec Software, Inc.
3211 Scott Blvd., Suite 204
Santa Clara, California 95054
Ph: (408) 7483500
Web: http://www.aztecsoft.com
-----Original Message-----
Subject: Cursors
Hello Gurus,
I have this cursors exceeded problem after some time.I am using a separate
class for data base access and in each of my servlet init method I call this
class' dbconnect mehod and in the destroy method I call the closedb method.
But it does not work.
How to call the close method in a servlet that has to perform many data base
tasks based on the user request and also refresh every minute the display?
TIA
srr
___________________________________________________________________________
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
