BaseResourceException while getting Database conne...

Former Member · ‎11-16-2004

Hi,

I'm totally stuk with this. I've got a Session Facade Bean PlcMgr thats accessed through a GUI.

This bean accesses another Session Bean PlcService through a Local Interface. PlcService has to

gather some information from the database when it is created. But it seems that it can't get a

connection to the database.

My entity beans work fine and have access to the databse through the same datasource.

Does anybody know what the problem is?

I'm using SAP J2EE Engine 6.4. I have to evaluate the benefits of using SAP Web Application Server for

my company and so I have to port one of our applications to it. It works flawless with JBoss.

Full stacktrace:

19:18:17,015 THROWING (AWT-EventQueue-0) [StatusModel] init

java.rmi.RemoteException: com.sap.engine.services.ejb.exceptions.BaseRemoteException: Exception in method getVisiblePlcs.

at com.sybit.testapplication.system.ejb.plc.PlcMgrObjectImpl0.getVisiblePlcs(PlcMgrObjectImpl0.java:264)

at com.sybit.testapplication.system.ejb.plc.PlcMgrObjectImpl0p4_Skel.dispatch(PlcMgrObjectImpl0p4_Skel.java:79)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:292)

at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:183)

at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:118)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:151)

Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Exception in method getData.

at com.sybit.testapplication.system.ejb.plc.PlcServiceLocalLocalObjectImpl0.getData(PlcServiceLocalLocalObjectImpl0.java:311)

at com.sybit.testapplication.system.ejb.plc.PlcMgrBean.getVisiblePlcs(PlcMgrBean.java:57)

at com.sybit.testapplication.system.ejb.plc.PlcMgrObjectImpl0.getVisiblePlcs(PlcMgrObjectImpl0.java:236)

... 10 more

Caused by: com.sap.engine.services.ejb.exceptions.BaseRuntimeException: Cannot create an instance of the stateless bean.

at com.sap.engine.services.ejb.session.stateless_sp5.BeanFactory.getActiveBean(BeanFactory.java:192)

at com.sap.engine.services.ejb.session.stateless_sp5.StatelessContainerFP.getActiveBean(StatelessContainerFP.java:183)

at com.sybit.testapplication.system.ejb.plc.PlcServiceLocalLocalObjectImpl0.getData(PlcServiceLocalLocalObjectImpl0.java:302)

... 12 more

Caused by: javax.ejb.EJBException: Error executing SQL statement: SELECT PLC.PLC_ID, PLC.NAME, PLC.MESSAGE_ADDRESS, PLC.CONTROLLER FROM PLC ORDER BY PLC.PLC_ID : com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException: Cannot get connection. Reason: the thread of component "ejbContexts/sap.com/testapplication/sap.com/testapplication/PlcService" in application "sap.com/testapplication" is currently associated with a restricted resource set and it is not allowed to get connection within it.

at com.sybit.testapplication.system.ejb.plc.PlcServiceBean.initPlc(PlcServiceBean.java:281)

at com.sybit.testapplication.system.ejb.plc.PlcServiceBean.ejbCreate(PlcServiceBean.java:371)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.services.ejb.session.stateless_sp5.BeanFactory.createObject(BeanFactory.java:113)

at com.sap.engine.services.ejb.util.pool.ContainerPoolImpl.doResizeOneStepUp(ContainerPoolImpl.java:368)

at com.sap.engine.services.ejb.util.pool.ContainerPoolImpl.ensureNotEmpty(ContainerPoolImpl.java:337)

at com.sap.engine.services.ejb.util.pool.ContainerPoolImpl.pop(ContainerPoolImpl.java:291)

at com.sap.engine.services.ejb.session.stateless_sp5.BeanFactory.getActiveBean(BeanFactory.java:188)

... 14 more

; nested exception is:

javax.ejb.EJBException: com.sap.engine.services.ejb.exceptions.BaseEJBException: Exception in method getData.