Transaction Issue
toriton Feb 11, 2009 11:02 AMHi 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@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@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@18a174
2009-02-11 16:41:49,312 DEBUG [org.jbpm.svc.Services] closing service 'persistence': org.jbpm.persistence.jta.JtaDbPersistenceService@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@11b5298
2009-02-11 16:41:49,312 DEBUG [org.jbpm.svc.Services] closing service 'authentication': org.jbpm.security.authentication.DefaultAuthenticationService@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.