Don'y you thing that this is quite dependant on the database? I am pretty sure that with PostgreSQL, DDL commands are transactional (and can be executed in a running transactions witout implicitely commiting it)
> -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]De la part de > [EMAIL PROTECTED] > Envoy� : mardi, 14 mai 2002 14:38 > � : [EMAIL PROTECTED] > Objet : [JBoss-dev] [ jboss-Bugs-553916 ] DDL commands in XA > transactions > > > Bugs item #553916, was opened at 2002-05-08 21:56 > You can respond by visiting: > http://sourceforge.net/tracker/?func=detail&atid=376685&aid=553916 > &group_id=22866 > > Category: JBossCMP > Group: v3.0 Rabbit Hole > Status: Open > Resolution: None > Priority: 5 > Submitted By: rm (tols) > Assigned to: Dain Sundstrom (dsundstrom) > Summary: DDL commands in XA transactions > > Initial Comment: > Hi, > > In the course of helping someone debug Tyrex with JBoss I > came across a problem in the class > org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand, namely > that a DDL operation (create table) was being executed in an XA > transaction. The same is true of the class > org.jboss.ejb.plugins.jaws.jdbc.JDBCDestroyCommand (drop > table). > > This normally is not supported because there is an > implicit commit with DDL commands. Basically a non-XA datasource > needs to be specified for doing this. > > Here are the references > for > Oracle: > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/a > ppdev.817/a76939/adga1_xa.htm#622503 > > http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/a ppdev.901/a88876/adga1_xa.htm#622503 Riad ---------------------------------------------------------------------- >Comment By: David Jencks (d_jencks) Date: 2002-05-14 12:37 Message: Logged In: YES user_id=60525 Suspending the current tx and not starting a new one would probably work with any driver using the local wrapper, since that executes statements outside a managed tx in autocommit mode. I don't know about the xa wrapper, I haven't rewritten it yet. ---------------------------------------------------------------------- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-05-14 04:57 Message: Logged In: YES user_id=251431 So what do you want me to do about it? Is this an Oracle only issue? I could just suspend the current transaction and not start a new one. I don't really care; I'm just sick of fixing this code. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=553916&group_id= 22866 _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
