Re: JDBC prob. Continued

BTW, I have PGOPT="i"
for postgresql.init already.


Tony

----- Original Message -----
From: "tony" <tony@uickarate.com>
To: "pgsql-interfaces" <pgsql-interfaces@postgresql.org>
Sent: Thursday, November 16, 2000 11:23 AM
Subject: [INTERFACES] JDBC prob. Continued


> I'm using 7.0.
> Greg told me that SQLException is thrown by
> getConnection();
> so I've changed by getConnection to
> DriverManager.getConnection("jdbc:postgresql:database_name", "postgres",
> "password");
> and the error changed to something like this:
> SQLException: Connection refused.  Check that th ehostname and port is
> correct, and
> tha thte postmaster is runing with the -i flag, which enables TCP/IP
> networking.
>
>
> Any ideas??
>
> Thanks,
>
> Tony
>
> ----- Original Message -----
> From: "Peter Mount" <petermount@maidstone.gov.uk>
> To: "'tony'" <tony@uickarate.com>; "pgsql-interfaces"
> <pgsql-interfaces@postgresql.org>
> Sent: Thursday, November 16, 2000 11:14 AM
> Subject: RE: [INTERFACES] JDBC Problem
>
>
> > What version of the driver are you using?
> >
> > Versions 6.5.x and earlier used postgresql.Driver but 7.0 onwards uses
> > org.postgresql.Driver
> >
> > Peter
> >
> > --
> > Peter Mount
> > Enterprise Support Officer, Maidstone Borough Council
> > Email: petermount@maidstone.gov.uk
> > WWW: http://www.maidstone.gov.uk
> > All views expressed within this email are not the views of Maidstone
> Borough
> > Council
> >
> >
> > -----Original Message-----
> > From: tony [mailto:tony@uickarate.com]
> > Sent: Thursday, November 16, 2000 2:55 PM
> > To: pgsql-interfaces
> > Subject: [INTERFACES] JDBC Problem
> >
> >
> > I have a problem with loading the JDBC Driver.
> > So far, my java code does nothing but to load the driver, and
> > it gives SQLException with message "No suitable driver".
> > I made the postgresql.jar with
> > >make jdbc2
> > (because I am using jdk1.3)
> >
> > and I used
> > >jar tf postgresql.jar
> > to make sure that the driver was included.
> > (postgresql/Driver.class)
> >
> > My CLASSPATH is following:
> >
:/usr/local/lib/postgresql.jar:/usr/local/jdk1.3/bin/:/home/tony/classes/
> >
> > I am trying to load the driver by doing
> > >Class.forName("postgresql.Driver");
> >
> > This is under linux platform.  Please let me know what could be
> > wrong if you see anything wrong.
> >
> >
> > Thanks!
> >
>
>