[jboss-user] [JBoss jBPM] - Re: Transaction Issue

[Toriton]

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#4213735

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4213735