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
