geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Wong <mr.pcw...@gmail.com>
Subject SSL connection between geronimo and postgresSQL
Date Wed, 30 Sep 2009 16:56:36 GMT
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



Mime
View raw message