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
Message-ID: <01BDB974.267998D0@wynyard.alphanet.net.au> (raw)
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());
}
}
}
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: michaely@alphanet.net.au, yangsu@flash.cs.iastate.edu
Subject: RE: [INTERFACES] simple JDBC --> can't get started
In-Reply-To: <01BDB974.267998D0@wynyard.alphanet.net.au>
* 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