How to enforce database insert with JPA?

[Oliver Rensen]

Hi,

we use JPA 2 (EclipseLink) to do the following:

a) Insert a record into a table from our ERP-system.
b) Call an event for our ERP-system.
c) The ERP-system (not Java based) reads the record from a) after receiving the event.


a) and b) looks like the following:

em = EntityManager
try {
    insert = "sql-statement";
    em.getTransaction().begin();
    em.createNativeQuery(insert).executeUpdate();
    em.getTransaction().commit();
catch (Exception ex) {
...
} finally {
em.close();
}

call ERP-event

Sometimes the problem occurs that the ERP-system cannot see the inserted record, because the ERP-event executes faster than the record was inserted with JPA.

Is it possible to guarantee after em.close() that the database is up to date?

Kind regards
Oliver