Result limit

[C N Davies]

Is there any way to limit the size of a result set so that you an specify
the maximum number of records returned?

 

I tried:

 

Query.setHint("openjpa.hint.OptimizeResultCount",new Integer(100))

 

But the generated SQL has no sign of it. I was expecting the generated SQL
to include the LIMIT keyword however it doesn't.

 

Using OpenJPA 1.2.1 and MySQL 5.

 

Chris