Re: JDBC question: Creating new arrays

Joe Tomcat <tomcat(at)mobile(dot)mp> writes:

> It seems that there is a difficulty in JDBC with creating arrays. I
> have an array of ints that I want to store in PG. If I try code like
> this:
>
> int[] intArray = { .... };
> PreparedStatement ps = db.prepareStatement(...);
> ps.setObject(1, intArray);
>
> it doesn't work. There is a PreparedStatement.setArray() method, but it
> takes a java.sql.Array as an argument, and yet the Array interface
> doesn't define any constructors and there doesn't seem to be any factory
> for it either!!!!

Then you probably need to wrap your Java array in an object that
implements java.sql.Array so that the JDBC driver can talk to it.
Shouldn't be hard.

-Doug