Re: [Q] Can't get simple JDBC connection to work: "no suitable driver" - Mailing list pgsql-jdbc

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
> ----------------------------------
> deep@worker-bee.com
> 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 majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
Liam Stewart :: Red Hat Canada, Ltd. :: liams@redhat.com