[JBoss jBPM] - Re: Transaction Issue
by 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
15 years, 12 months
jbpm prototype findings tasks, timers and cleaning up
by Dan Oxlade
We're currently prototyping a jBpm solution and have so far found it to
be very effective.
We are now experimenting with tasks and timers and have had to implement
a few features ourselves, I'm not sure if we are using the engine
correctly in doing this and wanted to list my experiences.
Tasks
We found that when leaving a task-node with multiple tasks
signal="first" we leave open tasks. We implemented an action to remove
all open tasks for this node on "node-leave". This seems to be a common
pattern for us.
Timers
Timer only support events at points relative to 'now' i.e "In 3 business
hours"
We have represented a timer in the process that can be dynamic; an
example is a task expiry (which links with the removal of tasks above)
driven by an external business concept.
We implemented our own CreateTimerAction wrapping the jBpm one and use a
strategy for the resolution of 'dueDate'.
This means we use an event node with a nested action (our
CreateTimerAction) to create the Timer at the appropriate place.
Has anyone else has a similar experience and do these concepts make
sense?
Kind regards,
Dan Oxlade
________________________________________________________________________
This e-mail and its attachments are confidential. If you are not the intended recipient of this e-mail message, please telephone or e-mail us immediately, delete this message from your system and do not read, copy, distribute, disclose or otherwise use this e-mail message and any attachments.
Although RI3K believes this e-mail and any attachments to be free of any virus or other defect which may affect your computer, it is the responsibility of the recipient to ensure that it is virus free and RI3K does not accept any responsibility for any loss or damage in any way from its use.
RI3K Limited is a company registered in England no: 3909745. Registered office 10, Ely Place, London, EC1N 6RY. VAT registration no: 769 0192 07
15 years, 12 months
[JBoss jBPM] - Re: Transaction Issue
by Toriton
Another configuration:
| <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
| <property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property>
| <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>
| <property name="hibernate.query.substitutions">true 1, false 0</property>
| <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
| <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
|
same error.
The Transaction Manager.. is specified for JBoss i think that i can't change it for another right?..
Thanks in advance for any reply.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4213642#4213642
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4213642
15 years, 12 months
[JBoss jBPM] - Re: Transaction Issue
by Toriton
Hi brads thanks for reply.
I changed that properties too and many others to try something.
this is the FULL Hiberante configuration ATM (plus all mapping resource hbm.xml that Jbpm need):
| <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
| <property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property>
| <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>
|
As you can see i'm using now just the DataSource specified as tx-local (see the post above), and getting the same error with only the DataSource not jdbc properties spefied in the Hibernate.cfg.
I can still loggging in the console, but as usual can't get task or users or insert a new user or group via conosole.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4213627#4213627
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4213627
15 years, 12 months