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