[resolved] PostgreSQL Connection issue with SSL

[Anonymous]

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

[Anonymous]

Anyone have a work around?

[Anonymous · Accepted solution]

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

[_AnonymousUser]

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.

[rafaaaaa]

Hi All,

It worked with me when I added "?ssl=true" in the database section in Metadata Section, but When I tried to use the connection in tPostgreInput it gives me the below error:

ERROR: cross-database references are not implemented: "unitylive?ssl=true.public.Organization"
Position: 520

Any idea how can I solve this issue.