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 17:25:06 GMT
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
>
>
>


Mime
View raw message