One Star

[resolved] PostgreSQL Connection issue with SSL

Hey,
So I have stumbled upon a weird issue when trying to create a SSL PostgreSQL connection.

If I paste the jdbc connection string directly into the "String of Connection" I am able to connect with my credentials.

When I attempt to "Finish" this component, it fails. Which makes sense because the schema field is not properly set.

The issue I am running into is when I set the schema field. The string doesn't propagate through to the "String of Connection" causing an error to be thrown.

Anyone know what I am doing wrong/have any suggestions as a work around?
Thanks,
Brian
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] PostgreSQL Connection issue with SSL

Resolved the issue:
?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
Needs to be added in the Database section.
3 REPLIES
One Star

Re: [resolved] PostgreSQL Connection issue with SSL

Anyone have a work around?
One Star

Re: [resolved] PostgreSQL Connection issue with SSL

Resolved the issue:
?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
Needs to be added in the Database section.
One Star

Re: [resolved] PostgreSQL Connection issue with SSL

Thanks , this worked for me. Was able to see in the code that the  jdbc URL string url_tPostgresqlConnection_1 got the 
?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
appended to it.