Well, Bitronix as a replacement for Tranql should work. I'd have to investigate why the two aren't cooperating. If you feel like opening an issue about this and attaching what you've got so far, we could pick it up from there and eventually make it part of Ode as an alternative to Tranql.
alex On 2/19/08, xenHalfLife <[EMAIL PROTECTED]> wrote: > > Thanks a lot for the update! I almost lost the confidence in myself trying > to configure this =). > > Cheers > > On Feb 19, 2008 11:12 PM, Alex Boisvert <[EMAIL PROTECTED]> wrote: > > > Correct. The 1.1.x branch (including 1.1.1) doesn't support XA for the > > general case. That's one of the main reason we split off to create the > > BART > > branch (now trunk). > > > > alex > > > > > > On 2/19/08, xenHalfLife <[EMAIL PROTECTED]> wrote: > > > > > > Thank a lot for the tips Alex. > > > > > > Does this mean that latest, 1.1.1 distribution supports XA, or entire > > > 1.x.xbranch has no support for the XA? > > > > > > Thanks > > > > > > On Feb 19, 2008 5:30 PM, Alex Boisvert <[EMAIL PROTECTED]> wrote: > > > > > > > Hi, > > > > > > > > My general feeling is this is the type of integration that either > > works > > > > right away, or you have to get your hands dirty into the code. > OpenJPA > > > and > > > > Bitronix don't seem to see eye-to-eye and I don't know whose side is > > at > > > > fault. Regardless, I'd say getting to the bottom of it will require > a > > > > good > > > > understanding of the code. > > > > > > > > Any reason you're not using the pre-packaged Tranql transaction > > manager? > > > > (mode=internal). If you're using the 1.1-branch, there's no support > > for > > > > XA > > > > transaction. > > > > > > > > alex > > > > > > > > > > > > On 2/19/08, xenHalfLife <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Still struggling with this one, have tried to configure two data > > > sources > > > > > (one managed) in both configuration files and manually, > > > > > but class org.apache.ode.dao.jpa.BPELDAOConnectionFactoryImpl does > > not > > > > > implement nor use setUnmanagedDataSource, > > > > > actually its implementation is empty. > > > > > > > > > > Any thoughts about this? Is this actually solvable by n00b like me > > =) > > > > > without having to learn source code and dig deeper into ODE > > > > implementation > > > > > details? > > > > > > > > > > Regards, > > > > > > > > > > On Feb 19, 2008 10:15 AM, xenHalfLife <[EMAIL PROTECTED]> > wrote: > > > > > > > > > > > I have managed to configure and test OpenJPA in XA environment, > > and > > > > > > everything works ok, > > > > > > but cant configure it together with ODE. > > > > > > > > > > > > Thanks in advance > > > > > > > > > > > > > > > > > > On Feb 18, 2008 11:00 AM, xenHalfLife <[EMAIL PROTECTED]> > > wrote: > > > > > > > > > > > > > Hi, > > > > > > > > > > > > > > I have created database before running but now get some other > > > error > > > > > > > which I cant solve. Example > > > > > > > in usage is same as previously explained. Also, running with > or > > > > > without > > > > > > > file persistence.xml in META-INF/ folder > > > > > > > does not help either. (Tried with both JTA and RESOURCE_LOCAL > > > > > > > definition). > > > > > > > > > > > > > > Contents of the persistence.xml are as follows: > > > > > > > ========================================================= > > > > > > > <?xml version="1.0" encoding="UTF-8"?> > > > > > > > <persistence xmlns="http://java.sun.com/xml/ns/persistence"; > > > > > > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > > > > > > > version="1.0"> > > > > > > > <persistence-unit name="testunit" > > > > > transaction-type="RESOURCE_LOCAL"> > > > > > > > <class>my.jpa.test.Message</class> > > > > > > > <properties> > > > > > > > <property name="openjpa.Connection2URL" > > > > > > > value="jdbc:mysql://localhost/bpel"/> > > > > > > > <property name="openjpa.Connection2DriverName" > > value=" > > > > > > > com.mysql.jdbc.Driver"/> > > > > > > > <property name="openjpa.Connection2UserName" > > > > > value="root"/> > > > > > > > <property name="openjpa.Connection2Password" > > > > > value="root"/> > > > > > > > <property name="openjpa.Log" > > > > value="DefaultLevel=TRACE"/> > > > > > > > </properties> > > > > > > > </persistence-unit> > > > > > > > </persistence> > > > > > > > ========================================================= > > > > > > > > > > > > > > Following error occurs, thanks for any tips in advance: > > > > > > > > > > > > > > ========================================================= > > > > > > > 2008-02-18 10:42:13,440 DEBUG [openjpa.MetaData] - Resolving > > > mapping > > > > > for > > > > > > > "[EMAIL PROTECTED]". > > > > > > > 2008-02-18 10:42:13,440 DEBUG [openjpa.MetaData] - " > > > > > > > org.apache.ode.store.jpa.DeploymentUnitDaoImpl" has mapping > > > strategy > > > > > > > "full". > > > > > > > 2008-02-18 10:42:13,440 DEBUG [openjpa.MetaData] - > Resolving > > > > field > > > > > " > > > > > > > [EMAIL PROTECTED] > > > ._processes". > > > > > > > org.apache.ode.bpel.iapi.ContextException: DbError > > > > > > > at org.apache.ode.store.ProcessStoreImpl.exec( > > > > > ProcessStoreImpl.java > > > > > > > :545) > > > > > > > at org.apache.ode.store.ProcessStoreImpl.deploy( > > > > > > > ProcessStoreImpl.java:179) > > > > > > > at org.ode.xa.MockBpelServer.deploy(MockBpelServer.java > :91) > > > > > > > at org.ode.xa.Main2.main(Main2.java:29) > > > > > > > Caused by: java.util.concurrent.ExecutionException: < > > > > > > > openjpa-1.0.1-r420667:592145 nonfatal general error> > > > > > > > org.apache.openjpa.persistence.PersistenceException: error > > > enlisting > > > > a > > > > > > > JdbcConnectionHandle of a JdbcPooledConnection from datasource > > > > mysql-1 > > > > > in > > > > > > > state ACCESSIBLE wrapping > > > > > > > [EMAIL PROTECTED] on > > > > > > > [EMAIL PROTECTED] {SELECT > > > t0.id > > > > , > > > > > > > t0.VERSION FROM STORE_VERSIONS t0} [code=0, > > state=null]2008-02-18 > > > > > > > 10:42:13,455 DEBUG [openjpa.MetaData] - "_processes" has > > > mapping > > > > > > > strategy " > > > > > > > > > > > > > > > > > > > > > > org.apache.openjpa.jdbc.meta.strats.RelationCollectionInverseKeyFieldStrategy > > > > > > > ". > > > > > > > 2008-02-18 10:42:13,502 DEBUG [openjpa.jdbc.Schema] - Reading > > > table > > > > > > > information for schema name "null", table name > > > > > "OPENJPA_SEQUENCE_TABLE". > > > > > > > 2008-02-18 10:42:13,502 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 17189485> getColumns: bpel, null, OPENJPA_SEQUENCE_TABLE, null > > > > > > > 2008-02-18 10:42:13,565 DEBUG [openjpa.jdbc.Schema] - Reading > > > column > > > > > > > information for table "openjpa_sequence_table". > > > > > > > 2008-02-18 10:42:13,565 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "ID" on table "openjpa_sequence_table". > > > > > > > 2008-02-18 10:42:13,565 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "SEQUENCE_VALUE" on table "openjpa_sequence_table". > > > > > > > 2008-02-18 10:42:13,612 DEBUG [openjpa.jdbc.Schema] - Reading > > > table > > > > > > > information for schema name "null", table name "STORE_DU". > > > > > > > 2008-02-18 10:42:13,612 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 17189485> getColumns: bpel, null, STORE_DU, null > > > > > > > 2008-02-18 10:42:13,643 DEBUG [openjpa.jdbc.Schema] - Reading > > > column > > > > > > > information for table "store_du". > > > > > > > 2008-02-18 10:42:13,643 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "NAME" on table "store_du". > > > > > > > 2008-02-18 10:42:13,643 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "DEPLOYDT" on table "store_du". > > > > > > > 2008-02-18 10:42:13,643 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "DEPLOYER" on table "store_du". > > > > > > > 2008-02-18 10:42:13,643 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "DIR" on table "store_du". > > > > > > > 2008-02-18 10:42:13,643 DEBUG [openjpa.jdbc.Schema] - Reading > > > table > > > > > > > information for schema name "null", table name > "STORE_PROCESS". > > > > > > > 2008-02-18 10:42:13,643 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 17189485> getColumns: bpel, null, STORE_PROCESS, null > > > > > > > 2008-02-18 10:42:13,659 DEBUG [openjpa.jdbc.Schema] - Reading > > > column > > > > > > > information for table "store_process". > > > > > > > 2008-02-18 10:42:13,674 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "PID" on table "store_process". > > > > > > > 2008-02-18 10:42:13,674 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "STATE" on table "store_process". > > > > > > > 2008-02-18 10:42:13,674 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "TYPE" on table "store_process". > > > > > > > 2008-02-18 10:42:13,674 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "VERSION" on table "store_process". > > > > > > > 2008-02-18 10:42:13,674 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "DU" on table "store_process". > > > > > > > 2008-02-18 10:42:13,674 DEBUG [openjpa.jdbc.Schema] - Reading > > > table > > > > > > > information for schema name "null", table name > > > "STORE_PROCESS_PROP". > > > > > > > 2008-02-18 10:42:13,674 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 17189485> getColumns: bpel, null, STORE_PROCESS_PROP, null > > > > > > > 2008-02-18 10:42:13,705 DEBUG [openjpa.jdbc.Schema] - Reading > > > column > > > > > > > information for table "store_process_prop". > > > > > > > 2008-02-18 10:42:13,705 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "id" on table "store_process_prop". > > > > > > > 2008-02-18 10:42:13,705 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "PROP_KEY" on table "store_process_prop". > > > > > > > 2008-02-18 10:42:13,705 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "PROP_VAL" on table "store_process_prop". > > > > > > > 2008-02-18 10:42:13,705 DEBUG [openjpa.jdbc.Schema] - Reading > > > table > > > > > > > information for schema name "null", table name > > > "STORE_PROC_TO_PROP". > > > > > > > 2008-02-18 10:42:13,705 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 17189485> getColumns: bpel, null, STORE_PROC_TO_PROP, null > > > > > > > 2008-02-18 10:42:13,737 DEBUG [openjpa.jdbc.Schema] - Reading > > > column > > > > > > > information for table "store_proc_to_prop". > > > > > > > 2008-02-18 10:42:13,737 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "ProcessConfDaoImpl_PID" on table "store_proc_to_prop". > > > > > > > 2008-02-18 10:42:13,737 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "element_id" on table "store_proc_to_prop". > > > > > > > 2008-02-18 10:42:13,737 DEBUG [openjpa.jdbc.Schema] - Reading > > > table > > > > > > > information for schema name "null", table name > "STORE_VERSIONS". > > > > > > > 2008-02-18 10:42:13,737 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 17189485> getColumns: bpel, null, STORE_VERSIONS, null > > > > > > > 2008-02-18 10:42:13,752 DEBUG [openjpa.jdbc.Schema] - Reading > > > column > > > > > > > information for table "store_versions". > > > > > > > 2008-02-18 10:42:13,752 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "id" on table "store_versions". > > > > > > > 2008-02-18 10:42:13,768 DEBUG [openjpa.jdbc.Schema] - Found > > > existing > > > > > > > column "VERSION" on table "store_versions". > > > > > > > 2008-02-18 10:42:13,768 DEBUG [openjpa.jdbc.Schema] - Reading > > > > sequence > > > > > > > information for schema "null", sequence name "null". > > > > > > > 2008-02-18 10:42:13,768 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 17189485> [0 ms] commit > > > > > > > 2008-02-18 10:42:13,768 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 17189485> [0 ms] close > > > > > > > 2008-02-18 10:42:14,065 DEBUG [openjpa.MetaData] - Processing > > > > > registered > > > > > > > persistence-capable class "class > > > > > > > org.apache.ode.store.jpa.VersionTrackerDAOImpl". > > > > > > > 2008-02-18 10:42:14,065 DEBUG [openjpa.MetaData] - Processing > > > > > registered > > > > > > > persistence-capable class "class > > > > > > > org.apache.ode.store.jpa.ProcessConfPropertyDaoImpl". > > > > > > > 2008-02-18 10:42:14,065 DEBUG [openjpa.MetaData] - Processing > > > > > registered > > > > > > > persistence-capable class "class > > > > > > > org.apache.ode.store.jpa.DeploymentUnitDaoImpl". > > > > > > > 2008-02-18 10:42:14,065 DEBUG [openjpa.MetaData] - Processing > > > > > registered > > > > > > > persistence-capable class "class > > > > > > > org.apache.ode.store.jpa.ProcessConfDaoImpl". > > > > > > > 2008-02-18 10:42:14,065 DEBUG [openjpa.MetaData] - Loading > > > metadata > > > > > for > > > > > > > "class org.apache.ode.store.jpa.VersionTrackerDAOImpl" under > > mode > > > > > > > "[META][QUERY]". > > > > > > > 2008-02-18 10:42:14,065 DEBUG [openjpa.MetaData] - Parsing > class > > " > > > > > > > org.apache.ode.store.jpa.VersionTrackerDAOImpl". > > > > > > > 2008-02-18 10:42:14,065 DEBUG [openjpa.MetaData] - Parsing > > package > > > " > > > > > > > org.apache.ode.store.jpa.VersionTrackerDAOImpl". > > > > > > > 2008-02-18 10:42:14,065 DEBUG [openjpa.MetaData] - Generating > > > > default > > > > > > > metadata for type " > > org.apache.ode.store.jpa.VersionTrackerDAOImpl > > > ". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - Set > > > > > > > persistence-capable superclass of " > > > > > > > org.apache.ode.store.jpa.VersionTrackerDAOImpl" to "null". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - Resolving > > > > metadata > > > > > > > for "[EMAIL PROTECTED]". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - > Resolving > > > > field > > > > > " > > > > > > > [EMAIL PROTECTED] > > ._version". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - Preparing > > > mapping > > > > > for > > > > > > > "org.apache.ode.store.jpa.VersionTrackerDAOImpl". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - > Resolving > > > > field > > > > > " > > > > > > > [EMAIL PROTECTED] > > ._version". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - > > "_version" > > > > has > > > > > > > mapping strategy " > > > > > > > org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - " > > > > > > > org.apache.ode.store.jpa.VersionTrackerDAOImpl<discriminator>" > > has > > > > > > > mapping strategy "none". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - " > > > > > > > org.apache.ode.store.jpa.VersionTrackerDAOImpl<version>" has > > > mapping > > > > > > > strategy "none". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - Resolving > > > mapping > > > > > for > > > > > > > "[EMAIL PROTECTED]". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - " > > > > > > > org.apache.ode.store.jpa.VersionTrackerDAOImpl" has mapping > > > strategy > > > > > > > "full". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - > Initializing > > > > > mapping > > > > > > > for "[EMAIL PROTECTED]". > > > > > > > 2008-02-18 10:42:14,080 DEBUG [openjpa.MetaData] - > Resolving > > > > field > > > > > " > > > > > > > [EMAIL PROTECTED] > > ._version". > > > > > > > 2008-02-18 10:42:14,159 DEBUG [openjpa.Query] - Executing > query: > > > > > select > > > > > > > v from VersionTrackerDAOImpl v > > > > > > > 2008-02-18 10:42:14,268 DEBUG [openjpa.jdbc.JDBC] - <t > 21324485, > > > > conn > > > > > > > 18330704> [0 ms] close > > > > > > > > > > > > > > at java.util.concurrent.FutureTask$Sync.innerGet(Unknown > > > Source) > > > > > > > at java.util.concurrent.FutureTask.get(Unknown Source) > > > > > > > at org.apache.ode.store.ProcessStoreImpl.exec( > > > > > ProcessStoreImpl.java > > > > > > > :543) > > > > > > > ... 3 more > > > > > > > Caused by: <openjpa-1.0.1-r420667:592145 nonfatal general > error> > > > > > > > org.apache.openjpa.persistence.PersistenceException: error > > > enlisting > > > > a > > > > > > > JdbcConnectionHandle of a JdbcPooledConnection from datasource > > > > mysql-1 > > > > > in > > > > > > > state ACCESSIBLE wrapping > > > > > > > [EMAIL PROTECTED] on > > > > > > > [EMAIL PROTECTED] {SELECT > > > t0.id > > > > , > > > > > > > t0.VERSION FROM STORE_VERSIONS t0} [code=0, state=null] > > > > > > > at > > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException( > > > > > > > DBDictionary.java:3938) > > > > > > > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore( > > > > > > > SQLExceptions.java:97) > > > > > > > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore( > > > > > > > SQLExceptions.java:83) > > > > > > > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore( > > > > > > > SQLExceptions.java:59) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException > > > > > > > (SelectResultObjectProvider.java:155) > > > > > > > at org.apache.openjpa.lib.rop.EagerResultList.<init>( > > > > > > > EagerResultList.java:40) > > > > > > > at org.apache.openjpa.kernel.QueryImpl.toResult( > > QueryImpl.java > > > > > :1223) > > > > > > > at org.apache.openjpa.kernel.QueryImpl.execute( > > QueryImpl.java > > > > :990) > > > > > > > at org.apache.openjpa.kernel.QueryImpl.execute( > > QueryImpl.java > > > > :799) > > > > > > > at org.apache.openjpa.kernel.QueryImpl.execute( > > QueryImpl.java > > > > :769) > > > > > > > at org.apache.openjpa.kernel.QueryImpl.execute( > > QueryImpl.java > > > > :765) > > > > > > > at org.apache.openjpa.kernel.DelegatingQuery.execute( > > > > > > > DelegatingQuery.java:517) > > > > > > > at org.apache.openjpa.persistence.QueryImpl.execute( > > > > QueryImpl.java > > > > > > > :238) > > > > > > > at org.apache.openjpa.persistence.QueryImpl.getResultList( > > > > > > > QueryImpl.java:277) > > > > > > > at > > > > org.apache.ode.store.jpa.ConfStoreConnectionJpa.getNextVersion( > > > > > > > ConfStoreConnectionJpa.java:76) > > > > > > > at org.apache.ode.store.ProcessStoreImpl$1.call( > > > > > > > ProcessStoreImpl.java:181) > > > > > > > at org.apache.ode.store.ProcessStoreImpl$1.call( > > > > > > > ProcessStoreImpl.java:180) > > > > > > > at org.apache.ode.store.ProcessStoreImpl$Callable.call( > > > > > > > ProcessStoreImpl.java:702) > > > > > > > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown > > > Source) > > > > > > > at java.util.concurrent.FutureTask.run(Unknown Source) > > > > > > > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask > > > > (Unknown > > > > > > > Source) > > > > > > > at java.util.concurrent.ThreadPoolExecutor$Worker.run > > (Unknown > > > > > > > Source) > > > > > > > at java.lang.Thread.run(Unknown Source) > > > > > > > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: > > > error > > > > > > > enlisting a JdbcConnectionHandle of a JdbcPooledConnection > from > > > > > datasource > > > > > > > mysql-1 in state ACCESSIBLE wrapping > > > > > > > [EMAIL PROTECTED] on > > > > > > > [EMAIL PROTECTED] {SELECT > > > t0.id > > > > , > > > > > > > t0.VERSION FROM STORE_VERSIONS t0} [code=0, state=null] > > > > > > > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap > > > ( > > > > > > > LoggingConnectionDecorator.java:201) > > > > > > > at > > > > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000 > > > > > > > (LoggingConnectionDecorator.java:57) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement > > > > > > > (LoggingConnectionDecorator.java:228) > > > > > > > at > > > > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement > > > > > > > (DelegatingConnection.java:163) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement > > > > > > > (ConfiguringConnectionDecorator.java:140) > > > > > > > at > > > > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement > > > > > > > (DelegatingConnection.java:163) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement > > > > > > > (JDBCStoreManager.java:1308) > > > > > > > at > > > > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement > > > > > > > (DelegatingConnection.java:152) > > > > > > > at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement( > > > > > > > SQLBuffer.java:475) > > > > > > > at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement( > > > > > > > SQLBuffer.java:455) > > > > > > > at org.apache.openjpa.jdbc.sql.SelectImpl.execute( > > > > SelectImpl.java > > > > > > > :354) > > > > > > > at org.apache.openjpa.jdbc.sql.SelectImpl.execute( > > > > SelectImpl.java > > > > > > > :327) > > > > > > > at > > > org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute( > > > > > > > LogicalUnion.java:407) > > > > > > > at org.apache.openjpa.jdbc.sql.LogicalUnion.execute( > > > > > > > LogicalUnion.java:218) > > > > > > > at org.apache.openjpa.jdbc.sql.LogicalUnion.execute( > > > > > > > LogicalUnion.java:208) > > > > > > > at > > > > org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open( > > > > > > > SelectResultObjectProvider.java:94) > > > > > > > at org.apache.openjpa.lib.rop.EagerResultList.<init>( > > > > > > > EagerResultList.java:34) > > > > > > > ... 17 more > > > > > > > Feb 18, 2008 10:42:14 AM > > > > bitronix.tm.BitronixTransactionManagershutdown > > > > > > > INFO: shutting down Bitronix Transaction Manager > > > > > > > ========================================================= > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Feb 11, 2008 5:47 PM, Alex Boisvert <[EMAIL PROTECTED]> > > > wrote: > > > > > > > > > > > > > > > Looks like OpenJPA is trying to synchronize your database > > schema > > > > > with > > > > > > > > its > > > > > > > > own internal model... which results in DDL statements and > > those > > > > are > > > > > > > > not > > > > > > > > transactional so can't run within a transaction. > > > > > > > > > > > > > > > > I would try either, > > > > > > > > 1) initialize/synchronize your database schema before > starting > > > Ode > > > > > > > > 2) disable schema synchronization in OpenJPA > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > http://openjpa.apache.org/docs/latest/manual/manual.html#openjpa.jdbc.SynchronizeMappings > > > > > > > > > > > > > > > > alex > > > > > > > > > > > > > > > > On 2/9/08, xenHalfLife <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > Hello all, > > > > > > > > > > > > > > > > > > I am still trying to configure ODE in XA environment. Next > > > > example > > > > > > > > is > > > > > > > > > based on > > > > > > > > > MockBpelServer class found in > > > org.apache.ode.bpel.runtimepackage. > > > > > > > > That > > > > > > > > > example > > > > > > > > > demonstrates how to manage transactions using > > > TransactionManager > > > > > > > > > interface. > > > > > > > > > > > > > > > > > > Only changes I have made to MockBpelServer are the > injection > > > of > > > > > > > > DataSource > > > > > > > > > and > > > > > > > > > TransactionManager objects by me. These 2 objects are > > created > > > > > > > > externally, > > > > > > > > > and > > > > > > > > > set to MockBpelServer for further usage. All other code of > > > > > > > > MockBpelServer > > > > > > > > > is > > > > > > > > > untouched, including 2 crucial methods: deploy and invoke. > > > > > > > > > > > > > > > > > > MySql is used as database and Bitrnoix as JTA transaction > > > > manager. > > > > > I > > > > > > > > have > > > > > > > > > tested > > > > > > > > > these two with ActiveMq JMS broker, and they function > > > correctly. > > > > > > > > > > > > > > > > > > Thanks in advance. > > > > > > > > > > > > > > > > > > Main method contains following code, and it tries only to > > > > > > > > transactionally > > > > > > > > > invoke > > > > > > > > > ODE by using JTA API (it is not trying to invoke ODE and > > some > > > > > other > > > > > > > > XA > > > > > > > > > resource, > > > > > > > > > that would be next step when this is working) > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
