Topic: jdbc/ssl/non-validating fails
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
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
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.
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.
Log in by clicking the login link at the top of the screen
Go back to forum.
