-
1. Re: Problem with disconnected oracle sessions
davidjencks May 20, 2003 7:39 AM (in response to 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. 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.
-
2. Re: Problem with disconnected oracle sessions
eddie07 May 21, 2003 9:18 AM (in response to 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