Change "jdbc:postgres:test",
To "jdbc:postgresql:test" Dave -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Amandeep Jawa Sent: October 11, 2001 7:28 PM To: [EMAIL PROTECTED] Subject: [JDBC] [Q] Can't get simple JDBC connection to work: "no suitable driver" (PLEASE email any replies to me directy as well as posting) Hey folks - I hope someone can help. I'm trying to get a VERY simple JDBC connection working with the JDBC drivers but I am consistently getting a "no suitable driver" error. I am trying a very very simple test program to access my little PostgreSQL database & I am using the jdbc driver: jdbc7.1-1.2.jar (binary downloaded from www.postgresql.org). The error I'm getting is: Exception in thread "main" java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:537) at java.sql.DriverManager.getConnection(DriverManager.java:177) at testpost.main(testpost.java:14) The command I'm running is: java -cp /usr/share/pgsql/jdbc7.1-1.2.jar testpost The code is: // testpost.java import java.sql.*; public class testpost { public static void main(String argv[]) throws Exception { System.out.println("Beginning Postgres Test"); Class.forName("org.postgresql.Driver"); System.out.println("Loaded Driver."); Connection conn = DriverManager.getConnection( "jdbc:postgres:test", "postgres", "notreallymypassword" ); System.out.println("Got connection."); /* COMMENTED OUT UNTIL I KNOW THE REST WORKS Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery("SELECT now();"); System.out.println("Ran now query..\nResults:\n"); while (rset.next()) { System.out.println(rset.getString(1)); } rset.close(); stmt.close(); */ conn.close(); System.out.println("Closed connection & Ended Test"); } } The ouput I get is: Beginning Postgres Test Loaded Driver. Exception in thread "main" java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:537) at java.sql.DriverManager.getConnection(DriverManager.java:177) at testpost.main(testpost.java:14) I'm using postgres 7.1.3 installed from RPMs (from Postgres) on Red Hat Linux 7.1 with Sun's jdk 1.3.1 also installed from RPMs (from Sun). I have a "postgres" user on my machine. I have made the database "test". Not that I think these things matter because it doesn't seem to be getting that far. I am starting the postgres server from the root user with the following command: /etc/rc.d/init.d/postgresql start & it seems to be starting fine. I have also turned on tcp-ip connections in the conf file. Couple of other facts: - One thing I notice is that the documentation all refers to a "postgressql.jar" which I can't find. I can find the "jdbc7.1-1.2.jar" which is what I'm using. - One other thing I have tried is to rebuild the drivers from scratch - this does give me a postgresql.jar - but the error is the same. - I have also noticed that the jar files are not always the same size: jdbc7.1-1.2.jar from postgresql-jdbc-7.1.3-1PGDG.i386.rpm : 88169 bytes jdbc7.1-1.2.jar from jdbc.postgresql.org : 93011 bytes But the error is the same :-) Any help would be greatly appreciated - and please email replies to me directly as well as the list. THANKS in advance. 'deep ---------------------------------- Amandeep Jawa Worker Bee Software ---------------------------------- [EMAIL PROTECTED] 225A Dolores St. San Francisco, CA 94103-2202 Home: 415 255 6257 (ALL MALP) professional: http://www.worker-bee.com personal: http://www.deeptrouble.com political: http://www.sflcv.org ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
