Re: selecting using array as IN condition parameter - possible?

Hi, after some more searching on the net I came across references to
PGobject and got this working using standard JDBC calls which is a good
start, I don't suppose any one has any hints about using this in JPA
queries under eclipselink? I've created a converter for the single case,
but i get errors when I try and use an array.

If I try and receive an array I get a not implemented error on
getArrayImpl due to the use of a Map. Conversely if I construct an array
of my PGobjects subclasses and try to pass that as a parameter to a
query I get an exception that setObject can't infer the sql type needed
and to provide an explicit one. I was hoping that as PGobject has a
getType method that it would be used?

Is it possible to specify the type when passing an array using JPA?

Thanks

John

On 29/09/2010 13:59, John Lister wrote:
> Hi, suppose I have a query such as
> select * from blah where (a,b) in ( (1,2),(2,3),(3,4)...)
> I'd like to do this using jdbc and use a list/array for the IN parameter.
> using postgresql 8.3, it is possible to rewrite it so that I am
> passing in an array instead of a hardcoded list as so
> select * from blah where (a, b)::myPairType = any ( array of myPairType)
> provided I've created a type (myPairType) to represent my data pair
> and a comparison operator for the new data type.
> My question is therefore is it possible to pass an array of this type
> using jdbc or alternatively pass an array of arrays to represent my
> pair and convert that in the sql?
> Thanks
> John
> --
> Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/