I've seen this before with my code. It has nothing to do with Orion.
Make sure you are closing your Connections, Statements,
PreparedStatements, CallableStatements and ResultSets. The proper place
to do this is in a finally statement so the code will always get
executed, even if an exception is thrown.
BTW: SQL Server seems to allow you to be sloppy in closing
connections. I guess (think) SQL Server somehow closes them for you.
Oracle, however, does not :)
-DStraight
> "Nusairat, Joseph F." wrote:
>
> 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)
