1 Reply Latest reply on Mar 24, 2010 1:31 AM by H U

    HELP, PROBLEMS CONNECTING TO MULTIPLE DATASOURCES

    Sergio Newbie

      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