I have two applications that access the same DB. Application One inserts data into a table commits and commits. Application Two sits in a loop and waits for the data to be available.

When I open a new connection and run a SELECT query in Application Two, it sees the data.

I would like to leave the connection open vs having to open each time. If I leave Application Two's connection open while Application One commits new data to the data base, even when I run a new query Application One will not see the new data UNLESS I close the connection and re open it. I am not sure how I can fix this as I do not want to keep re-opening and closing the connection due to some constraints of application I am developing.