Re: SSL URL - Mailing list pgsql-jdbc

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

On Wed, 21 Jul 2004, Phil Moors wrote:

> pg 7.4.2-1
> pg74.214.jdbc3.jar
>
> I'd like to use this jdbc driver with ColdFusion. However, CF seems to
> have hard coded their jdbc driver configuration to only accept some
> standard parameters. I can't find a way to pass SSLMODE=require to the
> darn thing. The CF manual also says that the use of CONNECTSTRING is not
> enabled for the jdbc interface. Go figure.

Surely there must be a way of specifying parameters to it.  Could you
explain how you are currently establishing the connection?

> Where would I tweak the source to set the jdbc driver to default to SSL?

If this is the only way to do it, then in the 7.4 source tree see
org/postgresql/jdcb1/AbstractJdbc1Connection.java in the openConnection
method:

                if (info.getProperty("ssl") != null && Driver.sslEnabled())
                {
                        useSSL = true;
                }
                else
                {
                        useSSL = false;
                }


Kris Jurka

pgsql-jdbc by date:

Previous
From: Phil Moors
Date:
Subject: SSL URL
Next
From: Phil Moors
Date:
Subject: Re: SSL URL