Yes. But I am trying to do this on a Non-XA datasource connection. This should in no way impact the on-going user transaction.
I have two datasources - XA and Non-XA and Session bean uses both to complete its operation. Only the XA needs to be rolled-back. rgds MS -----Original Message----- From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 4:50 AM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Weblogic to JBoss Migration - Differences in XA and Non-XA DataS ource handling (Stack Trace) Are you trying to set autocommit? You can not do it in a managed tx. Sasidharan, Manoj wrote: > Hello Adrian, > > Thanks for taking some time for helping me on this issue. Here is the stack > trace at the server when the problem occurs. > > 20:26:31,122 WARN [TxConnectionManager$LocalXAResource] Prepare called on a > loc > al tx. Use of local transactions on a jta transaction with more than one > branch > may result in inconsistent data in some cases of failure. > 20:26:31,137 ERROR [STDERR] [ERROR]You cannot set autocommit during a > managed tr > ansaction! > 20:26:31,215 ERROR [STDERR] [Thu Nov 13 20:26:31 PST 2003][CALL > STACK][76b9eaa7d > d7b7d6f4ea15cb77bdea60667df0][java.sql.SQLException: You cannot set > autocommit d > uring a managed transaction! > at > org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcA > utoCommit(BaseWrapperManagedConnection.java:395) > at > org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(Wrapp > edConnection.java:426) > at com.plx.framework.sql.Serial.beginTrans(Serial.java:226) > at com.plx.framework.sql.Serial.getNextNumberBlock(Serial.java:157) > at com.plx.framework.sql.Serial.getNextSerial(Serial.java:301) > at com.plx.efw.server.system.Login.insertLogin(Login.java:197) > at com.plx.efw.server.system.Login.login(Login.java:105) > at > com.plx.efw.server.system.SystemSessionBean.login(SystemSessionBean.j > ava:275) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > Please let me know if you need some more information to analyze the problem. > > rgds > MS > > -----Original Message----- > From: Adrian Brock [mailto:[EMAIL PROTECTED] > Sent: Friday, November 14, 2003 12:38 AM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Weblogic to JBoss Migration - Differences in > XA and Non-XA DataSo urce handling > > > On Fri, 2003-11-14 at 03:21, Sasidharan, Manoj wrote: > >>Hello All, >> >>JBoss 3.2.2 >>Oracle 9.2.0.4 >>Datasources are created using oracle-ds.xml (Non-XA) and oracle-xa-ds.xml >>(XA) >> >>I have a Stateless session bean that gets an XA connection and does some >>database updates. It also tries to get a Non-XA connection and perform > > some > >>database updates and for that tries to set AutoCommit ON. Our logic does > > not > >>expect the second updates to be any way affect the on-going user >>transaction. Some how, the code does not work. The exception says that >>auto-commit can be used inside Bean Managed Transactions. >> > > > Is the exception secret or do we have to guess? > > Regards, > Adrian > > >>The code just works fine in Weblogic. >> >>Any suggestions on what would be the problem or how to avoid it would be >>highly appreciated. >> >>Thanks in advance. >> >>rgds >>MS >> >> >>------------------------------------------------------- >>This SF.Net email sponsored by: ApacheCon 2003, >>16-19 November in Las Vegas. Learn firsthand the latest >>developments in Apache, PHP, Perl, XML, Java, MySQL, >>WebDAV, and more! http://www.apachecon.com/ >>_______________________________________________ >>JBoss-user mailing list >>[EMAIL PROTECTED] >>https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF. Net email is sponsored by: GoToMyPC GoToMyPC is the fast, easy and secure way to access your computer from any Web browser or wireless device. Click here to Try it Free! https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
