Re: JDBC Driver

Hi Leonardo,

Either the PostgreSQL JAR file isn't in your classpath e.g.

export CLASSPATH=.:/java/libs/postgresql.jar

Or you're using the incorrect JDBC URL ('jdbc:postgresql:...'), it should be
something like

jdbc:postgresql://host:port/database

or,

jdbc:postgresql:database

The JDBC manager looks at the 'postgresql' part to determine if it has a
driver for it, which the below will ensure after you tell the JVM to load
the driver before attempting to get a connection e.g.

Class.forName("org.postgresql.Driver");

Regards,
Joe

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Leonardo Bitsch
> Sent: Thursday, 1 November 2001 8:00 PM
> To: PostgreSQL
> Subject: [JDBC] JDBC Driver
>
>
> Hi!
> I'm having problems with the Jdbc driver. My PostgreSQL
> version is 7.1 and
> the JDK is 1.2.2 (Java2). I have already download the driver but it
> doesn't run under Java2 and PostgreSQL 7.1 (java.sql.SQLException: No
> suitable driver). What can I do? Thanks a lot...
>
>
> Leonardo
>
> ____________________________________________________________
> ____________________________________________________________
> Leonardo Bitsch
> Graduagco em Engenharia de Controle e Automagco Industrial
> Laboratsrio de Controle e Microinformatica - LCMI
> Universidade Federal de Santa Catarina - UFSC
> Florianspolis - SC
> ____________________________________________________________
> ____________________________________________________________
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>

***********Confidentiality/Limited Liability Statement***************

Have the latest business news and in depth analysis delivered to your
desktop. Subscribe to "Insights", Deloitte's fortnightly email
business bulletin . . .

http://www.deloitte.com.au/preferences/preference.asp

This message contains privileged and confidential information intended
only for the use of the addressee named above. If you are not the
intended recipient of this message, you must not disseminate, copy or
take any action in reliance on it. If you have received this message
in error, please notify Deloitte Touche Tohmatsu immediately. Any
views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of
Deloitte.

The liability of Deloitte Touche Tohmatsu, is limited by, and to the
extent of, the Accountants' Scheme under the Professional Standards
Act 1994 (NSW).

The sender cannot guarantee that this email or any attachment to it is free of computer viruses or other conditions which may damage or
interfere with data, hardware or software with which it might be used. It is sent on the strict condition that the user carries out and relies
on its own procedures for ensuring that its use will not interfere with the recipients systems and the recipient assumes all risk of use and
absolves the sender of all responsibility for any consequence of its use.