Received: from ns.crystaldonuts.com ([38.194.228.45]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAGHXWs82660 for ; Thu, 16 Nov 2000 12:33:33 -0500 (EST) (envelope-from tony@uickarate.com) Received: (qmail 21639 invoked from network); 16 Nov 2000 17:32:03 -0000 Received: from unknown (HELO tonydesktop) (64.148.169.10) by 38.194.228.45 with SMTP; 16 Nov 2000 17:32:03 -0000 Message-ID: <008a01c04fea$b6f699d0$32fea8c0@tonydesktop> From: "tony" To: "pgsql-interfaces" References: <1B3D5E532D18D311861A00600865478CF1B55A@exchange1.nt.maidstone.gov.uk> <007e01c04fe9$813ac2e0$32fea8c0@tonydesktop> Subject: Re: JDBC prob. Continued Date: Thu, 16 Nov 2000 11:31:46 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200011/184 X-Sequence-Number: 220 BTW, I have PGOPT="i" for postgresql.init already. Tony ----- Original Message ----- From: "tony" To: "pgsql-interfaces" 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" > To: "'tony'" ; "pgsql-interfaces" > > 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! > > > >