Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
MahiwalVinit
Creator
Creator

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 jdbc0683p000009MAB6.pngostgresql://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?

 

 

Labels (4)
1 Reply
Anonymous
Not applicable

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?

0683p000009Ltgo.png

Regards

Shong