ejb ql question: (select ... limit 10)

[marcwea]

Hello,

I am using JBoss and it is a great tool. To improve performance, I would like to have a ejbFindBy... method that returns a limited number of row. Is it possible to specify using ejb-ql and also using a parameter to specify the number of row you want it to return.

In postgresql, the sql query would look like:

SELECT * FROM deliveryejb WHERE status=2 LIMIT 10;

Thanks for your answer.

Marc

[dsundstrom]

No. It has been looked at, but every database does it very differently. Since in the 3.x version we are targeting all databases at once, there is really no way to support it. This will be supported in the 4.0 version because the new architecture will allow easily customized code for each type of persistence store.

[marcwea]

Thanks for your quick answer. I understand your response and I look forward to the 4.0 version.
In the mean time, before I go to jdbc, would JBossQL do the job on 3.0? I have never used it yet so if you can you provide me this last information I will jump into it.
Thanks.

Marc

[dsundstrom]

I was talking about JBossQL. EJB-QL definately does not support LIMIT OFFSET (it's not in the spec).

[marcwea]

Got you!
Thanks

Marc