Re: Connection Problem with JDBC

Hi all,

I have added the code to load the drivers using Class.forName in main, but
when I compile the code I get the following errors :-

ConnectDemo.java:27: unreported exception java.lang.ClassNotFoundException;
must be caught or declared to be thrown
            Class.forName("org.postgresql.Driver").newInstance();
                     ^
ConnectDemo.java:27: unreported exception java.lang.InstantiationException;
must be caught or declared to be thrown
            Class.forName("org.postgresql.Driver").newInstance();
                             ^
2 errors

Here is how the program looks now I have added the Class.forName bit :-

// Import the JDBC classes.
//
import java.sql.*;

public class ConnectDemo {

  public static void main(String[] argv) {

      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 {
            Driver driver = (Driver)
                Class.forName("org.postgresql.Driver").newInstance();
            DriverManager.registerDriver(driver);
          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);

  }

Do I need to import some other things to get this to work?
Sorry I'm a bit of a novice with all of this.

Cheers
Steve.

--------------------------------------------------------------------

From: "Nick Fankhauser" <nickf@ontko.com>
Reply-To: <nickf@ontko.com>
To: "Steven Murphy" <stevenmurphy@hotmail.com>, <pgsql-jdbc@postgresql.org>
Subject: Re: [JDBC] Connection Problem with JDBC
Date: Mon, 11 Feb 2002 15:44:04 -0500

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

I think if it was a classpath problem, you'd be getting a
"ClassNotFoundException" I believe the "No Suitable Driver" indicates that
among the drivers you have loaded, none matches the database url passed to
DriverManager.getConnection. ...But the command & url above look just fine &
I can't see any opportunity in your program for the url to get mangled.

Have you tried loading the drivers using Class.forName in main? I'm not sure
what it would tell us if it worked, but if it didn't work that way, I think
I'd download the driver again.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx