passing array(java) to postgre sql function

From: "bond" <kirank174(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: passing array(java) to postgre sql function
Date: 2006-02-14 10:11:20
Message-ID: 1139911880.531826.81080@f14g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

in postgreSql, i have written a function which accepts a String array
and inserts the contents to DB.
when i tested that function by passing the values like:

SELECT TEST_ARRAY('{xxx,yyyy,pppp,wwwwww}');

where TEST_ARRAY is my function name.

the records get inserted correctly. But now the problem is how to pass
the values from java to this function?

I have implemented the java.sql.Array interface, and given the actual
implementation to getArray() method, like this:

public Object getArray(){
ArrayList temp = new ArrayList();
temp.add("MMMM");
temp.add("NNNN");
temp.add("TTTTT");
temp.add("QQQQQ");
return temp.toArray();
}
After this i am passing this.getArray() values to database.

but at this point of time i get the following Exception:
org.postgresql.util.PSQLException: Unsupported Types value: 2,003
at
org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1630)
at
org.postgresql.jdbc3.AbstractJdbc3Statement.setObject(AbstractJdbc3Statement.java:1436)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1636)

Is this the problem with the driver wht i am usng?

Can anyonme please help me to overcome this??

Waiting for your response,

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message garhone 2006-02-14 15:28:30 SELECT on a to-be-determined table
Previous Message Michael Fuhr 2006-02-14 05:17:21 Re: Slow update SQL