createQuery vs createCriteria

nusa · **Joined:** Fri Sep 24, 2004 8:18 am **Posts:** 24

Hi,

I have the following criteria :

Code:

List list = hibernateSession.createCriteria(A.class)
                            .createAlias("pojo2","e")
                            .setProjection( Projections.projectionList()
                                .add( Projections.property("e.col1").as("Description") )
                                .add( Projections.property("this.cola").as("Comments") )
                            )
                            .add( Property.forName("e.col2").eq( anId ) )
                            .addOrder( Order.asc("e.col3") )
                            .setCacheable(true)
                            .setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP)
                            .list(); 

What will be the syntax if I use an entityManager.createQuery() ?
I mean, how to convert the above if I want to use entityManager ?

Thanks for any help/suggestions/pointers.

emmanuel · **Posted:** Thu Nov 17, 2005 8:32 am

you can access the underlying session when working with a em ( (HibernateentityManager) em ).getSession() and then still use the criteria API

nusa · **Joined:** Fri Sep 24, 2004 8:18 am **Posts:** 24

emmanuel wrote:

you can access the underlying session when working with a em ( (HibernateentityManager) em ).getSession() and then still use the criteria API

Oh la vache ... merci Manu ... :)

BLudkiewicz · **Posted:** Fri Feb 10, 2006 4:00 pm

I'm curious, if the only kind of querying being done is by Criteria, are there any advantages to using the EntityManager as all I will be doing with it is opening a regular Session?

Thanks,
Ben