I've been looking for a way to pass array values of Java primitive
types to a PL/pgSQL function that accepts an array parameter. I keep
on getting this exception:
org.postgresql.util.PSQLException: Can't infer the SQL type to use for
an instance of [I. Use setObject() with an explicit Types value to
specify the type to use.
Also, I'm looking for a technical resource from the PGSQL JDBC site on
how to pass primitive array values to functions using the
CallableStatement class. Any tips on how to do this?
On 10/18/05, Dave Cramer <pg@fastcrypt.com> wrote:
> There are a number of people who would like to be able to do
>
> Statement.setObject( n, int[] )
>
> as well as most other java primitive arrays.
>
> The array implementation seems to be quite a stumbling block to non
> java people . I certainly see the merit in doing this.
>
> What do others think ?
>
> Dave