How are you getting the connection from the Entity Manager? It seems that
the isolation level setting before populate interferes with the read
queries. Have you attempted to use straight JDBC to test this isolation
level with your database? Start transaction by setting autocommit to
false, insert data and then execute 2 queries. It is possible, although
unexpected, that the isolation level is causing the second query to not
see the transactional updates.
--Gordon