Обсуждение: ssl support in XA Datasource

Поиск
Список
Период
Сортировка

ssl support in XA Datasource

От
"kumar, Anand (Anand)"
Дата:

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.

Re: ssl support in XA Datasource

От
"Albe Laurenz"
Дата:
> 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

Re: ssl support in XA Datasource

От
"kumar, Anand (Anand)"
Дата:
Laurenz, Thanks a lot!! .... I tried with postgresql-8.3-603.jdbc3.jar
and SSl worked.

-----Original Message-----
From: Albe Laurenz [mailto:laurenz.albe@wien.gv.at]
Sent: Monday, August 25, 2008 12:57 PM
To: kumar, Anand (Anand); pgsql-jdbc@postgresql.org
Subject: RE: [JDBC] ssl support in XA Datasource

> 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