[ My blog ] A simple SQL: SELECT * FROM Animal AS a1 INNER JOIN Animal AS a2 on a1.mother_id = a2.ID and a1.body_weight < :aLimit Another: SELECT * FROM Animal AS a1 INNER JOIN Animal AS a2 on a1.mother_id = a2.ID WHERE a1.body_weight < :aLimit Which is the difference in term of results ? There...
[ My blog ] I’m proud to announce NH2.1.0 is passing all tests (same of H3.3.1) for bulk actions using HQL. Some HQL examples: insert into Animal (description, bodyWeight, mother) select description, bodyWeight, mother from Human insert into Pickup (id, Vin, Owner) select id, Vin, Owner from Car...
[ from my blog ] Mapping: < class name = " SimpleClass " table = " TSIMPLE " > < id type = " int " > < generator class = " native " /> </ id > < property name = " Description " /> </ class > Class: public class SimpleClass...
A few days ago Oren Eini and Davy Brion were working in a new feature for NH 2.1 (no a release yet) called Future, in the ICriteria API. You can see and explanation of the job here . Now I’ve committed a complement to enable that use into the IQuery API, for those who prefer to use HQL. What is...