Can JBP be configured to handle a routine weekly disconnect

[sjewett]

Hi All -

We are about to go live with our new Doc Management app using JBoss Portal 2.4.1 SP1. (JBoss AS 4.0.4 GA, Oracle 9i, RedHat EL4). Our database goes down for a weekly maintenance every weekend. We have found that the AS needs to be restarted every Monday morning to restore connection to the database (and thus the functionality of the application).

Other than writing a script to bring down JBoss AS before the maintenance then start it up again afterward, is there a way to configure the Portal to handle this break in DB connection?

Thanks,
sjewett

[julien1]

I think that you can configure the datasource to evict the dead connections and create new one.

You can even provide some ping method that the JCA layer can use to test the validity of the connection.

[mputz]

As Julien said, look at the ds configuration at AS level:

http://wiki.jboss.org/wiki/Wiki.jsp?page=WhatHappensToJBossIfIRestartTheDatabase

Regards, Martin