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

Reply via email to