probleme critere hibernate
Bonjour à tous,
je souhaite creer un requete en fonction de critere de recherche
voici ma requete
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| Query query;
String queryString =
"select distinct trequest from TRequest as trequest, TProposition as tproposition "
+ "where tproposition.RequestID = trequest and "
+ "(tproposition.Status = :status1 or tproposition.Status = :status2) and tproposition.Id = " +
"(select max(tproposition2.Id) from TProposition as tproposition2 "+
"where tproposition.RequestID = tproposition2.RequestID) ";
query = session.createQuery(queryString);
query.setString("status1", Proposition.WAITING);
query.setString("status2", Proposition.CANCELING);
if (company != null && company.length() > 0)
{
queryString +="and trequest.UseridConcerned.Company = :company ";
query.setString("company", company);
} |
le probleme est qu'il me jette sur le query.setString("company", company); car j'ai defini plus haut query = session.createQuery(queryString); donc c'est normal.. comment puis je faire ?
Merci