Topic: jdbc/ssl/non-validating fails

Go back to forum.

Topic by
rwcjr

2009-10-21
22:47

jdbc/ssl/non-validating fails

trying to connect to postgresql on ec2 via ssl. Eliminated certificate validation as I (for some reason) am unable to get the cert to be accessed correctly on local machine. I've done this in other JDBC (java) environs and it has worked but I keep getting exception. Here's the connection string;
jdbc:postgresql://url/mydb?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
and now the error thrown
org.xml.sax.SAXParseException: The reference to entity "sslfactory" must end with the ';' delimiter.

any help much appreciated. - thanks
Reply by
kasper

2009-10-21
23:32
Hi rwcjr,

I don't know for sure about your specific issue, but I'm thinking that this is not really a DataCleaner issue as much as it's a Postgresql JDBC driver issue. In a simple Java program, can you create the connection using that connection string? I would recommend you refer to the Postgresql forums/documentation for help with creating the connection and then apply whatever tricks you might find with regard to the connection string, driver or whatever, to DataCleaner.

You need to be logged in to participate

In order to post your own comments on this topic, you need to be logged in.

Username:

Log in by clicking the login link at the top of the screen

 

Go back to forum.

Username:

Password:

Requested username:

Password:

Real name:

Email address:

Title:

Company:

Country: