connectivity problem - Mailing list pgsql-jdbc

From adp adp
Subject connectivity problem
Date
Msg-id 20040130054659.42810.qmail@web8106.mail.in.yahoo.com
Whole thread Raw
Responses Re: connectivity problem
List pgsql-jdbc
Here is the classpath :
exportCLASSPATH=/root/j2sdk1.4.2/bin/test1.java:/root/j2sdk_nb/j2sdk1.4.2/jre/lib/ext/pg73jdbc3.jar:.


and here is the code:

import java.sql.*;
class test2{
  public static void main (String args[]) {


     try{


         Class.forName("org.postgresql.Driver");
        // DriverManager.registerDriver(new (Driver));




      String url="jdbc:postgresql:test";
      Connection con =
DriverManager.getConnection(url, "postgres", "");
      Statement stm= con.createStatement();


stm.setQueryTimeout(10);
ResultSet rs = stm.executeQuery("select col1 from
test1");


rs.next();


System.out.println(rs.getString(1));
}catch(ClassNotFoundException  e) {




 System.out.println("Exception");
 System.out.println(e.toString());
}
 catch(SQLException e) {




 System.out.println("Exception");
 System.out.println(e.toString());
}
}
}


and here is the error I receive :

Exception
The connection attempt failed because Exception:
java.net.UnknownHostException: localhost
Stack Trace:

java.net.UnknownHostException: localhost
        at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:153)
        at java.net.Socket.connect(Socket.java:452)
        at java.net.Socket.connect(Socket.java:402)
        at java.net.Socket.<init>(Socket.java:309)
        at java.net.Socket.<init>(Socket.java:124)
        at
org.postgresql.PG_Stream.<init>(PG_Stream.java:38)
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:160)
        at
org.postgresql.Driver.connect(Driver.java:122)
        at
java.sql.DriverManager.getConnection(DriverManager.java:512)
        at
java.sql.DriverManager.getConnection(DriverManager.java:171)
        at test2.main(test2.java:13)
End of Stack Trace



________________________________________________________________________
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: connectivity problem
Next
From: Kris Jurka
Date:
Subject: Re: connectivity problem