Entity not committed when expected

[emerson-dev-br]

During the execution of a process I open two transactions:

• One to create an object and inform that the process has started;
• Another to change the object that was created in the first transaction, informing that the process was completed;

However, after executing the second transaction method, if I query the database the value has not yet been updated. What I expected is that after the execution of the method with the @transactional annotation is finished, the object is already committed to the database.

The reproduction of the situation is in the project:
https://github.com/emersonl91/quarkus-test

Important lines:
https://github.com/emersonl91/quarkus-tests/blob/master/code-with-quarkus/src/main/java/org/acme/MyService.java#L32

https://github.com/emersonl91/quarkus-tests/blob/master/code-with-quarkus/src/test/java/org/acme/ExampleResourceTest.java#L37

---

Edit 1:

• I tested the UserTransaction and TransactionManager classes, but the same problem also occurs.
• Added the @transaction annotation to the method that makes the calls, the whole process starts to be executed in a single transaction, which is different from what I expect.

---

Edit 2:

• In the transactionTest method I added the @transactional(NOT_SUPPORTED) annotation, in the persist and update methods I added the @transactional(REQUIRES_NEW) annotation. The result did not change.

---

Edit 3:

• I did a test via POSTMAN and with MSSQL database. I followed the request in the database, the entity is updated as expected, but in the application I use the command MyEntity.findAll().list().get(0) and the entity remains not updated.

[zeljkot]

Is it similar to this: #7102?

[emerson-dev-br]

@zeljkot Yes, it looks very similar to me.

[gastaldi]

Should we close this issue as duplicate and focus on #7102? Looks like #7188 is also related

[emerson-dev-br]

@gastaldi i agree

[gastaldi]

@emersonl91 thanks! Closing as duplicate of #7102

[zeljkot]

Should we close this issue as duplicate and focus on #7102? Looks like #7188 is also related

@gastaldi if I understood @FroMage correctly, #7188 is a different issue, as discussed in #7102 thread.