[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
|