topic Re: [resolved] PostgreSQL Connection issue with SSL in Talend Studio

[resolved] PostgreSQL Connection issue with SSL

Anonymous — Wed, 08 May 2013 03:22:34 GMT

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

Re: [resolved] PostgreSQL Connection issue with SSL

Anonymous — Fri, 10 May 2013 05:20:12 GMT

Anyone have a work around?

Re: [resolved] PostgreSQL Connection issue with SSL

Anonymous — Mon, 13 May 2013 23:09:49 GMT

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

Re: [resolved] PostgreSQL Connection issue with SSL

_AnonymousUser — Thu, 17 Mar 2016 22:18:20 GMT

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.

Re: [resolved] PostgreSQL Connection issue with SSL

rafaaaaa — Sat, 11 Apr 2020 10:47:25 GMT

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.