Thread: implementing setObject(n, java array[])

implementing setObject(n, java array[])

From
Dave Cramer
Date:
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

Re: implementing setObject(n, java array[])

From
Jojo Paderes
Date:
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

Re: implementing setObject(n, java array[])

From
Dave Cramer
Date:
Jojo,

The setObject array is not implemented. This is something we should
do. The spec suggests that you implement the java.sql.Array interface
on your object and
use setArray(n,Array)

Enough people have complained that I guess it's time we implemented it.

Patches are welcome!


Dave
On 20-Nov-05, at 11:01 AM, Jojo Paderes wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings