Hi,
Suggestions:
- Open one result result set at a time and store its result within
some vector or keyed collection class. (the smaller ones)
- Think you also forgot to close statements, or connections at each
request.
- Or if you use database pools you did not release the connection
back to in the pool, before servlet returns from doGet or doPost()
..
Cezar.
On Thu, 22 Apr 1999, Kenia Nimesh wrote:
> In one of our program we are opening 3 ResultSet(cursors) at a given =
> point of time.
> The queries are retreving records from the database.If there are many =
> records retreived we are getting the foll error.
> =20
> java.sql.SQLException: ORA-01000: maximum open cursors exceeded =20
> We have Oracle 8.0.5 as our database.
> The maximum OPEN_CURSORS set in init(DBinstance).ora is 120 still we are =
> getting the error.
> Please help me.
> Thanks in advance
> Nimesh
>
Cezar Totth email: [EMAIL PROTECTED]
Fax: (401) 220 33 95
Genesys Software Romania Phone: (401) 638 49 44
Stefan Furtuna 169, sect.6
cod 77171, Bucharest
Romania
___________________________________________________________________________
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
