Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ssl support in XA Datasource

138 views
Skip to first unread message

kumar, Anand (Anand)

unread,
Aug 25, 2008, 1:38:17 AM8/25/08
to

Hi,

I would like to know if PostgreSQL 8.2 supports SSL via XA datasource. I am using JBoss EAP 4.3 for making jdbc connections. Below is my datasource:

 <xa-datasource>
      <jndi-name>Res1</jndi-name>
      <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
      <xa-datasource-property name="ServerName">148.147.162.57</xa-datasource-property>
      <xa-datasource-property name="PortNumber">5432</xa-datasource-property>
      <xa-datasource-property name="DatabaseName">postgres</xa-datasource-property>
      <xa-datasource-property name="Ssl">true</xa-datasource-property>
      <xa-datasource-property name="User">postgres</xa-datasource-property>
      <xa-datasource-property name="Password">postgres</xa-datasource-property>
      <track-connection-by-tx/>
  </xa-datasource>

Thanks and Regards,

Anand.

Albe Laurenz

unread,
Aug 25, 2008, 3:26:40 AM8/25/08
to
> I would like to know if PostgreSQL 8.2 supports SSL via XA datasource.
> I am using JBoss EAP 4.3 for making jdbc connections.

The 8.2 driver does not have SSL support in the datasource, but if you
use the 8.3 driver, you can set "ssl" and "sslFactory".

Yours,
Laurenz Albe

--
Sent via pgsql-jdbc mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

kumar, Anand (Anand)

unread,
Aug 26, 2008, 6:45:12 AM8/26/08
to
Laurenz, Thanks a lot!! .... I tried with postgresql-8.3-603.jdbc3.jar
and SSl worked.
0 new messages