[perfectjpattern-users] Queries in Jpa dao
Brought to you by:
bravegag
From: Mansour Al A. <man...@gm...> - 2010-12-17 02:22:44
|
Hello all: How do I use queires in a DAO that extends AbstractJpaManagedBaseDao ? For example, AbstractJpaManagedBaseDao prevents accessing entityManager. So I can not use queries to select of filter some objects. Here's a code: @Stateless(name = "GeoDao") public class GeoDaoImpl extends AbstractJpaManagedBaseDao<String, Geo> implements GeoDao { public GeoDaoImpl() { super(Geo.class); } @PersistenceContext(unitName = "myPU") public void setEntityManager(EntityManager em) { super.setEntityManager(em); } @Override public Geo getByAbbreviation(String abbreviation) { IQuery query = getSession().createQuery("select g from Geo g WHERE g.abbreviation= :abbr"); //HERE I NEED TO SET THE PARAMETERS for abbreviation List <Geo> res = query.getResultList(); return res.get(0); } } I am using openEJB with openJPA. Can not use spring or hibernate. Am I missing something ? Thank you in advance |