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