The relationship between DDL and transactions is definitely dependent on
the db.  I don't think we will lose too much here though by executing ddl
in "autocommit" mode, since the mbean operations aren't transactional.  We
may need to revisit this when mbean operations get transactional so a
deployment would be executed inside an (mbean) transaction.  

david jencks


On 2002.05.14 09:07:44 -0400 Sacha Labourey wrote:
> 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
> 
> 

_______________________________________________________________

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

Reply via email to