Problem with disconnected oracle sessions

[eddie07]

Hi,

sometimes it happens that the oracle connection a datasource is using is disconnected.
If I am trying to use this datasource I get an error message about this disconnected session.
What do I have to do to reconnect?
Currently the only way I found is restarting jboss.

Eddie

[davidjencks]

use 3.2.1 or 3.0.7 or later and set up the OracleExceptionSorter which should close dead connections when you try to use them. These versions also have a flush method on one of the datasource related mbeans that lets you get rid of all current connections. For earlier versions, setting a short idle timeout and waiting twice that long with no activity should result in all connections getting discarded.

[eddie07]

> use 3.2.1 or 3.0.7 or later and set up the
> OracleExceptionSorter which should close dead
> connections when you try to use them.

I'll upgrade in the next few days, currently I am using 3.2.0.

> For earlier versions, setting a short
> idle timeout and waiting twice that long with no
> activity should result in all connections getting
> discarded.

This works fine - as work-around.

Thanks for your help,
Eddie