[jboss-user] [EJB/JBoss] - HELP, PROBLEMS CONNECTING TO MULTIPLE DATASOURCES

[sbarreros]

Hello,
I have this ejb that queries one database in one machine, gets the resultset massages the data opens a new connection to another database in a different machine and it is supposed to insert the data. However I get the following error message:

2009-02-13 18:32:50,188 INFO  [STDOUT] org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 7f000101:e001:4995ebf3:117 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 7f000101:e001:4995ebf3:117 status: ActionStatus.ABORT_ONLY >)


I know it has to do with the different machine connections, because if I import the table and the data to the target database and use the same datasource to run the EJB it runs with no problem.
JBoss 4.2.2
Mysql database

Thanks for any help 

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4210076#4210076

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4210076