Criteria or on the fly sql

[armita]

I want to create a on the fly SQL applying the values users entered in the search form. I used to do it with hibernates criteria object. Isn't there any equivalent in the EJB3. What can I do to generate on the fly EJB QL?

[manica]

You can access the Criteria API within EJB3 as follows (where manager is your EntityManager):

HibernateSession hs = (HibernateSession)manager;
Session session = hs.getHibernateSession();

Criteria criteria = session.createCriteria(Foo.class);
...

Darin

[armita]

Is it JBoss specific?

[maxandersen]

yes, ejb3 does not have a criteria equivalent functionallity.

[maxandersen]

correction if JBoss refers to the JBoss server and not just our name.

fyi it is not dependent on a JBoss server just dependent on Hibernate Entitymanager which can be used independently

[armita]

I see, I found this a very very helpful functionality, it is a pitty EJB3 could not create on the fly querys. So still hibernate is better than EJB!!