On Fri, 2 Feb 2007, Robert Spies wrote:

> Hello, I am using the Jdbc3PoolingDataSource to set up a
> connection pool. I am using it in the following manner:
>
> Jdbc3PoolingDataSource source = new Jdbc3PoolingDataSource();
> source.setDataSourceName("DB data source");
> source.setServerName("localhost");
> source.setDatabaseName("test");
> source.setUser("testuser");
> source.setPassword("testpassword");
> source.setMaxConnections(10);
> ....
> Connection con = source.getConnection();
>
> The problem is that I want to use ssl when connection to the database,
> but I cannot figure out how to enable ssl with the
> Jdbc3PoolingDataSource. Can anyone help me? Thanks.
>

Unfortunately we need something like source.setSSL(true) or similar, but
it is not available. I seem to recall a patch to do this being posted to
the list, but it was not applied.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match