We have been going back and forth between our application and admin teams on this issue without much success.

Using spring hibernate, the app connects to both Oracle and MS SQL databases.

Our production is in Oracle and the MS SQL is a 3rd party application database we use for pulling reference information.

On occasion, the MS SQL may become unavailable which throws an exception in our app.
This exception is currently not being handled.

Later when the database becomes available again the app will still see it as unavailable.
The same thing would happen on the Oracle side if the Listener was bounced.

I'm looking for help/direction we can give both teams to get this resolved.
We are doing something obviously wrong if we can't recover without a full restart of the app.

This is a sample of our MS SQL data resource defined in server.xml:
Code:
        <Resource name="jdbc/maps"
            auth="Container"
            driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
            factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
            type="javax.sql.DataSource"
            fairQueue="false"
            initialSize="0"
            jmxEnabled="true"
            logAbandoned="true"
            maxActive="20"
            maxIdle="10"
            maxWait="10000"
            minEvictableIdleTimeMillis="5000"
            minIdle="10"
            removeAbandoned="true"
            removeAbandonedTimeout="300"
            testOnBorrow="true"
            testOnReturn="false"
            testWhileIdle="false"
            timeBetweenEvictionRunsMillis="5000"
            useEquals="false"
            validationInterval="30000"
            validationQuery="SELECT 2+2"
            url="jdbc:sqlserver://MSSQLSRV:1433;databaseName=DATA1"
            username=deleted 
            password=deleted
            />