Re: Problems using JDBC Driver.

On Wed, 19 Apr 2000, Javier Benito wrote:

> Hi, i'm starting to use PostgreSQL. I'm using 6.5.4 version, and i'm
> having problems using JDBC driver. I'm sure that i'm doing something
> wrong but i don't know how. I'm trying to connect to a database in this
> way:
>
>                 String url = "jdbc:postgresql:BDPrueba";
>
>                 Connection con = DriverManager.getConnection(url,"","");
>
> where BDPrueba is the database which i want to connect. The driver is
> installed sucessfully, because the Class.forName(postgresql.Driver)
> sentence doesn't reach ClassNotFoundException. What can I do?.
>
> Thanks a lot.
> Javi.
>
> PD: Sorry if i haven't written this very well, but my english isn't very
> good.

Your English is fine, but you haven't actually described what it does
wrong. A few things though:

o Your URL looks wrong. I think it should be "jdbc:postgresql://BDPrueba".
o I think it fairly unlikely, although possible, that no username and
  password are required, but I guess you know what's correct for your
  instance.
o Make sure you start the postmaster with the -i switch so that it listens
  on tcp sockets, not just UDP. I think this is necessary for JDBC; it is
  certainly necessary for ODBC, and it took me four or five hours to work
  out that this was my problem.

Send us some more details of what actually goes wrong, like 'it throws
exception x' or 'this statement just sits there doing nothing,' rather
than, 'I'm having problems using JDBC driver.' Code snippet is good,
though - wish more people would do that!

Cheers
--
Tom Cook - Software Engineer

"Christ died for sin, the righteous for the unrighteous, to bring you to God."
    - 1 Peter 3:18

LISAcorp - www.lisa.com.au

--------------------------------------------------
38 Greenhill Rd.          Level 3, 228 Pitt Street
Wayville, SA, 5034        Sydney, NSW, 2000

Phone:   +61 8 8272 1555  Phone:   +61 2 9283 0877
Fax:     +61 8 8271 1199  Fax:     +61 2 9283 0866
--------------------------------------------------