Setting array values in JDBC (Driver 7.2)

From: Doug Fields <dfields-postgresql(at)pexicom(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Setting array values in JDBC (Driver 7.2)
Date: 2002-02-21 00:04:01
Message-ID: 5.1.0.14.2.20020220190127.035013a8@mail.pexicom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

As Barry has said, setArray() on a Prepared Statement is currently implemented.

However, there seems to be no way to actually update a Postgresql row with
a native Java array.

Per the JDBC Docs, one should be able to do this with the setObject() call.
This doesn't work in PG JDBC:

DbArrayTest.doInsertTest: SQLException: The table for [I is not in the
database. Contact the DBA, as the database is in an inconsistent state.

(when using an int[] array)

So, you can setArray() but there is no way to create an Array object except
by using the getArray() from retrieving a ResultSet. Well, if you're
creating a record from scratch, you seem to be stuck.

Help?

Thanks,

Doug

Browse pgsql-jdbc by date

  From Date Subject
Next Message Doug Fields 2002-02-21 00:12:14 Empty arrays cause SQLExceptions when using Array.getArray
Previous Message Rene Pijlman 2002-02-20 23:58:06 Re: jdbc2 package question