Forum Discussion

dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago

PostgreSQL JDBC Connection Error

I’m getting an error at the end of a pipeline I have. The error says that it’s failing to run an insert statement but if I manually run the same insert statement it runs fine. I have a feeling that i...
rmartyn's avatar
rmartyn
New Contributor II
5 years ago
Copy Link

Hi Vineesha,

Thank you for responding. My SQL is quite a bit more complicated than your example. It includes several “With” statements and such. I’m just wondering if SnapLogic can’t handle that? It runs fine if I put it in SQL Developer.

  • JensDeveloper's avatar
    JensDeveloper
    Contributor II
    4 years ago
    Copy Link

    hi @pvsharish9 ,

    Is the user emp added to the DB where you trying to connect to? with the right password?
    If Yes,

    Which JDBC Jars are you using have you tried this?
    JDBC Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

    And maybe try also only with this Url properties:

    • selectMethod : cursor
      Or do you need those other properties?

    Advanced properties:

    Regards

    Jens