aspose file tools*
The moose likes JBoss/WildFly and the fly likes Problem  with XA Transactions in JBoss when use multiple datasources for related tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Problem  with XA Transactions in JBoss when use multiple datasources for related tables" Watch "Problem  with XA Transactions in JBoss when use multiple datasources for related tables" New topic
Author

Problem with XA Transactions in JBoss when use multiple datasources for related tables

Christian Barahona
Greenhorn

Joined: Jul 21, 2011
Posts: 1
Help me please with XA transactions.

I can't create two records in two related tables of differents schemas from DB2 AS400 database.

I'm developing an application with EJB 3.1, JPA 2.0, Hibernate 3.6.5, JBoss AS 6.0, DB2 AS400. All it's configured with XA transactions support.

I have two tables:KSSEGTUSER in DSMXMBASE schema, SSPCOTFUNCIONARIO in DSMXCORP schema.






KSSEGTUSER is mapped to UserDTO JPA 2.0 entity bean in the prjFrameworkV2 project.

SSPCOTFUNCIONARIO is mapped to FuncionarioDTO JPA 2.0 entity bean in the prjCorporativoV2 project.



For create or update the UserDTO, I have a Singleton Session bean named UsuarioServiceImpl, it has a UsuarioServiceLocal by Local Session Bean interface and it has a UsuarioServiceRemote by Remote Session Bean interface.



For create or update the FuncionarioDTO, I have a Singleton Session bean named FuncionarioServiceImpl, it has a FuncionarioServiceLocal by



Local Session Bean interface and

it has a FuncionarioServiceRemote by Remote Session Bean interface.



In the create method of funcionario of FuncionarioServiceImpl I'm calling to create method of usuario of UsuarioServiceImpl via EJB Local injection.



The problem is that I don´t insert the user and employee in same transaction, the application throw an exception when inserting the employe, the stack trace is:







But when I deploy the same application in GlassFish 3.1, the application works fine. The funcionario and usuario was cretead sucessfully.

I'm testing this functionality via Servlet http://localhost:8080/prjCorporativoWeb/Transaccion.



Help me please. How to configure the JBoss 6.0 to works in this scenario? or may be the problem is the application?



Please see the source of attachments.



Thanks.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with XA Transactions in JBoss when use multiple datasources for related tables