yes
Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmannibucau 2014-07-21 22:01 GMT+02:00 Trevor Stevens <[email protected]>: > Ok so the following starts without error. Does this look correct? > > <Resource id="test" type="DataSource"> > XaDataSource testxa > DataSourceCreator dbcp > JtaManaged true > testOnBorrow = true > testOnReturn = false > testWhileIdle = false > validationQuery = SELECT 1 > </Resource> > > <Resource id="testxa" > class-name="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"> > Url jdbc:mysql://localhost/testdb?autoReconnect=true > User test > Password test > </Resource> > > > Trevor [email protected] > > > On Jul 21, 2014, at 02:22 PM, Alex Soto <[email protected]> wrote: > > I am starting to loose the scope of the question hehehe I mean it seems > that there are many different ways to resolve this, maybe we can think an > small post about how to use XA Tx in Apache TomEE? > > > 2014-07-21 20:16 GMT+02:00 Andy Gumbrecht <[email protected] >: > > > Why would ManagedXADataSource not be implementing XADataSource? > > > > Andy. > > > > > > On 21/07/2014 18:56, Romain Manni-Bucau wrote: > > > > > PS: ManagedXADataSource is not a XADataSource but a > DataSource delegating > > > to a XADataSource. > > > > > > If you use the datasource directly you can use > > > > > > <Resource id="..." > class-name="com.mysql.jdbc.jdbc2.optional. > > > MysqlXADataSource" > > > > # MysqlXADataSource config > > > </Resource > > > > > > > > > > > > > > > > > > > > > > Romain Manni-Bucau > > > Twitter: @rmannibucau > > > Blog: http://rmannibucau.wordpress.com/ > > > LinkedIn: http://fr.linkedin.com/in/rmannibucau > > > Github: https://github.com/rmannibucau > > > > > > > > > 2014-07-21 18:45 GMT+02:00 Àlex Soto <[email protected] > >: > > > > > > Well I have copied the resource from Trevor and got the > configuration > > > > from > > > > issue don't know if It is Ok for Trevor to use > dbcp. > > > > @trevor Can you try with dbcp instead of > dbcp-alternative? > > > > > > > > Enviat des del meu iPhone > > > > > > > > El 21/07/2014, a les 18.00, Romain Manni-Bucau < > [email protected] > > > > > va > > > > escriure: > > > > > > > > > @Alex: Why not DataSourceCreator = > dbcp? > > > > > > > > > > > > > > > > > > > > Romain Manni-Bucau > > > > > Twitter: @rmannibucau > > > > > Blog: > http://rmannibucau.wordpress.com/ > > > > > LinkedIn: > http://fr.linkedin.com/in/rmannibucau > > > > > Github: https://github.com/rmannibucau > > > > > > > > > > > > > > > 2014-07-21 17:57 GMT+02:00 Trevor > Stevens <[email protected] >: > > > > > > > > > > Hmm, well I assumed that this would > work but it failed with exceptions > > > > > > > > > > > at > > > > > > > > > startup. > > > > > > > > > > > > Caused by: > java.lang.ClassCastException: Cannot cast > > > > > > > org.apache.openejb.resource.jdbc.managed.xa.ManagedXADataSource to > > > > > > javax.sql.XADataSource > > > > > > > > > > > > <Resource id="test" > type="DataSource" > > > > > > > XaDataSource testxa > > > > > > DataSourceCreator > dbcp-alternative > > > > > > </Resource > > > > > > > > > > > > > <Resource id="testax" > type="DataSource" > > > > > > > JdbcDriver > com.mysql.jdbc.jdbc2.optional.MysqlXADataSource > > > > > > JdbcUrl jdbc: > mysql://localhost/testdb?autoReconnect=true > > > > > > UserName test > > > > > > Password test > > > > > > JtaManaged true > > > > > > </Resource > > > > > > > > > > > > > > > > > > > Trevor [email protected] > > > > > > > > > > > > > > > > > > On Jul 21, 2014, at 10:59 AM, > Alex Soto <[email protected] > wrote: > > > > > > > > > > > > It seems that this approach > TOMEE-1169 only works for TomEE 1.7.0. > > > > > > > > > > > > If you want to use tomee.xml > approach you may need to translate system > > > > > > properties to tomee.xml, so > for example: > > > > > > > > > > > > setProperty("db1XA", " > new://Resource?type=DataSource"); > > > > > > > setProperty("db1XA.XaDataSource", "db1XAUnderlying"); > > > > > > > setProperty("db1XA.DataSourceCreator", "dbcp-alternative" > > > > > > > > > > > > > > > > > > Needs to be translated to: > > > > > > > > > > > > <tomee > > > > > > > <Resource id="db1XA" > type="DataSource" > > > > > > > XaDataSource db1XAunderlying > > > > > > DataSourceCreator > dbcp-alternative > > > > > > </Resource > > > > > > > > > > > > > Here there is an answer of > Romain about this topic > > > > > > > > > > > > > > > > > > > http://tomee-openejb.979440.n4.nabble.com/Is-Tomee-not- > > > > support-XADataSource-td4642705.html > > > > > > > > > Don't know if it helps you :) > > > > > > > > > > > > > > > > > > > > > > > > 2014-07-21 16:47 GMT+02:00 > Trevor Stevens <[email protected] >: > > > > > > > > > > > > What is the correct syntax to > create an XA datasource within > > > > > > > > > > > > > tomee.xml? I > > > > > > > > > > > > > have tried to follow > the advice on some previous mailing list > > > > > > > > > > > > > posts and > > > > > > > > > > > > > also using the > changes introduced in > > > > > > > > https://issues.apache.org/jira/browse/TOMEE-1169 without luck. > > > > > > > > > > > > > > Trevor > [email protected] > > > > > > > > > > > > > > > > > > > -- > > > > > > > +----------------------------------------------------------+ > > > > > > Alex Soto Bueno - Computer > Engineer > > > > > > www.lordofthejars.com > > > > > > > +----------------------------------------------------------+ > > > > > > > > > > > > > > > > > > > > -- > > Andy Gumbrecht > > > > http://www.tomitribe.com > > [email protected] > > https://twitter.com/AndyGeeDe > > > > TomEE treibt Tomitribe! | http://tomee.apache.org > > > > > > > -- > +----------------------------------------------------------+ > Alex Soto Bueno - Computer Engineer > www.lordofthejars.com > +----------------------------------------------------------+ > >
