JDBC Connection

From: Eric Wright <eric(dot)wright(at)shaw(dot)ca>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC Connection
Date: 2004-07-11 20:26:31
Message-ID: 001c01c46785$5a943470$6601a8c0@numbertwo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I am having some trouble connecting to my postgres database.
I have started off with a simple test class to make and test a connection. When I run the simple tester I am getting the following output:

The connection failed.
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at app.dao.ConnectionTest.main(ConnectionTest.java:28)

From the following test class:

package app.dao;
import java.sql.*;

public class ConnectionTest {
public static void main(String[] args) {
String url = "jdbc:postgres://192.168.1.101/asset";
String user = "asset$admin";
String pwd = "password";
try {
Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection(url, user, pwd);
if(!con.isClosed()){
System.out.println("The connection succeeded");
con.close();
}
}catch(Exception e){
e.printStackTrace();
System.out.println("The connection failed.");
}
}
}

I have read the information at http://www.fankhausers.com/postgresql/jdbc/#nosuitabledriver
I am using Eclipse 3.0 and trying it run it in the debugger.
I am using postgresql 7.4, JDK 1.4, and pg74.214.jdbc3.jar

Any help that you can provide would be great.

Thanks Eric W

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Greg Markham 2004-07-11 20:54:27 Re: Timestamp Question
Previous Message Dave Cramer 2004-07-11 20:24:46 Re: patch for getXXX methods