Database connectivity taking too much time

[Tapas Chand]

I am using jdk 1.5, oracle 9i, IBM AIX 5.3, classes12.jar
my code is like this

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String s = "jdbc:oracle:thin" + ":@" + ip + ":" + port + ":" + sid;
if(connection==null){
	connection = DriverManager.getConnection(s, USERID, PWD);
	System.out.println("connection  : "+connection);
}

connection is getting established after almost 5 mins.
but when i am connection through sqlplus from commandline, connection is getting established instantly.

please help...

[Farakh khan]

Hi,

Try this

if ((connection==null)||connection.isClosed()){

[Jeanne Boyarsky]

Are you closing the connection in a finally block when done with it? Maybe there is a resource leak? Also, why are you checking if connection is null? If you are trying to reuse the connection try using an open source connection pooling library to do so more effectively. (And a datasource rather than driver manager)