Message-ID: <378A2DA7.FCC009E1@dupreeinc.com>
Date: Mon, 12 Jul 1999 11:02:15 -0700
From: Doug Thistlethwaite <doug@dupreeinc.com>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC connection problem while trying example.basic
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello,

I am very new to using postgresql.  I have a linux system at home
(Debian "slink" 2.0.36) which I have installed postgresql.  The
postgresql on the linux system seems to be running fine and I can use
psql to test sql statements.  I edited the init file and changed the
postmaster to accept tcp/ip connections.

My problem is when I try to talk to the database from a win95 system
using jdk1.2 and the sample program incloded with the JDBC driver.  When
I run the program example.basic I get the following:


Connecting to Database URL = jdbc.postgresql://dragon:5432/doug
Exception caught.
java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(Compiled Code)
        at java.sql.DriverManager.getConnection(DriverManager.java:137)
        at example.basic.<init>(basic.java:34)
        at example.basic.main(basic.java:168)


Does this mean there is a problem with the driver?  The postgresql.jar
file is in the classpath.  The linux system I am using is called
dragon and it should be using the default port of 5432.

Any thoughts on what is going wrong?

Thank you,

Doug