Re: Using the JDBC Driver in version 7.02

See below
--
Peter T Mount peter(at)retep(dot)org(dot)uk, peter(at)retepdigital(dot)com, me(at)petermount(dot)com
Homepage: http://www.retep.org.uk Contact details @ http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF generator: http://www.retep.org.uk/pdf/

----- Original Message -----
From: Marko Kreen <marko(at)l-t(dot)ee>
To: Peter Mount <peter(at)retep(dot)org(dot)uk>
Cc: Joseph Shraibman <jks(at)selectacast(dot)net>; Justin Jaynes
<justinjaynes(at)hotmail(dot)com>; <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, July 11, 2000 12:58 PM
Subject: Re: [GENERAL] Using the JDBC Driver in version 7.02

> On Tue, Jul 11, 2000 at 12:05:29AM +0100, Peter Mount wrote:
> >
> > ----- Original Message -----
> > From: Joseph Shraibman <jks(at)selectacast(dot)net>
> > To: Justin Jaynes <justinjaynes(at)hotmail(dot)com>
> > Cc: <pgsql-general(at)postgresql(dot)org>
> > Sent: Monday, July 10, 2000 9:57 PM
> > Subject: Re: [GENERAL] Using the JDBC Driver in version 7.02
> >
> > > Justin Jaynes wrote:
> > > >
> > > > the line:
> > > >
> > > > Class.forName("org.postgresql.Driver");
>
> Try:
>
> Class.forName("postgresql.Driver");

No, this won't work. As of 7.0 it's org.postgresql.Driver

> Ofcource, check that postgresql.jar is in classpath. If Java >= 1.2,
> you can instead drop it in $JAVA_HOME/jre/lib/ext.

This is the most likely reason it's not working.

>
> > > >
> > > > I get an error that the DriverManager cannot find a suitable driver.
> > > >
> > > > The code I use to connect goes as follows:
> > > >
> > > > Connection chamber = DriverManager.getConnection("localhost:5432");
> >
> > This isn't a valid JDBC URL. You'll need something like:
> >
> > jdbc:postgresql:database <= Use when on local host
> > jdbc:postgresql://server/database <= Use when on remote host
> >
>
>
> --
> marko
>