Forum Discussion

Ganeshu108's avatar
Ganeshu108
New Contributor II
3 years ago
Solved

Error:class java.util.ArrayList cannot be cast to class java.sql.Array

Hello , I am facing following issue while inserting data into postgres database from json file. Error : class java.util.ArrayList cannot be cast to class java.sql.Array (java.util.ArrayList is in...
  • SpiroTaleski's avatar
    SpiroTaleski
    3 years ago

    @ganesh1

    I guess that you should transform the JSON in flatten format (split any nested structures from the JSON) before you insert in PostgreSQL table.

    BR,
    Spiro Taleski

jfpelletier's avatar
jfpelletier
Contributor
12 months ago
Copy LinkReport

Hey,

Looks like I've solved my own issue... In my script, I had to encode the input document using the ".encode('utf-8')" method.

I can now parse and correctly extract all the data that I need from the file.

JF

  • Supratim's avatar
    Supratim
    Contributor III
    2 years ago
    Copy Link

    vfantidou  Please use below expression-. From your example seems there are some typo (2nd record in input0 should have ID not ID_NUMERIC). If it's not typo you need make null safe in mapper.

    input0.filter((val,index)=> $filterData.find((ele)=> ele['ID'] ==val['ID'] ) != null )

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    2 years ago
    Copy Link

    Try this expression: 

    $input0.filter((elem) => $filterData.find(x => elem.ID == x.ID))

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    2 years ago
    Copy Link

    vfantidou 

    Try this expression: 

    $input0.filter((elem) => $filterData.find(x => elem.ID == x.ID))

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    2 years ago
    Copy Link

    vfantidou 

    Try with this expression: 

    $input0.filter((elem) => $filterData.find(x => elem.ID == x.ID))

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    2 years ago
    Copy Link

    vfantidou 

    Try with below expression: 

    $input0.filter((elem) => $filterData.find(x => elem.ID == x.ID))