Message-ID: <01BDB974.267998D0@wynyard.alphanet.net.au>
From: Michael Yeung <michaely@alphanet.net.au>
To: "'yangsu@flash.cs.iastate.edu'" <yangsu@flash.cs.iastate.edu>
Cc: "'Interfaces of Postgres'" <pgsql-interfaces@postgreSQL.org>
Subject: RE: [INTERFACES] simple JDBC --> can't get started
Date: Mon, 27 Jul 1998 15:35:13 +1000
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

HI,

What have u entered for your password entry.

For most JDBC driver, you have to enter the password for the user that connected to the dB Server.

You haven't enter the password, have you ?

cheers,
Michael
-----Original Message-----
From:	Yang Su [SMTP:yangsu@inkle.cs.iastate.edu]
Sent:	Monday, July 27, 1998 3:16 PM
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());
        }
   }

}