Got it.
not more problem and with an XA DataSource. the problems was, this :
UserTransaction
Not specified in other Config files.
If could Help this is my final configuration:
XA DS Oracle (cut and past of the example under JBOSS):
| <?xml version="1.0" encoding="UTF-8"?>
| <datasources>
|
| <xa-datasource>
| <jndi-name>JbpmDS</jndi-name>
| <track-connection-by-tx/>
| <isSameRM-override-value>false</isSameRM-override-value>
|
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
| <xa-datasource-property
name="URL">jdbc:oracle:thin:@localhost:1521:XE</xa-datasource-property>
| <xa-datasource-property
name="User">system</xa-datasource-property>
| <xa-datasource-property
name="Password">123</xa-datasource-property>
| <!--user-name>system</user-name>
| <password>123</password-->
|
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
| <application-managed-security/>
| <!-- reduce isolation from the default level (repeatable read) -->
|
<!--transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation-->
| <!-- separate connections used with and without JTA transaction -->
| <no-tx-separate-pools />
| <!-- disable transaction interleaving -->
| <!-- track-connection-by-tx /-->
|
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
|
| <!--mbean
code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"
| name="jboss.jca:service=OracleXAExceptionFormatter">
| <depends
optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
| </mbean-->
|
| <!-- corresponding type-mapping in conf/standardjbosscmp-jdbc.xml -->
| <metadata>
| <type-mapping>Oracle9i</type-mapping>
| </metadata>
| </xa-datasource>
|
| </datasources>
|
and the Hibernate.cfg (missing just the part of all hbm.xml files):
| <property
name="hibernate.connection.datasource">java:/JbpmDS</property>
| <property
name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
| <property
name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
| <property
name="jta.UserTransaction">UserTransaction</property>
|
| <!-- ################################### -->
| <!-- # common settings # -->
| <!-- ################################### -->
|
| <!-- Automatic schema creation (begin) ===
| <property name="hibernate.hbm2ddl.auto">create</property>
| ==== Automatic schema creation (end) -->
|
| <!-- Simple memory-only cache -->
| <property
name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
|
| <!-- logging properties -->
| <property name="hibernate.format_sql">true</property>
| <property name="hibernate.use_sql_comments">true</property>
|
I hope that this can help anyone that need a start configuration.
Thanks for the reply .
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4213735#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...