Adding additional properties to postgres-ds.xml

[beyarecords]

Hi,
I have specified my postgres-ds.xml file as so:

<datasources>
 <local-tx-datasource>
 <connection-url>jdbc:postgresql://localhost:5432/test?ssl=true</connection-url>
 <driver-class>org.postgresql.Driver</driver-class>
 <user-name>*</user-name>
 <password>*</password>
 <max-pool-size>10</max-pool-size>

 <metadata>
 <type-mapping>PostgreSQL 7.2</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

and I need to add the additional properties, which in java would say:

String url = "jdbc:postgresql://localhost/test";
Properties props = new Properties();
props.setProperty("user","*");
props.setProperty("password","*");
props.setProperty("ssl","true");
props.setProperty("javax.net.ssl.trustStore", cacert);
props.setProperty("javax.net.ssl.trustStorePassword","changeit");

Connection conn = DriverManager.getConnection(url, props);

So, in my xml file I need to say something like:

 <javax.net.ssl.trustStore>/library/java/home/lib/security/cacert</javax.net.ssl.trustStore>
 <javax.net.ssl.trustStorePassword>changeit</javax.net.ssl.trustStorePassword>

Can this be done?

many thanks

Andrew

[beyarecords]

Hi,
was just reading some information about struts, where you can set a property on a datasource like so:

 <!-- configuration for GenericDataSource wrapper -->
 <data-source>
 <set-property
 property="driverClass"
 value="org.postgresql.Driver"/>
 <set-property
 property="password"
 value="mypassword"/>
 <set-property
 property="url"
 value="jdbc:postgresql://localhost/mydatabase"/>
 <set-property
 property="user"
 value="myusername"/>
 </data-source>
 </data-sources>

What I want to be able to say in my postgres-ds.xml file is :

 <set-property
 property="javax.net.ssl.trustStore"
 value="/library/java/home/lib/security/cacert"/>
 <set-property
 property="javax.net.ssl.trustStorePassword"
 value="changeit"/>

How do I go about acheiving this?

regards

Andrew

[starksm64]

http://www.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources