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,
