Thread: Glassfish ignoring "ssl" property in connection pool of PostgreSQL

Hi,

Glassfish ignoring "ssl" (and sslfactory) property in connection pool of PostgreSQL. I tried to establish a SSL connection string to PostgreSQL, but it is not taking. I tried with the normal JDBC URL in a standalone program and it works. Any ideas?

Here are my connection pool properties in Glassfish:

User: test
DatabaseName: test
Password: test123
ssl: true
sslfactory: org.postgresql.ssl.NonValidatingFactory
ServerName: localhost
PortNumber: 5432

Here is my standalone program which is working fine:

String url = "jdbc:postgresql://localhost:5432/test";
Properties props = new Properties();
props.setProperty("user","test");
props.setProperty("password","test123");
props.setProperty("ssl","true");
props.setProperty("sslfactory","org.postgresql.ssl.NonValidatingFactory");
Connection conn = DriverManager.getConnection(url, props);

stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select now()");
if (rs.next()) {
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();

Regards,
Satish.

On Sat, 27 Mar 2010, Nookala Satish Kumar wrote:

> Glassfish ignoring "ssl" (and sslfactory) property in connection pool of
> PostgreSQL. I tried to establish a SSL connection string to PostgreSQL, but
> it is not taking. I tried with the normal JDBC URL in a standalone program
> and it works. Any ideas?
>

This has been fixed in CVS.

Kris Jurka

Thanks a lot Krish.

Regards,
Satish.




--
|| Satyam Vada, Dharmam Chara ||
|| Matru Devo Bhava, Pitru Devo Bhava ||
|| Acharya Devo Bhava, Atithi Devo Bhava ||

Get Firefox. The browser you can trust.
http://www.spreadfirefox.com/?q=affiliates&id=43194&t=1

*Kris :-)




--
|| Satyam Vada, Dharmam Chara ||
|| Matru Devo Bhava, Pitru Devo Bhava ||
|| Acharya Devo Bhava, Atithi Devo Bhava ||

Get Firefox. The browser you can trust.
http://www.spreadfirefox.com/?q=affiliates&id=43194&t=1