From: Yang Su <yangsu@inkle.cs.iastate.edu>
To: pgsql-interfaces@postgresql.org
Subject: simple JDBC --> can't get started
Date: Mon, 27 Jul 1998 00:15:33 -0500
Message-ID: <19980727001533.A4674@inkle.cs.iastate.edu> (raw)
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());
}
}
}
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: yangsu@inkle.cs.iastate.edu
Subject: Re: simple JDBC --> can't get started
In-Reply-To: <19980727001533.A4674@inkle.cs.iastate.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox