Hi All,
I use the default pooling for JBoss with PostGreSQL. The application uses min 2 connections and max 10.
But over night there are no users and (i think) PostGreSQL times out the connections held by the pool and in the morning when user tries an operation which uses a connection from the pool the users' transaction fails to complete. How do i configure a DB and a pool to get around this problem ?