I am having a problem where I have application A running in a JVM (no application server) and have application B running in a JVM (no application server). Application A selects from table Y every 10 seconds checking for new rows. Application B places records into table Y. Application A never picks up the new rows. If I start and stop Application A then he picks up the new rows. I have tried turning off first and second level query caching as well as turning of caching all together. I should also mention that I am using Hibernate as my implementation of JPA. I am not using a hibernate cfg but I am using a Persistence.xml. I am running under JDK 1.6. Any help is much appreciated.

You need to commit the transaction and flush the session. So that the new records will be read by other application

Can you share the code which inserts data into the DB