[Persistence, JBoss/CMP, Hibernate, Database] - lock when commit to multiple database
by coolin
lock occured in ejb transaction when commit to 2 different databases simultaneously.
as result: both database (data1 and data 2 are locked)
but separately or not in transaction is ok.
jboss 4.2.Hibernarte 3.2.5.ga
| ...
| @Stateless
| @Local(value = ProcessingLocal.class)
| public class ProcessingBean implements ProcessingLocal
| {
| @EJB(beanName = "Data1Bean", beanInterface = Data1Local.class)
| private Data1Local data1;
| @EJB(beanName = "Data2Bean", beanInterface = Data2Local.class)
| private Data2Local data2;
|
| public void test() throws Exception
| {
| Entity1 e1 = new Entity1();
| data1.merge(e1);
|
| Entity2 e2 = new Entity2();
| data2.merge(e2);
| }
| }
|
|
data-ds.xml
| <datasources>
|
| <xa-datasource>
| <jndi-name>data1</jndi-name>
| <xa-datasource-class>com.informix.jdbcx.IfxXADataSource</xa-datasource-class>
| <xa-datasource-property name="IfxIFXHOST">serv1</xa-datasource-property>
| <xa-datasource-property name="IfxIFX_LOCK_MODE_WAIT">100</xa-datasource-property>
| <xa-datasource-property name="PortNumber">6666</xa-datasource-property>
| <xa-datasource-property name="DatabaseName">data1</xa-datasource-property>
| <xa-datasource-property name="ServerName">main</xa-datasource-property>
| <xa-datasource-property name="User">informix</xa-datasource-property>
| <xa-datasource-property name="Password">informix</xa-datasource-property>
| <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
|
| <min-pool-size>5</min-pool-size>
| <max-pool-size>1000</max-pool-size>
|
| <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter
| </exception-sorter-class-name>
|
| <metadata>
| <type-mapping>InformixDB</type-mapping>
| </metadata>
|
| </xa-datasource>
|
| <xa-datasource>
| <jndi-name>data2</jndi-name>
| <xa-datasource-class>com.informix.jdbcx.IfxXADataSource</xa-datasource-class>
| <xa-datasource-property name="IfxIFXHOST">serv1</xa-datasource-property>
| <xa-datasource-property name="IfxIFX_LOCK_MODE_WAIT">100</xa-datasource-property>
| <xa-datasource-property name="PortNumber">6666</xa-datasource-property>
| <xa-datasource-property name="DatabaseName">data2</xa-datasource-property>
| <xa-datasource-property name="ServerName">main</xa-datasource-property>
| <xa-datasource-property name="User">informix</xa-datasource-property>
| <xa-datasource-property name="Password">informix</xa-datasource-property>
| <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
|
| <min-pool-size>5</min-pool-size>
| <max-pool-size>1000</max-pool-size>
|
| <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter
| </exception-sorter-class-name>
|
| <metadata>
| <type-mapping>InformixDB</type-mapping>
| </metadata>
|
| </xa-datasource>
|
| </datasources>
|
in unit 1
persistence.xml
|
| <?xml version="1.0" encoding="UTF-8"?>
| <persistence xmlns="http://java.sun.com/xml/ns/persistence"
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
| xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
| http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
| version="1.0">
|
| <persistence-unit name="data1" transaction-type="JTA">
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
| <jta-data-source>java:/data1</jta-data-source>
| <properties>
| <property name="hibernate.show_sql" value="false"/>
| <property name="hibernate.format_sql" value="true"/>
| <property name="hibernate.transaction.factory_class" value="org.hibernate.ejb.transaction.JoinableCMTTransactionFactory"/>
| <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
| </properties>
| </persistence-unit>
|
| </persistence>
|
|
in unit 2
persistence.xml
|
| <?xml version="1.0" encoding="UTF-8"?>
| <persistence xmlns="http://java.sun.com/xml/ns/persistence"
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
| xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
| http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
| version="1.0">
|
| <persistence-unit name="data2" transaction-type="JTA">
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
| <jta-data-source>java:/data2</jta-data-source>
| <properties>
| <property name="hibernate.show_sql" value="false"/>
| <property name="hibernate.format_sql" value="true"/>
| <property name="hibernate.transaction.factory_class" value="org.hibernate.ejb.transaction.JoinableCMTTransactionFactory"/>
| <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
| </properties>
| </persistence-unit>
|
| </persistence>
|
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4119529#4119529
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4119529
18 years, 3 months