This may be a re-sent.
Just not sure I was on the mailing list or not.
Thanks a lot.
Paul
> Hi all,
>
> I am trying to setup a SSL connection between a Geronimo
> (geronimo-tomcat6-javaee5-2.1.4) application and PostgresSQL
> (postgresql-8.3.3-1) database. The database has the SSL turn on.
> However, I could not find the ConnectURL property to set. A sample
> connectURL string for PostgresSQL is like
> "jdbc:postgresql://MyServer:5432/MyDB?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory".
>
>
> Here is the code in the db-resource-adapter.xml file
>
> <connection-definition>
>
> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
>
> <connectiondefinition-instance>
> <name>MyDbPool</name>
> <config-property-setting
> name="DatabaseName">MyDB</config-property-setting>
> <config-property-setting
> name="ServerName">MyServer</config-property-setting>
> <connectionmanager>
> <local-transaction/>
> <single-pool>
> <max-size>10</max-size>
> <min-size>0</min-size>
> <match-one/>
> </single-pool>
> </connectionmanager>
> </connectiondefinition-instance>
> </connection-definition>
>
> Any suggestion?
>
> Thanks a lot.
>
> Paul
>
>
>
|