Re: Connection Problem with JDBC - Mailing list pgsql-jdbc
From | Steven Murphy |
---|---|
Subject | Re: Connection Problem with JDBC |
Date | |
Msg-id | LAW2-F20wwjyqcsDTDr0001010f@hotmail.com Whole thread Raw |
In response to | Connection Problem with JDBC ("Steven Murphy" <stevenmurphy@hotmail.com>) |
List | pgsql-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
pgsql-jdbc by date: