problem with pg_hba.conf & JDBC (?)

Поиск
Список
Период
Сортировка
От Damien S
Тема problem with pg_hba.conf & JDBC (?)
Дата
Msg-id OE204Jf7zynrvDOv5y4000008c6@hotmail.com
обсуждение исходный текст
Ответы Re: problem with pg_hba.conf & JDBC (?)  (pin.o.za@mail.toyota-shokki.co.jp (王斌))
Список pgsql-interfaces
Hi there all.

I'm having a strange problem here:
I get the error message below when executing a SQL query through Tomcat
4.0.3 on a Linux server, with jdk1.4 & PostgreSQL 7.2.1. The user has rights
to insert, update, etc. & there is an entry for the IP address in the
pg_hba.conf file.
But strangely this exception only occurs through the JDBC driver when
deploying a web-app on Tomcat.

Executing statements through MS Access & pgAdmin works as well (from
Windows)

Technology used:
Tomcat 4.0.3
JDK 1.4
SuSE Linux 7.3
JDBC driver 7.0
PostgreSQL 7.2.1


This is the error message I get:
User=damien
Error code=0
SQL state=null
Message=Something unusual has occured to cause the driver to fail. Please
report this exception: java.sql.SQLException: FATAL 1: No pg_hba.conf entry
for host 212.222.11.111, user damien, database testerdb
- Any help would be very welcome.

Cheers, Damien


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PGLOG problem
Следующее
От: Cristóvão Dalla Costa
Дата:
Сообщение: DBD::Pg and binary data