Problem with CMP transactions

Former Member · ‎06-27-2007

I have an EJB application that implements business delegate, stateless session beans and entity beans for the data access to Oracle DB. Business delegate provides interfaces to clients (here WebDynpro).

In one scenario WebDynpro wants to create a number of rows in the database. It calls a method in the business delegate which delegates to the stateless session bean which then attempts to create entity beans one by one using create method of local home interface. This all works fine and I see the rows in the table.

What I wanted to do is to force an exception after the session bean has created lets say half of the entities. I just wanted to demonstrate that either all my discrete database changes happen or non at all. So I added a row in the table manually which resulted in primary key violation for one of the discrete database changes.

The result that I see is fine. None of the rows were created because the transaction was aborted. But the stack trace that I see is what I don't like and want to understand it. I have trans-attribute in ejb-jar.xml set to Required for allmethods for both the session bean and the entity bean.

It would be nice if the stack trace contained the actual SQL exception 'ORA-00001'. I want to use that to create application defined exceptions that I throw back to WebDynpro clients.

Can anyone help please?

2007-06-27 16:47:08,525 38188 ERROR [com.sap.demo.delegates.ViewCfgServicesDelegate] (SAPEngine_Application_Thread[impl:3]_38:) EJB Exception occurred during creation of view variation!

2007-06-27 16:47:08,540 38203 ERROR [com.sap.demo.exception.ExceptionHandling] (SAPEngine_Application_Thread[impl:3]_38:) com.sap.engine.services.ejb.exceptions.BaseEJBException: Transaction system failure in method createViewVariation.

2007-06-27 16:47:08,556 38219 ERROR [com.sap.demo.exception.ExceptionHandling] (SAPEngine_Application_Thread[impl:3]_38:) com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( SAP J2EE Engine JTA Transaction : [04bffffffe0ffffffce00275] ) in rollback.

2007-06-27 16:47:08,556 38219 ERROR [com.sap.demo.exception.ExceptionHandling] (SAPEngine_Application_Thread[impl:3]_38:) java.lang.RuntimeException: com.sap.engine.services.ts.exceptions.BaseIllegalStateException: DelistResource resource manager exists but XAResource was not found.

at com.sap.engine.services.ts.jta.impl.TransactionImpl.delistResource(TransactionImpl.java:491)

at com.sap.engine.services.connector.resource.impl.MCEventHandler.beforeRollback(MCEventHandler.java:854)

at com.sap.engine.services.ts.jta.impl.TransactionImpl.rollback(TransactionImpl.java:722)

at com.sap.engine.services.ts.jta.impl.TransactionImpl.commit(TransactionImpl.java:235)

at com.sap.demo.ejb.viewcfg.facade.ViewCfgServicesLocalLocalObjectImpl0_0.createViewVariation(ViewCfgServicesLocalLocalObjectImpl0_0.java:389)

at com.sap.demo.delegates.ViewCfgServicesDelegate.createViewVariation(ViewCfgServicesDelegate.java:128)

at com.sap.examples.viewcfgwizard.ViewCfgWizardComp.createView(ViewCfgWizardComp.java:539)

at com.sap.examples.viewcfgwizard.wdp.InternalViewCfgWizardComp.createView(InternalViewCfgWizardComp.java:220)

at com.sap.examples.viewcfgwizard.ViewCfgWizardView.onActionCreateView(ViewCfgWizardView.java:244)

at com.sap.examples.viewcfgwizard.wdp.InternalViewCfgWizardView.wdInvokeEventHandler(InternalViewCfgWizardView.java:286)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87)

at com.sap.tc.webdynpro.progmodel.controller.Action.fire(Action.java:67)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doHandleActionEvent(WindowPhaseModel.java:420)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:132)

at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:299)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:759)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:712)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:261)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:53)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160)

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

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

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

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

2007-06-27 16:47:08,603 38266 ERROR [com.sap.demo.exception.ExceptionHandling] (SAPEngine_Application_Thread[impl:3]_38:) com.sap.engine.services.ejb.exceptions.BaseEJBException: Transaction system failure in method createViewVariation.

at com.sap.demo.ejb.viewcfg.facade.ViewCfgServicesLocalLocalObjectImpl0_0.createViewVariation(ViewCfgServicesLocalLocalObjectImpl0_0.java:392)