1 Reply Latest reply on Mar 19, 2007 11:25 AM by David Webb

    Stale Connection issue in Clustering

    Subramaniam Venkatachalam Newbie

      Hello,

      I am using JBoss-4.0.3-SP1. I am using oracle thin driver to connect to my oracle database. My oracle database is running on a cluster enviroment and therefore when there is a ip failover the oracle also switches nodes.

      When connecting to the oracle database i am using the Cluster IP address and there is a listerner which connects to the oracle on the node which is active.

      But during this when there is node switch then the tcp connections are broken.

      When i am trying get a database connection using my datasource i am always getting an error that the oracle is not responding but actually it has switched nodes.

      I would like to know whether the concept of stale connection is supported in JBoss-4.0.3-sp1 if so what should i being doing to use that functionality.

      Any help is very welcome.

      Thanks in advance
      Subramaniam V

        • 1. Re: Stale Connection issue in Clustering
          David Webb Newbie

          This i certainly not a JBoss clustering issue...but...the last time I used oracle in that mode, you had to use the Type 2 Driver. Hope this helps.

          Think of it this way. One of these has to be true.

          1)Type 4- The IP of the database never changes even after Oracle's failover occurs.
          2)Type 2 - The Oracle SID never changes (which it doesnt, but the Oracle CLI driver handles pointing the SID to the new IP address after Oracle fails).