Forum Discussion

maheswara's avatar
maheswara
New Contributor II
2 years ago
Solved

Not able connect local postgresql database

Hi Team, 

 i am trying to connect PostgreSQL which is hosted on my local system. while connecting that I am getting below error which showing in images. anyone have any idea please help me. 

 

    

 

 

  • j_angelevski's avatar
    j_angelevski
    2 years ago

    Hi maheswara ,

    The issue might be the JDBC Driver. From the screenshot you shared, I am not sure if you have configured the JDBC JARs Driver, but if you didn't, you need to download it and upload it in SnapLogic and then under the JDBC JARs configuration, upload/select the .jar file of the driver. You can download the latest driver or any version you need.

    You can download it from the official docs: https://jdbc.postgresql.org/download/

     

5 Replies

  • j_angelevski's avatar
    j_angelevski
    Contributor III
    2 years ago

    Hi maheswara ,

    The issue might be the JDBC Driver. From the screenshot you shared, I am not sure if you have configured the JDBC JARs Driver, but if you didn't, you need to download it and upload it in SnapLogic and then under the JDBC JARs configuration, upload/select the .jar file of the driver. You can download the latest driver or any version you need.

    You can download it from the official docs: https://jdbc.postgresql.org/download/

     

    • maheswara's avatar
      maheswara
      New Contributor II
      2 years ago

      Hi j_angelevski,

      The above solution what you have given is working fine, but some time i am getting fatal error. Not able to connect that PostgreSQL.

      • j_angelevski's avatar
        j_angelevski
        Contributor III
        2 years ago

        Hi maheswara ,

        Could you please provide more details about the error? It's a bit vague and could refer to various issues. Would you mind sharing the specific error message for clarification?