Six Stars

Issue with connection with greenplum : No suitable driver found for jdbc:postgresql://null:null/null

 

I have created a job in Talend

Fetching data from SQL server  and writing it to Greenplum

flow is    MSSQLSERVER---- -> HADOOP ----->GREENPLUMConnection---> Greenplum-------> Greenplumcommit

when I run the job I get error in tGreenplumConnection component

PI2_FGBulkProduction_stg0.java:2661)
Exception in component tGreenplumConnection_1
java.sql.SQLException: No suitable driver found for jdbcSmiley Tongueostgresql://null:null/null
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at bigdata.vwkpi2_fgbulkproduction_stg0_1_1.vwKPI2_FGBulkProduction_stg0.tGreenplumConnection_1Process(vwKPI2_FGBulkProduction_stg0.java:1418)

 

I have checked I am able to see table name in Greenplum component - means connection is successful with Greenplum 

How should I go ahead to resolve this issue?

 

 

  • Data Integration
Tags (1)
1 REPLY
Community Manager

Re: Issue with connection with greenplum : No suitable driver found for jdbc:postgresql://null:null/null

Hello 

How do you see the table? Retrieve the schema under Metadata? It seems the driver file is missing or not installed correctly, open the Module view and see if the required driver file is installed already?

1.png

Regards

Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business