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

[Toriton]

Hi all i'm new on JBPM.

I'm using JBPM 3.3.1 with JBoss 4.2.2GA and Oracle 10 Express.

I edited the hibernate.cfg.xml to point at Oracle , and seem all ok.
I created the standard user and group and membership to access the console but when i'm logged, the pages show several errors:


Error loading task list: An exception of type "org.jbpm.JbpmException" was thrown. The message is: couldn't get task instances list for actor 'manager'


Error loading process list: An exception of type "org.jbpm.JbpmException" was thrown. The message is: couldn't find all process definitions 


Error loading task list: An exception of type "org.jbpm.JbpmException" was thrown. The message is: couldn't get task instances list for actor 'manager'

those messages are showed on pages in the console , browsing between
process list page,or user/groups list page and so on, but  on the log the error that i can see is :

2009-02-11 16:41:46,250 DEBUG [org.jbpm.svc.Services] closing service 'authentication': org.jbpm.security.authentication.DefaultAuthenticationService at 1bc865a
2009-02-11 16:41:49,234 DEBUG [org.jbpm.configuration.JbpmContextInfo] creating jbpm context with service factories '[tx, message, scheduler, logging, persistence, authentication]'
2009-02-11 16:41:49,234 DEBUG [org.jbpm.JbpmContext] creating org.jbpm.JbpmContext at 18a174
2009-02-11 16:41:49,234 DEBUG [org.jbpm.persistence.jta.JtaDbPersistenceService] begin user transaction
2009-02-11 16:41:49,234 DEBUG [org.jbpm.persistence.db.DbPersistenceService] using current hibernate session
2009-02-11 16:41:49,234 ERROR [org.jbpm.db.TaskMgmtSession] org.hibernate.HibernateException: getNamedQuery is not valid without active transaction
2009-02-11 16:41:49,312 DEBUG [org.jbpm.JbpmContext] closing jbpmContext org.jbpm.JbpmContext at 18a174
2009-02-11 16:41:49,312 DEBUG [org.jbpm.svc.Services] closing service 'persistence': org.jbpm.persistence.jta.JtaDbPersistenceService at 1e573e3
2009-02-11 16:41:49,312 DEBUG [org.jbpm.persistence.jta.JtaDbPersistenceService] rolling back user transaction
2009-02-11 16:41:49,312 DEBUG [org.jbpm.svc.Services] closing service 'tx': org.jbpm.tx.TxService at 11b5298
2009-02-11 16:41:49,312 DEBUG [org.jbpm.svc.Services] closing service 'authentication': org.jbpm.security.authentication.DefaultAuthenticationService at cbad03



this is a part of my config file, to create datasource for Hibernate:

  | 
  |     <!-- hibernate dialect -->
  |     <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
  | 
  |     
  |     <property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property>
  | 
  |     <!-- DataSource properties (begin) -->
  |     <property name="hibernate.connection.datasource">java:JbpmDS</property>
  |     <!-- DataSource properties (end) -->
  | 
  |     <!-- JTA transaction properties (begin) -->
  |     <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
  |     <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
  |     <property name="hibernate.connection.username">system</property>
  |     <property name="hibernate.connection.password">123</property>
  |     <!-- JTA transaction properties (end) -->
  | 
  |     <!-- CMT transaction properties (begin) ===
  |     <property name="hibernate.transaction.factory_class">org.hibernate.transaction.CMTTransactionFactory</property>
  |     <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
  |     ==== CMT transaction properties (end) -->
  | 
  |  




The Data Source named "java:JbpmDS" is defined here:

<?xml version="1.0" encoding="UTF-8"?>
  | <datasources>
  | 
  |   <xa-datasource>
  |     <jndi-name>JbpmDS</jndi-name>
  | 		
  | 		<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>
  |     <user-name>system</user-name>
  |     <password>123</password>
  |     
  |     
  |     
  |     <!-- 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 />
  | 
  |     <!-- leverage mysql integration features -->
  |     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  |     <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
  | 
  |     <!-- corresponding type-mapping in conf/standardjbosscmp-jdbc.xml -->
  |     <metadata>
  |       <type-mapping>Oracle9i</type-mapping>
  |     </metadata>
  |   </xa-datasource>
  | 
  | </datasources>



i'm not sure if this part is correct, but i don't found anithing about Oracle 10 in the conf files of JBoss about Oracle 10.
    
      <type-mapping>Oracle9i</type-mapping>
    


Anyone can suggest a workaround or something to solve this problem?.


thanks in advance.







View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4209129#4209129

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