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]". > > 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]". > > 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]". > > 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]". > > 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.BitronixTransactionManager shutdown > > 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.runtime package. > > > 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) > > > > > > > > > > > > > > > >
