Thread: RE: JDBC prob. Continued
Check that postgres is running, and with -i set. From your url, I'm assuming that the application is running on the same box as postgres? 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 4:23 PM To: pgsql-interfaces 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! >
It doesn't hurt, but localhost:5432 is the default when those two parameters are missing. 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: Christopher Farley [mailto:chris@northernbrewer.com] Sent: Thursday, November 16, 2000 9:09 PM To: tony Cc: pgsql-interfaces Subject: Re: [INTERFACES] JDBC prob. Continued > so I've changed by getConnection to > DriverManager.getConnection("jdbc:postgresql:database_name", "postgres", > "password"); The above URL is not correct, it should be jdbc:postgresql://localhost:5432/database_name Note the two slashes after jdbc:postgresql: I am not sure if localhost:5432 is required, but it won't hurt. ---- Christopher Farley Northern Brewer / 1150 Grand Avenue / St. Paul, MN 55105 www.northernbrewer.com
If the host is localhost, then you don't need to supply the hostname in the url. Same goes for the port, if missing it defaults to 5432. As for hostname/ip address, you can use either - it's only when dealing with applets when this has to be precise. 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 4:42 PM To: Michael Stephenson Cc: pgsql-interfaces Subject: Re: [INTERFACES] JDBC prob. Continued The host could be just localhost if this is running only on localhost, right? Or do I have to specify an IP? Thanks, Tony ----- Original Message ----- From: "Michael Stephenson" <mstephenson@tirin.openworld.co.uk> To: "tony" <tony@uickarate.com> Cc: "pgsql-interfaces" <pgsql-interfaces@postgresql.org> Sent: Thursday, November 16, 2000 12:37 PM Subject: Re: [INTERFACES] JDBC prob. Continued > On Thu, 16 Nov 2000, tony wrote: > > > 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?? > > >From reading the error message I'd suggest, either you have the hostname > and port incorrect, correct use is: > > DriverManager.getConnection( > "jdbc:postgresql://[host]:[port]/[db_name]", > "[username]", "[password]"); > > Or you're not running postmaster with the -i flag, I use: > > postmaster -i -p [port] -D [data directory] > > If it's neither of those, then I'm sorry for being patronising. > > Hope this helps, > > Michael Stephenson > >