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 ?