Try changing the connection url to the following:
"jdbc:postgresql:test" This should do the trick. postgres is not a valid subprotocol which explains the error message that you're getting. postgresql is the only subprotocol recognized by the PostgreSQL JDBC driver. Liam On Thu, Oct 11, 2001 at 04:28:06PM -0700, Amandeep Jawa wrote: > (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 -- Liam Stewart :: Red Hat Canada, Ltd. :: [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html