topic Re: [resolved] Connection failure while retrieving the database schema in Talend Studio

[resolved] Connection failure while retrieving the database schema

Anonymous — Thu, 06 Apr 2017 13:51:30 GMT

Hello everyone,
I created a connection that I registered in my Metadata in my Repository, I tried the connection and it work well :

But when I try to retrieve the schema of the database connection I got the error :

It looks like the class org.postgresql.Driver hasn't been found.
I tried to install every Module related with Postgresql but nothing seems to work. I also download the .jar and tried to add those external jar via the Module panel but it also doesn't work.

I'm using Talend 6.1.1 and Java 8.121
Thank you for you help,
Regards

Re: [resolved] Connection failure while retrieving the database schema

Anonymous — Fri, 07 Apr 2017 03:26:03 GMT

Hi,
Have you tried to restart your studio after install every Module related with Postgresql to see if it works?
Best regards
Sabrina

Re: [resolved] Connection failure while retrieving the database schema

Anonymous — Fri, 07 Apr 2017 08:45:18 GMT

Yes, I also restarted my computer.
I tried to reinstall Java 8 JDK and JRE and to put again the JAVA_HOME environment variable but nothing changed.
Do you have any more ideas ?
Thank you for replying.
Regards

Re: [resolved] Connection failure while retrieving the database schema

Anonymous — Fri, 07 Apr 2017 09:53:12 GMT

Hi,
Would you mind making a testing on V 6.3 to see if this issue repro? What's postgresql DB version you are using?
Best regards
Sabrina

Re: [resolved] Connection failure while retrieving the database schema

Anonymous — Fri, 07 Apr 2017 12:52:18 GMT

Hi Sabrina,
I tried with version 6.2 and it seems to work.
For information I am using PostgreSQL V9.6.2.
I tag the subject as resolved thank you,
Regards