2 Replies Latest reply on May 21, 2003 9:18 AM by Edwin Litterst

    Problem with disconnected oracle sessions

    Edwin Litterst Newbie

      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

        • 1. Re: Problem with disconnected oracle sessions
          David Jencks Master

          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
            Edwin Litterst Newbie

            > 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