Re: Accepting Object[] as an acceptable input to setObject with Types.ARRAY?

On 4 June 2011 08:04, Steven Schlansker <stevenschlansker@gmail.com> wrote:

> It looks like adding support for such a fix to the Postgres driver would be extremely easy.  In particular looking
aroundAbstractJdbc2Statement.java:1732 
>
>            case Types.ARRAY:
>                if (in instanceof Array)
>                    setArray(parameterIndex, (Array)in);
>                else
>                    throw new PSQLException(GT.tr("Cannot cast an instance of {0} to type {1}", new
Object[]{in.getClass().getName(),"Types.ARRAY"}),PSQLState.INVALID_PARAMETER_TYPE); 
>                break;
>
> it could check if in is an array type and if so synthesize the Array object necessary.
>
> Does this sound like a reasonable feature request?  Did I miss an easier way to do this?  It is probably outside of
theJDBC spec but it at least has some traction with H2... 

How do you determine the type of the (server-side) array elements?
i.e. what is the typename that setObject would pass to createArrayOf()
when it encountered an Object[]?

Oliver