Re: [GENERAL] [BUGS] helo

[Kris Jurka]

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [BUGS] helo

[Kevin Grittner]

Kris Jurka bo...@ejurka.com wrote:
 
 You need to pass an instance of java.sql.Array, not a Collection
 or something else that is array like.
 
Ah, right.  After extracting an array from the java.util.ArrayList,
it needs to be turned into a java.sql.Array using the
Connection.createArrayOf method.
 
Most definitely not a PostgreSQL bug.
 
-Kevin

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general