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 > >> +----------------------------------------------------------+ > >> > >> >
