Hi..
M trying to reput my
thread here... i dont know why i m not able to see any text of my msg on board
Hi Alex,
Thnx for your reply dude...
quote:
--------------------------------------------------------------------------------
If I understood you correctly, you're saying that
--------------------------------------------------------------------------------
Yea, you got me 100% right... that is what exactly i have the entry in my ejb-jar.xml...
quote:
--------------------------------------------------------------------------------
In order to debug I'd do the following (with your method set to RequiresNew while all other methods have Required):
1. Rather than executing an update statement do a simple sql select from the table that does not get updated
--------------------------------------------------------------------------------
I dont know whether i got u properly or not (i.e.... from the table which does not get updated), but what i did i tell u..
1. as u said, I commented my executeUpdate(sqlStmt) (the one which was stopping my execution) and just simply had a SELECT statement at a temp table... WORKD FINE...
2. then I did a SELECT query on the same table which i want to update, WORKD FINE
now the climex begin
3. I replaced again my update statement, and uncommented my executeUpdate(sqlStmt).... failed... same prob, getting stuck...
tell me what should i do??
more over one more prob i have, for now, i m keeping my entry "RequiresNew" for all methods (say have <method-name>*</method-name> in ejb-jar.xml
after updating few records successfully, i get this exception:
code:
--------------------------------------------------------------------------------
ExceptionUtil E CNTR0019E: Non-application exception occurred while processing method "updateTransactionStatus". Exception data: com.ibm.websphere.csi.CSITransactionRolledbackException: Global tx rolled backat com.ibm.ejs.csi.TransactionControlImpl.getCurrentTransactionalUOW(TransactionControlImpl.java:635)at com.ibm.ejs.csi.TransactionControlImpl.preInvoke(TransactionControlImpl.java:340)at com.ibm.ejs.container.EJSContainer.preInvoke_internal(EJSContainer.java(Compiled Code))at com.ibm.ejs.container.EJSContainer.preInvoke(EJSContainer.java:2277)at com.ibm.ejs.container.EJSContainer.preInvoke(EJSContainer.java:2262)at com.zak.moi.ejb.db2.transaction.EJSRemoteStatelessLogger_bef34805.updateTransactionStatus(EJSRemoteStatelessLogger_bef34805.java:39)at com.zak.moi.ejb.db2.transaction._Logger_Stub.updateTransactionStatus(_Logger_Stub.java:390)at com.zak.moi.ejb.transaction.TransactionUpdateBean.updateFailedTransactions(TransactionUpdateBean.java:200)at com.zak.moi.ejb.transaction.EJSRemoteStatelessTransactionUpdate_c1bce76b.updateFailedTransactions(EJSRemoteStatelessTransactionUpdate_c1bce76b.java:77)at com.zak.moi.ejb.transaction._TransactionUpdate_Stub.updateFailedTransactions(_TransactionUpdate_Stub.java:258)at com.zak.moi.web.transaction.ServiceGatewayServlet.doGet(ServiceGatewayServlet.java:42)at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:923)at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528)at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176)at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201)at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516)at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:362)at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) ......... org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException: ; nested exception is: com.ibm.websphere.csi.CSITransactionRolledbackException: Global tx rolled back minor code: 0 completed: No[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at java.lang.reflect.Constructor.newInstance(Native Method)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.CORBA.iiop.UtilDelegateImpl.copyObjectByProxy(UtilDelegateImpl.java:1197)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.CORBA.iiop.UtilDelegateImpl.copyObject(UtilDelegateImpl.java:797)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at javax.rmi.CORBA.Util.copyObject(Util.java:327)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.zak.moi.ejb.db2.transaction._Logger_Stub.updateTransactionStatus(_Logger_Stub.java:392)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.zak.moi.ejb.transaction.TransactionUpdateBean.updateFailedTransactions(TransactionUpdateBean.java:200)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.zak.moi.ejb.transaction.EJSRemoteStatelessTransactionUpdate_c1bce76b.updateFailedTransactions(EJSRemoteStatelessTransactionUpdate_c1bce76b.java:77)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.zak.moi.ejb.transaction._TransactionUpdate_Stub.updateFailedTransactions(_TransactionUpdate_Stub.java:258)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.zak.moi.web.transaction.ServiceGatewayServlet.doGet(ServiceGatewayServlet.java:42)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:923)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516)[17/08/04 15:28:00:516 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:362)[17/08/04 15:28:00:531 GMT+03:00] 7b0e2aa8 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
--------------------------------------------------------------------------------
help me please
thnx in advance
[ August 17, 2004: Message edited by: Tausif Khanooni ]