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 module java.base of loader ‘bootstrap’; java.sql.Array is in module java.sql of loader ‘platform’).
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
