Can't connect to postgresql using SSL

[glassfishrobot]

I'm trying to create a Postgresql connection pool (javax.sql.Datasource) using org.postgresql.ds.PGSimpleDataSource driver from posgresql, but I can't seam to get it to work.

I have set the following properties in the web admin GUI:

DatabaseName: mydbname Password:mypasswd User:myusername ServerName: myhost.mydomain ssl: true sslfactory:org.postgresql.ssl.NonValidatingFactory

I can connect to the database (using SSL) from the Linux command line using: psql -h myhost.mydomain -U myusername -d mydbname

I can also connect to it from a java program using: Class.forName("org.postgresql.Driver); Connection con=DriverManager.getConnection("jdbc:postgresql://myhost.domain/mydbname?org.postgresql.ssl.NonValidatingFactory&ssl=true","myusername","mypasswd");

If I do ping from the webadmin page, I get an error message that tells me pg_hba.conf. doesn't have any lines for non SSL connections(Which is also is the case for my setup)

The postgresql server version is 8.1.3 and the driver used is postgresql-8.1-407.jdbc3.jar. The driver jar file is placed in the /opt/jkd1.6.0/jre/lib/ext/

The java version is: java version "1.6.0-beta2" Java(TM) SE Runtime Environment (build 1.6.0-beta2-b85) Java HotSpot(TM) Client VM (build 1.6.0-beta2-b85, mixed mode)

The same problem occurs if I try to create an javax.sql.XADataSource connection pool using org.postgresql.xa.PGXADataSource.

Non SSL connections seam to work.

Environment

Operating System: All Platform: Linux

Affected Versions

[9.1pe]

[glassfishrobot]

• Issue Imported From: https://github.com/javaee/glassfish/issues/706
• Original Issue Raised By:@glassfishrobot
• Original Issue Assigned To: @yaminikb
• Original Issue Closed By:@glassfishrobot

[glassfishrobot]

@glassfishrobot Commented unoengborg said: After further investigation, it seas that this was a problem with the postgresql driver. I suggest closing this issue as as not a bug.

[glassfishrobot]

@glassfishrobot Commented mvatkina said: per user comments

[glassfishrobot]

@glassfishrobot Commented Was assigned to LanceAndersen

[glassfishrobot]

@glassfishrobot Commented This issue was imported from java.net JIRA GLASSFISH-706

[glassfishrobot]

@glassfishrobot Commented Reported by unoengborg

[glassfishrobot]

@glassfishrobot Commented Marked as incomplete on Tuesday, June 6th 2006, 5:13:55 am