Thread: 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 Gradua��o em Engenharia de Controle e Automa��o Industrial Laborat�rio de Controle e Microinform�tica - LCMI Universidade Federal de Santa Catarina - UFSC Florian�polis - SC ____________________________________________________________ ____________________________________________________________
Leonardo, Where did you download the driver from? What errors are you getting? Dave -----Original Message----- From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Leonardo Bitsch Sent: November 1, 2001 4:00 AM 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 Graduação em Engenharia de Controle e Automação Industrial Laboratório de Controle e Microinformática - LCMI Universidade Federal de Santa Catarina - UFSC Florianópolis - SC ____________________________________________________________ ____________________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Leonardo- I have recently created a FAQ for folks just starting out- It has a section for that message: http://www.fankhausers.com/postgresql/jdbc/#nosuitabledriver -Nick -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Leonardo Bitsch > Sent: Thursday, November 01, 2001 4:00 AM > 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 > Graduação em Engenharia de Controle e Automação Industrial > Laboratório de Controle e Microinformática - LCMI > Universidade Federal de Santa Catarina - UFSC > Florianópolis - SC > ____________________________________________________________ > ____________________________________________________________ > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
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@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.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@postgresql.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
whichmay damage or
interfere with data, hardware or software with which it might be used. It is sent on the strict condition that the user
carriesout and relies
on its own procedures for ensuring that its use will not interfere with the recipients systems and the recipient
assumesall risk of use and
absolves the sender of all responsibility for any consequence of its use.
G'day Gary, Perhaps it could be a Netscape issue when downloading JAR's, as NS can corrupt JAR's because it thinks they're not binary. Either try fetch, or IE, or similar to download the file. There's also a few drivers at http://jdbc.fastcrypt.com if you need to try a different site. Failing all of that, holler me back and I'll send you the driver as an attachment. Cheers and good luck, Joe > Hello there. > I am new to PostgreSQL and having a big problem with the JDBC driver. > I have downloaded it from http://jdbc.postgresql.org/download.html > I tried both jdbc7.1-1.2.jar and jdbc7.0-1.2.jar and they are > both unusable. > Neither jar nor Winzip can't open them. Nor could I open them > with java -jar > command. > I tried to download them several times from various machines > with the same > result. > Java gives me following exception: > Exception in thread "main" java.util.zip.ZipException: > invalid CEN header > (bad signature) > at java.util.zip.ZipFile.open(Native Method) > at java.util.zip.ZipFile.<init>(Unknown Source) > at java.util.jar.JarFile.<init>(Unknown Source) > at java.util.jar.JarFile.<init>(Unknown Source) > Winzip gives an error: Start of central directory not found. Zip file > corrupt. > > I found this discussion on the mailing list archive and > desided to drop you > a line. > Can you explain what is wrong and where I can get a working > driver. I am > building just a PC client > so I don't want complete distribution, neither do I have time > to build it > from source. > > Thank you very much and please respond ASAP. > > ***********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.