Re: SSL URL - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: SSL URL
Date
Msg-id Pine.BSO.4.56.0407221041480.250@leary.csoft.net
Whole thread Raw
In response to Re: SSL URL  (Phil Moors <pmoors@ncric.com>)
List pgsql-jdbc

On Thu, 22 Jul 2004, Phil Moors wrote:

> I changed false to true and recompiled. The resulting postgresql.jar
> file trips the following errors. I'm using a self signed certificate for
> an internal development box. I used the Sun sdk version 1.4.2_05 because
> ColdFusion's jre is 1.4.2.
>
> Connection verification failed for data source: dweb
> []java.sql.SQLException: An I/O error has occured while flushing the
> output - Exception: javax.net.ssl.SSLHandshakeException:
> sun.security.validator.ValidatorException: No trusted certificate found


You need to import the certificate into your jvm's trust store, so it can
verify that it is talking to the correct server.  See:

http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php

Kris Jurka

pgsql-jdbc by date:

Previous
From: Phil Moors
Date:
Subject: Re: SSL URL
Next
From: Oliver Jowett
Date:
Subject: Re: Why Is pgSQL's JDBC Slow?