SSL connection between geronimo and postgresSQL

[Paul Wong]

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