capture db connection timeout error

[uthpalaw]

Hi,

I recently got an error from one of my java application that when the application tried to connect to the DB it doesn't write any exception if it is a timeout error. Can someone help me how to capture this error and write it down to a log file so that we can find the error for the first time by referring the log file.

Thanks,
Uthpala

[Tolls]

How are you getting connections?
What try/catch blocks do you have?
What driver are you using, because I'm pretty sure all the ones I've used will throw a SQLException on a timeout.

[uthpalaw]

package JavaApplication8;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author uthpalaw
 */
public class CheckDBConn {
    public static void main(String arg[]){
        try {

            Connection con = null;
            
            Class.forName("oracle.jdbc.OracleDriver"); // Load (and therefore register) the Oracle Driver
            con = DriverManager.getConnection("jdbc:oracle:thin:@ip:1521:SID", "userid", "password"); // Get a Connection to the database
            // @machineName:port:SID,   userid,  password
            
            
            System.out.println("DB Connected");

        } 
        catch (SQLException ex) {
            Logger.getLogger(CheckDBConn.class.getName()).log(Level.SEVERE, null, ex);
        }        catch (ClassNotFoundException ex) {
            Logger.getLogger(CheckDBConn.class.getName()).log(Level.SEVERE, null, ex);
        }    }

}

this is the whole code i used . There i have captured both SQL and ClassNotFoundException, but those both are unable to capture the timeout error.:confused:

[Tolls]

So you're getting "DB Connected" being printed out?

If not, add "catch (Exception ex) { ...log it.. }" at the end of the catches and see what's happening.

[uthpalaw]

ok.. will check..

[Tolls]

I'm guessig from that "Db Connected" is not being printed out.
In which case what's happening?
What exception do you get when you run this?
You must be seeing something?

[uthpalaw]

No,
i'm not getting any exception/ error messages until i stop the code from running.

[Tolls]

So that code up there is hanging?

That's not what you implied in your OP.

If it's hanging then it's not timing out...

[uthpalaw]

yes.. it's hanging until i abort it

[Tolls]

In which case the driver timeout needs to be set, though I thought it was defaulted.
Try setting the login timeout to 10 seconds (or less).

If it's taking that long to login I suspect something's up somewhere.

[uthpalaw]

yes.. it's working..
Thanks a lot..!!!

[Tolls]

Oh good.
You can get rid of the "catch (Exception ex)" bit I suggested earlier now, since you don't need it.