Re: [eclipselink-users] Routing native SQL queries to appropriate partit

[Vladimir Blagojevic <dovlex@xxxxxxxxx>]

Hi,

Response to self and others if they happen to encounter this issue in the future. Since eclipselink internally converts positional parameters to Strings just like any other named parameter I just setup additional partitioning policy for this native query that defined <partition-column name="1" /> - the first positional parameter is evaluated for query routing, in my case range partitioning policy routing. Uber cool!

Regards,

Vladimir

 

On Mon, Apr 1, 2013 at 12:43 PM, Vladimir Blagojevic <dovlex@xxxxxxxxx> wrote:

Hi,

I got my JPA queries routed to appropriate partitions using range partitioning and named query parameter. Everything works smoothly! However, I do not know how to do the same for native queries as only positional parameters are used. Much appreciated!

Regards,

Vladimir