Hi,
first of all congrats on fantastic Hibernate Project.
Next, I would like to ask few questions:
1) How to force logical or in expressions, I couldn't figure out.
I'm using something like this and I need ors instead of ands there:
Code:
crit.add(Restrictions.like("prodName", "%" + s + "%"));
crit.add(Restrictions.like("prodCode", "%" + s + "%"));
crit.add(Restrictions.like("prodDescription", "%" + s + "%"));
products.addAll(crit.list());
2) Is there any way in hib. ocnfig to enable showing actual values instead of question marks in generated sql stat. shown in console (turned on show sql in config)? Using MySQl+InnoDB, netbeans IDE, not using log4j by my own unless installed in IDE.
Code:
...from eshop_v1.Products this_ where this_.prod_name like ? and this_.prod_code like ? and this_.prod_description like ?
Thanks, regards
Marek