Connection Problem with JDBC

From: "Steven Murphy" <stevenmurphy(at)hotmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Connection Problem with JDBC
Date: 2002-02-11 15:08:35
Message-ID: LAW2-F132x2413pDhqX00021b41@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I'm trying to connect to a PostgreSQL database using JDBC but when I run the
program I get an error message saying "No suitable driver".

I'm using PostgreSQL 7.1.3 and java 1.3.1_01.

I have added the jdbc7.1-1.2.jar file to the CLASSPATH.

The command I am using to run the program is
java -Djdbc.drivers=org.postgresql.Driver ConnectDemo
jdbc:postgresql:javatest postgres ' '

The program I'm trying to use is :-

import java.sql.*;

public class ConnectDemo {

public static void main(String[] argv) {
// No need to register the driver, since the user
// used -Djdbc.drivers to set it.

// Check the arguments.
//
if (argv.length < 3) {
usage();
}
String url = argv[0];
String user = argv[1];
String pass = argv[2];

// Invoke getConnection() to create the
// connection object.
//
Connection conn;
try {
conn = DriverManager.getConnection(url, user, pass);
System.out.println("Connection successful.");
System.out.println("Connection as String: " + conn);
} catch (SQLException e) {
System.err.println( e.getMessage() );
System.exit(-1);
}
}

static void usage() {
System.err.println("Usage:");
System.err.print("java -Djdbc.drivers=DRIVERCLASS PROGRAM ");
System.err.println("URL USER PASS");
System.exit(-1);

}
}

I would be greatful for any help as I trying to do this for my final year
project at University and the deadline is fast approaching.

Cheers
Steven Murphy.

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sean Alphonse 2002-02-11 15:41:52 Connection Pooling.
Previous Message Dave Cramer 2002-02-11 14:56:27 Re: BigDecimal