Re: problem with jdbc connection to postgesql

On 03/02/2004 15:45 Phil Campaigne wrote:
> Hi All,
> I am seting up my web app with a tomcat/postgresql hosting service. From
> my psql client I type psql and then I am asked for my password. This
> logs me into my hosted database just fine.
>
> However, I can't log on from my webapp to the database thru jdbc like I
> could when my webapp/Tomcat/postgresql were on my local machine. The
> jdbc class only has a method with 3 parameters, url, user, password
> parameters. The hosting server is giving me the following error message:
> >Stack Trace:
>
> >java.sql.SQLException: FATAL 1: Password authentication failed
> for >user "xxxxxx"
>
> >So, it looks like it is trying to connect using username xxxxxx,
> >not password yyyyyy.
>
> I'm using the DriverManager.getConnection(url, user, password) method in
> my connection class.
>
> jdbc:postgresql://database.domain.org/databasename
>
> username: xxxxxx
> password: yyyyyy
>
> It seems to be confused by the presence of the extra parameter 'user'. I
> believe that the postgresql database wants just the password. How do I
> give it just the url and password. There is no getConnection method on
> the DriverManager classd with just url and password?
>
> Has anyone else experienced this problem? Any ideas?

Well obviously you can't have a password without a user which why there is
no such method signature. Make sure that:

a) the postmaster is listening on tcp/ip port 5432 (it looks like it else
you would probably get a connect failure)

b) your user is allowed to connect to the database using tcp/ip (check
pg_hba.conf)

c) you are using the correct password for the user.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+