0 Replies Latest reply on Sep 30, 2005 8:36 AM by nuno oliveira

    Oracle9i connection down => 1rst entity EJB request hangs

    nuno oliveira Newbie

      Hello

      I am experiencing a strange behaviour with an entity bean and Oracle 9i.
      Whenever I disconnect the network cable leading from JBoss to the DB, the first client request just hangs. However, subsequent requests immediately complain with a SQLException about a network adapter being down.

      If I reduce the idle-timeout-seconds parameter in oracle-ds.xml to 1 sec, the first request complains immediately, as expected. Of course, this setup is not desirable so can anyone explain what's going on here.

      I also have the <valid-connection-checker-class-name> option enabled.

      Why is the first request different from the rest when the netwrok connection is down ?

      Any help would be highly appreciated.

      Nuno