Forum Discussion

pvsharish9's avatar
pvsharish9
New Contributor II
4 years ago

SQL Server account connection setup failing with multiple error

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
Valued Contributor
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

Ganeshu108's avatar
Ganeshu108
New Contributor II
2 years ago

Thank You !