Finder methods to find all (CMP)

[kgeffen]

Hi,

I'm searching for ways to create a finder method for an entity bean to
find all rows in a table. I recently found a post on it but i cant
seem to find it anymore.

Can someone help me on my way on this subject. I'm looking for some
ways to select all data from a database, instead of using findByXXX
methods. One way i thought it may work is a whereclause (1=1) or
something.

Does someone has a suggestion?

Tnx

 

[Sudsy]

Hi,

I'm searching for ways to create a finder method for an entity bean to
find all rows in a table. I recently found a post on it but i cant
seem to find it anymore.

Then you don't want a finder, you want a select, something like
selectAll:

public abstract Collection ejbSelectAll() throws FinderException;

Then just write the corresponding EJB-QL, somthing like:

select object (c) from TABLENAME c

where TABLENAME is the name of your table or view.