JDBC connection problem while trying example.basic - Mailing list pgsql-interfaces

From Doug Thistlethwaite
Subject JDBC connection problem while trying example.basic
Date
Msg-id 378A6CD4.ABBD1AD2@dupreeinc.com
Whole thread Raw
Responses Re: [INTERFACES] JDBC connection problem while trying example.basic  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Doug Thistlethwaite
Date:
Subject: JDBC connection problem while trying example.basic
Next
From: Emanuele
Date:
Subject: Re: [INTERFACES] jdbc redhat 6.0 NoClassDefFoundError