[SOLVED] Inserted Data not visible outside the application server where has been created over a remote call to a second application

Inserted Data not visible outside the application server where has been created over a remote call to a second application

I encountered a problem when using postgreSQL 11 and Jboss EAP 7.3 : I have two separate applications deployed on Jboss EAP 7.3 in two different node .

The 1st application has created some data and has made a call to the 2nd application via a remote call . When fetching data in the 2d application nothing is found knowing that everything is in the same transaction even the call to the 2nd application's ejb was done using Required transaction propagation .

This case is working fine when using Oracle Database and not in PostegreSQL.

The Default_isolation_level is READ_Commited for both Oracle and PosteGreSQL .

Any ideas ?

Thanks

Solution

Unless you have some trivial error, like you connect to different databases, the explanation must be that the first application didn't commit its database transaction before the second application tries to read the data.

Before a transaction is committed, all its effects are invisible outside the transaction.