2 Replies Latest reply on Mar 6, 2005 12:06 AM by mduffy_lists

LIMIT 1

mduffy_lists Mar 2, 2005 1:35 AM

In MySQL the LIMIT keyword can be used to limit the number of returns in a query.

Is there any type of support for this in EJB 3.0?

I checked the spec and did not see any thing: Enterprise JavaBeans 3.0, Early Draft 2

Thx

Mike

1. Re: LIMIT 1

rexorient Mar 2, 2005 9:21 AM (in response to mduffy_lists)

Here's how to set the limit as well as the starting point in the table to get the entries from.

@Inject private EntityManager manager;
...
manager.createQuery("from Test").setMaxResults(50).setFirstResult(100);

Alain
Actions
2. Re: LIMIT 1

mduffy_lists Mar 6, 2005 12:06 AM (in response to mduffy_lists)

Thx!
Actions

Go to original post