Thanks Adrian. I will try this. rgds MS
-----Original Message----- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: Friday, November 28, 2003 3:52 AM To: [EMAIL PROTECTED] Subject: RE: [JBoss-user] Weblogic to JBoss Migration - Differences in XA and Non-XA DataSource handling (Stack Trace) It was my understanding from an earlier post, that what you describe as a "Non-XA" connection should really be a "no-transaction" connection or as somebody else suggested you should use RequiresNew to start a different transaction for this work. i.e. You don't want the work done on the Non-XA connection to be in the same transaction as the XAConnection. Is that correct? If so, you can deploy a data source such that the connections do not get enlisted in the JTA transaction using <no-tx-datasource> rather than <local-tx-datasource> Regards, Adrian On Fri, 2003-11-28 at 00:43, Sasidharan, Manoj wrote: > Hello Adrian, > > Does JBoss support taking Non-XA connection within a Session bean marked > required? > > After working with XA and Non-XA transactions for years in C and Java > worlds, I have learnt that Non-XA transaction should in no way impact an > on-going XA tranasaction. If JBoss does not allow this usage, we have to > change it so that it is in consistent with XA and Non-XA specifications. > > J2EE application server should only manage XA datasources and transactions > or those Non-XA datasources and transactions that are simulated as XA. > > Will you please take this as a change request and make this change in the > product. > > FYI, This is the behaviour in BEA Tuxedo and BEA Weblogic Server. Not sure > of IBM WebSphere or Oracle OC4J. > > Thanks and Best Regards > MS > > -----Original Message----- > From: Adrian Brock [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 26, 2003 5:44 AM > To: [EMAIL PROTECTED] > Subject: RE: [JBoss-user] Weblogic to JBoss Migration - Differences in > XA and Non-XA DataSource handling (Stack Trace) > > > This method says the connection is already enlisted in a transaction > and you are trying to use setAutoCommit() to change that attribute. > > Obviously, that is not allowed. My guess is that you already > asked for the NonXA variant already in the transaction. > > Regards, > Adrian > > On Fri, 2003-11-14 at 17:57, 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: 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 > > > ------------------------------------------------------- > 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 -- xxxxxxxxxxxxxxxxxxxxxxxx Adrian Brock Director of Support Back Office JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ------------------------------------------------------- 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 ------------------------------------------------------- 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