Dynamic Query : what is best fetch HQL or Criteria ?

Saloucious · **Joined:** Wed Aug 10, 2005 8:07 am **Posts:** 14

Hibernate version:3.0.5

Hi,
i desire to generate a dynamic query which depends of some parameters
Something like that :

Code:

StringBuffer sb = new StringBuffer("Select toto ");
for(int i = 0;i<tabDate.length;i++)
{
   sb.append(" b"+i+",");
}
Query q = new Query(sb.toString());
....      

This kind of code works well , but it is not so usefull (comma, ....) and difficult for maintenance !

So, is there others solutions to create a query like that , for example with Criteria.

tferraz · **Posted:** Mon Oct 03, 2005 8:38 am

if your query is build in a dinamic way, it's best ( and easier ) to use Criteria.

Saloucious · **Joined:** Wed Aug 10, 2005 8:07 am **Posts:** 14

Ok thanks, but is it possible to retrieve multiple differents Object (eg : Account, Bank, User, ....) from a Criteria query ?

tferraz · **Posted:** Mon Oct 03, 2005 10:41 am

yes - but I'm not certain how - I think it's usin createAlias or setFetchMode methods.

http://www.hibernate.org/hib_docs/v3/re ... teria.html this may help, though it dont tell how are the generated sql or other *really* usefull stuff.

Saloucious · **Joined:** Wed Aug 10, 2005 8:07 am **Posts:** 14

Thanks, i will try with fetchMode , but i don't understand that well.
Sometimes the HQL method is more usefull but error-prone ....

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

Quote:

if your query is build in a dinamic way, it's best ( and easier ) to use Criteria.

hql is better and Criteria is easier

Criteria add any hql and you can't control it and so , hql is better

Criteria is easier if you can do what you want do