07-20-2023 05:28 AM
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 module java.base of loader ‘bootstrap’; java.sql.Array is in module java.sql of loader ‘platform’).
Solved! Go to Solution.
07-20-2023 06:49 AM
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
07-20-2023 06:49 AM
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
07-28-2023 02:00 AM
Thank You !
07-28-2023 01:49 AM
Worked perfectly thank you!