Author: alex.guizar(a)jboss.com Date: 2009-03-08 20:08:33 -0400 (Sun, 08 Mar 2009) New Revision: 4195 Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.common.xml Log: have hibernate order updates to decrease deadlock occurrences Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.common.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.common.xml 2009-03-08 12:20:29 UTC (rev 4194) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.common.xml 2009-03-09 00:08:33 UTC (rev 4195) @@ -6,7 +6,6 @@ <!-- JTA transaction properties (begin) === <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> ==== JTA transaction properties (end) --> <!-- CMT transaction properties (begin) === @@ -29,6 +28,10 @@ <property name="hibernate.format_sql">true</property> <property name="hibernate.use_sql_comments">true</property> + <!-- order SQL inserts and updates, resulting in fewer transaction deadlocks --> + <property name="hibernate.order_inserts">true</property> + <property name="hibernate.order_updates">true</property> + <!-- ############################################ --> <!-- # mapping files with external dependencies # --> <!-- ############################################ -->