Connection Problem with JDBC

Поиск
Список
Период
Сортировка
От Steven Murphy
Тема Connection Problem with JDBC
Дата
Msg-id LAW2-F132x2413pDhqX00021b41@hotmail.com
обсуждение исходный текст
Ответы Re: Connection Problem with JDBC  ("Dave Cramer" <Dave@micro-automation.net>)
Список 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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Dave Cramer"
Дата:
Сообщение: Re: BigDecimal
Следующее
От: "Sean Alphonse"
Дата:
Сообщение: Connection Pooling.