Hello,
I wrote a simple java program, where a Connection is created at the
beginning, and than is used to make queries to an Oracle DB (let me say
"a very very primitive connection pool").

When I run this program on a PC with only one ethernet card and
configured with only one LAN, if I disconnect LAN cable while program
is waiting "Press any key (q to exit)... " an than press a key, an
java.sql.SQLException (Connection reset by peer: socket write error) is
thrown.

But when I run this program on a PC with two ethernet card and
configured with two LAN (all active), if I disconnect LAN cable
(Connection created with this LAN) while program is waiting "Press any
key (q to exit)... " an than press a key, nothing happens, and program
wait forever!

I tried Oracle thin driver classes12.jar and ojdbc14.jar, but
conn.pingDatabase(10) returns everytime 0.

How can I test a Connection before use it?

Below a part of my code.

Thanks,
Paolo

try {
           conn = DriverManager.getConnection(url, user, pwd);
           BufferedReader stdin = new BufferedReader(new
InputStreamReader(System.in));
           System.out.print("\nPress any key (q to exit)... ");
           while(!stdin.readLine().equalsIgnoreCase("q")){
               st = conn.createStatement();
               rs = st.executeQuery("select * from tab");
              while (rs.next()) {
               System.out.println(rs.getString("TNAME") + " - " +
rs.getString("TABTYPE"));
              }
             rs.close();
             st.close();
             System.out.print("\nPress any key (q to exit)... ");
           }
       }