Re: [Q] Can't get simple JDBC connection to work: "no suitable driver"

Change

"jdbc:postgres:test",

To

"jdbc:postgresql:test"

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Amandeep Jawa
Sent: October 11, 2001 7:28 PM
To: pgsql-jdbc(at)postgresql(dot)org
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
----------------------------------
deep(at)worker-bee(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly