dev@glassfish.java.net

Re: How to make TopLink use SQL range constraints like SELECT TOP START AT ?

From: Tom Ware <tom.ware_at_oracle.com>
Date: Fri, 05 Jan 2007 09:07:26 -0500

The code that implements setFirstResult and setMaxResults makes use of
JDBC constructs rather than SQL constructs.

I suggest entering an Enhancement request for this.

-Tom

Markus KARG wrote:

>I am implementing SQLAnywherePlatform and want to make TopLink use that
>DBMS's "SELECT TOP x START AT y" range constraints feature when
>setFirstResult and setMaxResults is used. How can I do that? I did not
>find something like "supportRangeConstraints" in DatabasePlatform.
>
>Thanks
>Markus
>
>