Hello,

I'm using JPA with Hibernate and falls into a situation and I do not know how to resolve because I have a jsp page like this:

[code]

jsp page with list box

Operacao Field Value
======== ===== =====
Id = 20
State = "SP"
Balance > 1000



Where the field:

ID -> Client object
State -> object Address
Balance -> Object Balance

If the three lines are met as the command would be:

jhl.append ( "SELECT DISTINCT (customer) FROM Customer user, Balance balance JOIN user.address end where doc.estado = 'SP' = saldo.id user.id");

List usuariosdoctos = em.getManager (). CreateQuery (jhl.toString ()). GetResultList ();

If the first line is completed would be like this:

jhl.append ( "SELECT DISTINCT (customer) FROM Customer user where user.id = 20");

List usuariosdoctos = em.getManager (). CreateQuery (jhl.toString ()). GetResultList ();

[/ code]

My doubts mount as it dynamically heard that criteria but I do not know if it can gain criteria ...

If anyone can help me ....

JPA 1.0 does not define a Criteria API, however you can use the Hibernate Session directly like this:

Session s = (Session) entityManager.getDelegate();

Of course this is not portable but it gives you access to the Criteria API.

Note that JPA 2.0 will have a Criteria API but that's several months off.

-Chris

Thanks for the feedback but I have doubts as to criteria that would make my problem reported above.

Can you give me some example (mounted dynamic select and how to receive several lines through MAP, List ... how?) Or url you try to mount any intelligence that you solve my problem.

If anyone can help me ....

Thank you