Re: SSL URL

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