Re: How to detect database for Tomcat JDBC Realm is down

[Ivan Cheung <iv...@pobox.com>]

Hi,

>
> I am building a web app and was able to setup digest authentication
>
> I am testing the app when I take the database that contains the username
> password down
>
> The tomcat log file show this
>
> java.sql.SQLException: No operations allowed after connection closed.
>     at com.mysql.jdbc.Connection.checkClosed(Connection.java:2647)
>     at com.mysql.jdbc.Connection.commit(Connection.java:1039)
>     at org.apache.catalina.realm.JDBCRealm.getPassword(JDBCRealm.java:563)
>     at org.apache.catalina.realm.RealmBase.getDigest(RealmBase.java:1091)
>
> I have setup the WEB-INF/web.xml to trap this error to show a custom error
> page
>
>   <error-page>
>     <exception-type>java.sql.SQLException</exception-type>
>     <location>/server_rdbms_error.html</location>
>   </error-page>
>
> however tomcat is not showing the custom error page and it keep popping
> the login page over and over again.
>
> I was wondering if someone can tell me what is the proper way to setup the
> custom error page when the database is down and authentication fail.
>
> Please reply to me direct since I am not on the alias.
>
> Thanks,
> Ivan
>