On Mon, 22 Feb 2010, beulah prasanthi wrote:
Helo I am working on spring project with postgres 8.4 i wrote a function in postgrees which i am passing the argument email email[] array From front end we need to insesrt data into that emailarray .so i used java.arraylist.util while i am running i got the following error Please help me error: org.postgresql.util.PSQLException: Cannot cast an instance of java.util.ArrayList to type Types.ARRAY
You need to pass an instance of java.sql.Array, not a Collection or something else that is array like.
Also please only report an issue once rather than a half dozen times. Kris Jurka -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
