RE: ORA-01000: maximum open cursors exceeded Exception

[Kesav Kumar]

Title: RE: ORA-01000: maximum open cursors exceeded Exception

This is because you have too many opened statements and Resultsets.  Make sure that you close your statements and resultsets properly.  Try to debug the jdbc activity by setting the following properties.

 

jdbc.debug=true
debug.jdbc.check=true
jdbc.connection.debug=true

 

Kesav Kumar Kolla
Voquette Inc
650 356 3740(W)
510 889 6840(R)
Voquette....Delivering Sound Information

-----Original Message-----
From: Alex Paransky [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 6:51 PM
To: Orion-Interest
Subject: ORA-01000: maximum open cursors exceeded Exception

We have been using the server more frequently now, and are getting this
exception from time to time.  Does any one know why does this exception
occur and what to do about it?  Could I be doing something wrong in my CMP
2.0 Entity Beans?  I am using Orion Server 1.5.2.

Thanks.
-AP_

Embedded Exception ->
com.evermind.server.rmi.OrionRemoteException: Database error:

        at
InterestEntityHome_EntityHomeWrapper532.findExistingEntity(InterestEntityHom
e_EntityHomeWrapper532.java:54)
        at
InterestEntityHome_EntityHomeWrapper532.findByPrimaryKey(InterestEntityHome_
EntityHomeWrapper532.java:269)
        at
com.indnet.symbiosis.service.interestmanagement.InterestManagementServiceBea
n.getValue(InterestManagementServiceBean.java:229)
        at
com.indnet.symbiosis.service.interestmanagement.InterestManagementServiceBea
n.getValue(InterestManagementServiceBean.java:254)
        at
com.indnet.symbiosis.service.interestmanagement.InterestManagementServiceBea
n.getTree(InterestManagementServiceBean.java:193)
        at
com.indnet.symbiosis.service.interestmanagement.InterestManagementServiceBea
n.getTrees(InterestManagementServiceBean.java:202)
        at
com.indnet.symbiosis.service.interestmanagement.InterestManagementServiceBea
n.getRootTrees(InterestManagementServiceBean.java:218)
        at
InterestManagementService_StatelessSessionBeanWrapper8.getRootTrees(Interest
ManagementService_StatelessSessionBeanWrapper8.java:849)
        at
com.indnet.symbiosis.client.jsp.pagegen.services.UserMaintenanceService.init
ialize(UserMaintenanceService.java:291)
        at
com.slsideas.services.GenericServiceManager.initialize(GenericServiceManager
.java:99)
        at
com.slsideas.pagegen.contexts.ServerContext.<init>(ServerContext.java:197)
        at
com.slsideas.pagegen.servlets.BaseControllerServlet.doGet(BaseControllerServ
let.java:238)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:195)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
        at com.evermind._cxb._abe(Unknown Source)
        at com.evermind._cxb._uec(Unknown Source)
        at com.evermind._io._twc(Unknown Source)
        at com.evermind._io._gc(Unknown Source)
        at com.evermind._if.run(Unknown Source)