Thread: passing array(java) to postgre sql function

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,003at
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,

Hi, Bond,

bond wrote:

> 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.

As a first guess, have a look at java.sql.Array interface.

And maybe the people on the pgsql-jdbc@postgresql.org mailing list know
better. :-)

HTH,
Markus


-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org