[JBoss jBPM] - Transaction Issue
by 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@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.
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
15 years, 4 months