RE: [INTERFACES] JDBC connection problem while trying example.bas ic

Hang fire. There was a bug that caused the exceptions to return {1}
instead of the correct result. I fixed this one, but it was after 6.5
was out (will be in 6.5.1).

I'll post a new compiled driver onto my web site in about 2 hours (when
I get home).

Peter

-- 
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.



-----Original Message-----
From: Doug Thistlethwaite [mailto:doug@dupreeinc.com]
Sent: 13 July 1999 18:23
To: Peter Mount; 'Herouth Maoz'; Benoit.Foucher@francemel.com
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] JDBC connection problem while trying
example.basic


Thank you all for the quick reply.   After looking into greater detail,
this
problem probably should have been posted on the NOVICE mailing list...
I
caught that problem myself and still received that same error message as
before.  In reading the JDBC docs on the web site, I saw that the
version I
has was compiled for jdk1.1.7.  I downloaded a version for jdk1.2 and
now I
get a new error message.

:\jdk1.2\DSNBrowse>java example.basic
jdbc:postgresql://dragonl:5432/doug
doug password
PostgreSQL basic test v6.3 rev 1

Starting constructor for basic
continueing constructor for basic
Connecting to Database URL = jdbc:postgresql://dragonknoll:5432/doug
Exception caught.
Something unusual has occured to cause the driver to fail. Please report
this exception: {1}
Something unusual has occured to cause the driver to fail. Please report
this exception: {1}       at postgresql.Driver.connect(Driver.java:108)       at
java.sql.DriverManager.getConnection(CompiledCode)       at
java.sql.DriverManager.getConnection(DriverManager.java:137)      at example.basic.<init>(basic.java:34)       at
example.basic.main(basic.java:168)


I think the above error message shows that I have now moved further into
the
example program and it has shown another problem. The version of
postgrSQL
available on the stable debian linux distribution is version 6.3.  Am I
correct in assuming that I need v6.5 to work with the JDBC2 drivers?  If
this is the case, I have two options.  I can download a debian
distribution
file for postgress 6.5 for the latest version (non stable) of the debian
OS.  Alternately, I could compile it myself on the current version.  Do
any
of you have an opinion on which method would be the least painful?

Again, thank you for the information you have provided!

Doug Thistlethwaite


Peter Mount wrote:

> Yes, the driver defaults to 5432 if the port is absent, and localhost
if
> the host is absent.
>
> Peter
>
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough
Council.
>
> -----Original Message-----
> From: Herouth Maoz [mailto:herouth@oumail.openu.ac.il]
> Sent: 13 July 1999 09:15
> To: Doug Thistlethwaite; pgsql-interfaces@postgreSQL.org
> Subject: Re: [INTERFACES] JDBC connection problem while trying
> example.basic
>
> At 01:31 +0300 on 13/07/1999, Doug Thistlethwaite wrote:
>
> > Connecting to Database URL = jdbc.postgresql://dragon:5432/doug
>
> This should be "jdbc:postgresql" - a colon, not a period. And I think
> you
> can drop the port number since it is the default for Postgres.
>
> Herouth
>
> --
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
> http://telem.openu.ac.il/~herutma