Re: JDBC and arrays

Thank you for explanation. If I still want to write inet[] data, is it
sufficient to implement PGobject so it returns 'inet[]' type and '{
"ip", "ip" }' value and pass that to setObject()?

--
Miroslav Šulc



Kris Jurka napsal(a):
>
>
> On Fri, 2 Feb 2007, Miroslav Šulc wrote:
>
>> I tried to find some info on how to work with arrays using PostgreSQL
>> JDBC driver but didn't find anything useful except that I can
>> implement java.sql.Array to get support for arrays. Can someone,
>> please, send me a link on how to write and read array data using
>> PostgreSQL JDBC driver or give me a brief explanation? I'm also
>> interested how to work with inet[] arrays as they do not seem to be
>> directly supported by JDBC API.
>
> Reading arrays is pretty straightforward:
>
> ResultSet rs = stmt.executeQuery("SELECT '{a,b}'::text[]");
> rs.next();
> Array arr = rs.getArray(1);
> String s[] = (String)arr.getArray();
>
> Writing arrays is not easy because prior to the JDBC4 spec there was
> no way to create java.sql.Array objects without creating a class that
> implements java.sql.Array yourself.  Now JDBC4 offers
> Connection.createArrayOf() which unfortunately we haven't implemented
> yet. So while there is a light at the end of the tunnel you're still
> stuck implementing java.sql.Array yourself.  Check the mailing list
> for examples of that.
>
> Currently arrays of non-standard datatypes like inet are not
> supported. Seems possible to do if you were willing to use PGobject
> for unknown types, but no one has done it.
>
> Also more complicated things like multi-dimensional arrays are note
> supported.
>
> Kris Jurka
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org