3

I have 2 data source and in a method, I need to write and read from the 2 databases. The database is PostgreSQL and my EAR app runs on wildfly-16.

I can't use 2 database connection in the same method

Ok, I know that because the system can't manage a transaction across the different database.

So I splitted the methods in my ejb :

@TransactionAttribute(TransactionAttributeType.NEVER)
public Response mainMethod(String parameter) {
   method1();
   method2()
}

@TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)
private void method1(){
    ...write on database 1...
}

@TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)
private void method2(){
    ...write on database 2...
}

Why am I still getting the same error? Aren't the calls managed by two different transactions?

ARJUNA012140: Adding multiple last resources is disallowed. 
Trying to add LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@594d9ba8[connectionListener=677e78 connectionManager=2a095926 warned=false currentXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a86e69:-9dc6f57:5d08b51e:f58, node_name=1, branch_uid=0:ffffc0a86e69:-9dc6f57:5d08b51e:f8a, subordinatenodename=null, eis_name=java:/jboss/datasource/db1 > productName=PostgreSQL productVersion=10.8 (Ubuntu 10.8-0ubuntu0.18.04.1) jndiName=java:/jboss/datasource/db1])), 
but already have LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@39fc2dc2[connectionListener=3724f31c connectionManager=39a995fb warned=false currentXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a86e69:-9dc6f57:5d08b51e:f58, node_name=1, branch_uid=0:ffffc0a86e69:-9dc6f57:5d08b51e:f64, subordinatenodename=null, eis_name=java:/jboss/datasource/db2 > productName=PostgreSQL productVersion=10.8 (Ubuntu 10.8-0ubuntu0.18.04.1) jndiName=java:/jboss/datasource/db2]))
Dushyant Tankariya
  • 1,432
  • 3
  • 11
  • 17
Daniele Licitra
  • 1,520
  • 21
  • 45
  • Possible duplicate of [Error retrieving connections in jboss to multiple databases even though there is no transaction](https://stackoverflow.com/questions/12290285/error-retrieving-connections-in-jboss-to-multiple-databases-even-though-there-is) – Dushyant Tankariya Jun 18 '19 at 14:14

2 Answers2

4

Annotations use dynamic proxies under the cover and so don't work on private methods nor on public ones called internally (on this). You have to declare your two methods in different EJBs.

Otherwise regarding your error, The system can manage transaction across different resources using XA.

Just switch one of your datasources to xa-datasource and you'll get rid off the problem. Note that you can have one non-xa datasource in an XA transaction thanks to LLRTO but not two (that's the meaning of the arjuna error).

Gab
  • 7,869
  • 4
  • 37
  • 68
-2

Hey just in case someone comes across this error on my end I forgot to close the connection

finally {
    call.closeAll();
}

this resulted to error:

Could not get a connection from the data source , Adding multiple last resources is disallowed.Current resource is org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@17d3bab6
Kaveh
  • 1,158
  • 6
  • 16
Siya Nxuseka
  • 67
  • 3
  • 8
  • This is not the same error message as in OP's question. Your answer seem to be off-topic. If I'm wrong please edit and explain. Thanks. – Eric Aya Jun 24 '21 at 15:37
  • @EricAya, it may not be the same scenario but I had the similar issue I opened database connection with one stored procedure then forgot to close it the next proc in the same session tries to open the open ended connection thus it treats the second connection as another database connection but my standalone.xml file uses local-tx-database thus it throws this error. – Siya Nxuseka Jun 26 '21 at 16:52