EJB 3.0 with ADF Faces UI - EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g - page 169

}
public Catalog findEntity(int catalogId) {
Catalog entityInstance =null;
List catalogEntry = em.createQuery(
"SELECT c from Catalog c
where c.id=:id").setParameter("id",catalogId).
getResultList();
for (Iterator iter = catalogEntry.iterator(); iter.hasNext(); ) {
entityInstance = (Catalog)iter.next();
}
return entityInstance;
}
/** <code>select o from Catalog o</code> */
public List<Catalog> queryCatalogFindAll() {
return em.createNamedQuery("Catalog.findAll").getResultList();
}
/** <code>select o from Catalog o</code> */
public List<Catalog> queryCatalogFindAllByRange(int firstResult,
int maxResults) {
Query query = em.createNamedQuery("Catalog.findAll");
if (firstResult > 0) {
query = query.setFirstResult(firstResult);
}
if (maxResults > 0) {
query = query.setMaxResults(maxResults);
}
return query.getResultList();
}
public void removeCatalog(Catalog catalog) {
catalog = em.find(Catalog.class, catalog.getId());
em.remove(catalog);
}
}
The remote business interface CatalogSessionEJB is listed next:
package model;
import java.util.List;
import javax.ejb.Remote;
@Remote
public interface CatalogSessionEJB {