Thread: RE: [INTERFACES] simple JDBC --> can't get started

RE: [INTERFACES] simple JDBC --> can't get started

From
Mikael Hammarin
Date:
I'd guess you probably haven't started "postmaster" with -i,
which means it runs only through unix local domain sockets.

Check "man postmaster" for more info.

Cheers
//Mike

> -----Original Message-----
> From: Yang Su [mailto:yangsu@inkle.cs.iastate.edu]
> Sent: Monday, July 27, 1998 7:16 AM
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] simple JDBC --> can't get started
>
>
>
> I have a simple test.java which tries to connect to a database I have
> created, my user name is "yangsu" which is created by
> "createuser yangsu"
> My db_hba.conf has only the following lines:
>
> local        all                                         trust
> host         all         127.0.0.1     255.255.255.255   trust
> host         all         129.186.68.160  255.255.255.255 trust
>
> My machine name is inkle.cs.iastate.edu(ip 129.186.68.160),
> my execution
> of "java test" yields:
>
> Class.forName OK!
> java.sql.SQLException: Connection failed:
> java.net.ConnectException: Connection refused
>
> What is the error?(what causes the error?) Thanks for any suggestions.
>
> yang
> http://www.cs.iastate.edu/~yangsu/
>
>
> Following is the test.java:
>
> import java.io.*;
> import java.net.*;
> import java.sql.*;
>
> public class test{
>
>    public static void main(String args[]){
>         try{
>                 Class.forName("postgresql.Driver");
>                 System.out.println("Class.forName OK!");
>
>                 String
> url="jdbc:postgresql://inkle.cs.iastate.edu/test";
>                 String usr="yangsu";
>                 String pwd="";
>
>                 Connection db =
> DriverManager.getConnection(url, usr, pwd);
>                 if(db != null){
>                         System.out.println("Connected to db");
>                 }else{
>                         System.out.println("Can't connect to db");
>                 }
>
>                 Statement st = db.createStatement();
>                 ResultSet rs = st.executeQuery("select * from
> classmate");
>
>                 while(rs.next()){
>                         System.out.println(rs.getString("name"));
>                         System.out.println(rs.getBoolean("sex"));
>                         System.out.println(rs.getInt("age"));
>                 }
>         }catch(Exception e){
>                 System.out.println(e.toString());
>         }
>    }
>
> }
>
>
>
>