Forum Discussion

anirudh_p's avatar
anirudh_p
New Contributor
3 years ago

Failure: Null pointer exception on JDBC

While creating a pipeline to connect to DB2 database using JDBC snap, I am running into the following error.

Failure: Null pointer exception occurred at: com.snaplogic.snap.api.sql.DatabaseUtils.checkConnectionValidityForDB2(DatabaseUtils.java:1392), Reason: Null pointer exception occurred at: com.snaplogic.snap.api.sql.DatabaseUtils.checkConnectionValidityForDB2(DatabaseUtils.java:1392), Resolution: Please file a defect against the snap

This is happening with two snaps that I tried to read data from DB2. Generic JDBC - Execute and Select. I have filled in all required fields and still get this error.

  • anubhav_nautiya's avatar
    anubhav_nautiya
    Contributor
    6 years ago

    Could you please share a sample input file and expected output file.
    Regards
    Anubhav

    • vbetharasi's avatar
      vbetharasi
      New Contributor
      6 years ago

      HI Anubhav,

      Here I uploaded the sample file where commas(,) are converting as backslash() for USERROLE field.

      Thanks,
      Venu

      Sample_data.zip (663 Bytes)

      • anubhav_nautiya's avatar
        anubhav_nautiya
        Contributor
        6 years ago

        Hi Venu, I am still not sure on your requirement, if possible share the pipeline as well.I want to see the input to the CSV formatter Snap.

        Regards
        Anubhav