Auto-reply: RE: ORA-01000: maximum open cursors exceeded Exception

[ORAPOST]

I am out of the office until September 5th.  Please contact Mark.Reeves:oracle.com if you require assistance.

 

Regards

Antony

 

BEGIN:VCARD
VERSION:2.1
N:Reynolds;Antony;J
FN:Antony J Reynolds
ORG:<a href="http://www.oracle.com/index.html"; target="_top"><img src="http://www.oracle.com/admin/images/oraclelogo.gif"; width=188 height=44 border=0 alt=""></a><br><b><A href="http://www.uk.oracle.com";>Oracle Corporation UK Limited</A>;<A href="http://presales.uk.oracle.com";><B>Corporate Pre-Sales</A>
TITLE:Principal Sales Consultant
NOTE;ENCODING=QUOTED-PRINTABLE:Principal Consultant in Corporate Pre-Sales for Oracle UK=0D=0Aspecialising =
in Java, CORBA and large-scale online transaction=0D=0Aprocessing systems us=
ing Oracle Server platform.=0D=0A=0D=0AInternally my time can be requested v=
ia a <a href=3D"http://presales.uk.oracle.com/cps_tools/plsql/cpsreq$.startu=
p">CPS request</a>.
TEL;WORK;VOICE:+44 (0)118 924 3245
TEL;WORK;VOICE:+44 (0) 1454 631524
TEL;CELL;VOICE:+44 (0)7775 896150
TEL;WORK;FAX:+44 (0)118 924 3721
ADR;POSTAL;ENCODING=QUOTED-PRINTABLE:;;Castlegate=0D=0ATower Hill;Bristol;;BS2 OJA;UK
LABEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Castlegate=0D=0ATower Hill=0D=0ABristol BS2 OJA=0D=0AUK
URL:http://www.oracle.com
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
EMAIL;INTERNET:[EMAIL PROTECTED]
EMAIL;INTERNET:[EMAIL PROTECTED]
REV:20010601T130645Z
END:VCARD

smime.p7s

---

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

I believe u get this error when you are opening tooo many connections. (duh)

In other words make sure you are closing your Statements or PreparedStatements.

If you are, then check with your DBA to see how many current cursors you are allowed and see if you could get that increased.

Joseph Faisal Nusairat, Sr. Project Manager
WorldCom
tel: 614-723-4232
pager: 888-452-0399
textmsg: [EMAIL PROTECTED]

-----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)

---