Hi!
I have an EJB using a DAO to store stuff in Oracle 9.
The DAO gets a new Connection for every method (calls DataSource.getConnection()), and closes it before returning.
This works until someone restarts the Oracle server. Then I get a lot of "socket closed" exceptions until I restart JBoss. It seems like the connection pool still return broken connections to the DAO.
How can I tell JBoss to automatically reconnect to the Oracle server when it's back online?