Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 02D10476196 for ; Tue, 22 Oct 2002 09:13:01 -0400 (EDT) Received: from hotmail.com (oe20.law10.hotmail.com [64.4.14.124]) by postgresql.org (Postfix) with ESMTP id 521E7476195 for ; Tue, 22 Oct 2002 09:13:00 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 22 Oct 2002 06:12:56 -0700 X-Originating-IP: [212.222.97.101] From: "Damien S" To: Subject: problem with pg_hba.conf & JDBC (?) Date: Tue, 22 Oct 2002 15:12:53 +0200 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 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: X-OriginalArrivalTime: 22 Oct 2002 13:12:56.0245 (UTC) FILETIME=[BC7DDE50:01C279CC] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/68 X-Sequence-Number: 3230 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