public class Form implements java.io.Serializable {

   private Integer id;
   private int version;
   private String name;
   private Set<FormItem> formItems = new HashSet<FormItem>(0);
...
}

public class FormItem implements java.io.Serializable {

   private Integer id;
   private int version;
   private String type;
   private String name;
   private Form form;
...
}

   @Test
   public void testCollection() {
      formItem0 = new FormItem();
      formItem0.setName("name");
      formItem0.setListOrder(2);
      formItem0.setType("itemtype");
      formItem0.setForm(form0);
      formItem1 = new FormItem();
      formItem1.setName("name");
      formItem1.setListOrder(1);
      formItem1.setType("itemtype");
      formItem1.setForm(form0);
      form0 = formDao.makePersistent(form0);
      formItem0 = formItemDao.makePersistent(formItem0);
      formItem1 = formItemDao.makePersistent(formItem1);
      Form retrievedForm = formDao.findById(form0.getId(), false);
      retrievedForm = formDao.findById(form0.getId(), false);
      assertEquals(2, retrievedForm.getFormItems().size());
   }

   public FormDaoTest() {
      form0 = new Form();
      form0.setName(name0);
      form1 = new Form();
      form1.setName(name1);
      form1.setImage(image);
   }

   @Test
   public void testSaveAndRetrieve() {
      form0 = formDao.makePersistent(form0);
      assertNotNull(form0.getId());
      assertNotSame(form0.hashCode(), 0L);
      assertFalse(form0.toString().equals(""));
      Form retrievedForm = formDao.findById(form0.getId(), false);
      assertEquals(form0.hashCode(), retrievedForm.hashCode());
      assertEquals(form0.getName(), retrievedForm.getName());
      assertNotNull(retrievedForm.getId());
   }

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Apr 18, 2010 1:03:51 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="core.domain.Form" table="form" dynamic-insert="true" dynamic-update="true">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="identity" />
        </id>
        <version name="version" type="int">
            <column name="version" not-null="true" />
        </version>
        <property name="name" type="string">
            <column name="name" length="50" not-null="true" />
        </property>
        <property name="description" type="string">
            <column name="description" not-null="false" />
        </property>
        <set name="formItems" inverse="true">
            <key>
                <column name="form_id" not-null="false" />
            </key>
            <one-to-many class="core.domain.FormItem" />
        </set>
    </class>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Apr 18, 2010 1:03:51 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="core.domain.FormItem" table="form_item" dynamic-insert="true" dynamic-update="true">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="identity" />
        </id>
        <version name="version" type="int">
            <column name="version" not-null="true" />
        </version>
        <many-to-one name="form" class="core.domain.Form" cascade="all" fetch="select">
            <column name="form_id" not-null="true" />
        </many-to-one>
        <property name="type" type="string">
            <column name="type" length="50" not-null="true" />
        </property>
        <property name="name" type="string">
            <column name="name" length="50" not-null="false" />
        </property>
        <property name="listOrder" type="int">
            <column name="list_order" not-null="true" />
        </property>
    </class>
</hibernate-mapping>

   @Test
   public void testCollection() {
      // saving the form
      form0 = formDao.makePersistent(form0);

      // creating the items
      formItem0 = new FormItem();
      formItem0.setName("name");
      formItem0.setListOrder(2);
      formItem0.setType("itemtype");
      formItem0.setForm(form0);
      formItem1 = new FormItem();
      formItem1.setName("name");
      formItem1.setListOrder(1);
      formItem1.setType("itemtype");
      formItem1.setForm(form0);
      formItem0 = formItemDao.makePersistent(formItem0);
      formItem1 = formItemDao.makePersistent(formItem1);
      Form retrievedForm = formDao.findById(form0.getId(), false);
      retrievedForm = formDao.findById(form0.getId(), false);
      assertEquals(2, retrievedForm.getFormItems().size());
   }

   @Test
   public void testCollection() {
      form0 = formDao.makePersistent(form0);
      formItem0 = new FormItem();
      formItem0.setName("name");
      formItem0.setListOrder(2);
      formItem0.setType("itemtype");
      formItem0.setForm(form0);
      formItem1 = new FormItem();
      formItem1.setName("name");
      formItem1.setListOrder(1);
      formItem1.setType("itemtype");
      formItem1.setForm(form0);
      formItem0 = formItemDao.makePersistent(formItem0);
//      formItem1 = formItemDao.makePersistent(formItem1);
//      Form retrievedForm = formDao.findById(form0.getId(), false);
//      retrievedForm = formDao.findById(form0.getId(), false);
//      assertEquals(2, retrievedForm.getFormItems().size());
   }

package com.thalasoft.learnintouch.core.dao;

import java.io.Serializable;
import java.util.List;

import com.thalasoft.learnintouch.core.domain.Form;
import com.thalasoft.learnintouch.core.domain.FormItem;

public interface FormItemDao extends GenericDao<FormItem, Serializable> {

   public List<FormItem> findByForm(Form form);
   public List<FormItem> findByFormOrderById(Form form);
   public FormItem findByListOrder(Form form, int listOrder);
   public FormItem findNextByListOrder(Form form, int listOrder);
   public FormItem findPreviousByListOrder(Form form, int listOrder);
   public long countListOrderDuplicates(Form form);

}

package com.thalasoft.learnintouch.core.dao.hibernate;

import java.io.Serializable;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.transaction.annotation.Transactional;

import com.thalasoft.learnintouch.core.dao.FormItemDao;
import com.thalasoft.learnintouch.core.domain.Form;
import com.thalasoft.learnintouch.core.domain.FormItem;

@Transactional
public class FormItemHibernateDao extends GenericHibernateDao<FormItem, Serializable> implements FormItemDao {

   @SuppressWarnings("unchecked")
   public List<FormItem> findByForm(Form form) {
      Criteria criteria = getSession().createCriteria(FormItem.class);
      criteria.add(Restrictions.eq("form", form)).addOrder(Order.asc("listOrder"));
      return criteria.list();      
   }
   
   @SuppressWarnings("unchecked")
   public List<FormItem> findByFormOrderById(Form form) {
      Criteria criteria = getSession().createCriteria(FormItem.class);
      criteria.add(Restrictions.eq("form", form)).addOrder(Order.asc("id"));
      return criteria.list();      
   }
   
   @Override
   public FormItem findByListOrder(Form form, int listOrder) {
      Criteria criteria = getSession().createCriteria(FormItem.class);
      criteria.add(Restrictions.eq("form", form)).add(Restrictions.eq("listOrder", listOrder)).setMaxResults(1);
      return (FormItem) criteria.uniqueResult();
   }

   @Override
   public FormItem findNextByListOrder(Form form, int listOrder) {
      Criteria criteria = getSession().createCriteria(FormItem.class);
      criteria.add(Restrictions.eq("form", form)).add(Restrictions.gt("listOrder", listOrder)).addOrder(Order.asc("listOrder")).setMaxResults(1);
      return (FormItem) criteria.uniqueResult();
   }

   @Override
   public FormItem findPreviousByListOrder(Form form, int listOrder) {
      Criteria criteria = getSession().createCriteria(FormItem.class);
      criteria.add(Restrictions.eq("form", form)).add(Restrictions.lt("listOrder", listOrder)).addOrder(Order.desc("listOrder")).setMaxResults(1);
      return (FormItem) criteria.uniqueResult();
   }

   @Override
   public long countListOrderDuplicates(Form form) {
      long itemCount = 0;
      try {
         Query query = getSession().createQuery("select count(fi1.id) as count from FormItem fi1, FormItem fi2 where fi1.id != fi2.id and fi1.listOrder = fi2.listOrder and fi1.form.id = ?");
          query.setLong(0, form.getId());
         Long count = (Long) query.list().get(0);
         itemCount = count.longValue();
      } catch (Exception e) {
           itemCount = 0;
      }
      return itemCount;
   }

}

package com.thalasoft.learnintouch.core.dao;

import java.io.Serializable;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Criterion;

public interface GenericDao<T, ID extends Serializable> {

   T makePersistent(T entity);
   
   void makeTransient(T entity);
   
    T findById(ID id, boolean lock);

    boolean isFoundById(ID id);

    List<T> findAll();

    long countAllRows();

    long countFoundRows();

    List<T> findByExample(T exampleInstance, String... excludeProperty);

    List<T> findObjectsByCriteria(Criterion... criterion);
   
    T findObjectByCriteria(Criterion... criterion);
   
   T findObjectByCriteria(Criteria criteria);
   
    Session getSession();
   
}

package com.thalasoft.learnintouch.core.dao.hibernate;

import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.Criteria;
import org.hibernate.LockMode;
import org.hibernate.ObjectNotFoundException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Criterion;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.Projections;
import org.springframework.transaction.annotation.Transactional;

import com.thalasoft.learnintouch.core.dao.GenericDao;

@Transactional
public abstract class GenericHibernateDao<T, ID extends Serializable> implements GenericDao<T, ID> {

   private static Logger log = Logger.getLogger(GenericHibernateDao.class);

   private Class<T> persistentClass;
   private SessionFactory sessionFactory;

   @SuppressWarnings("unchecked")
   public GenericHibernateDao() {
      this.persistentClass = (Class<T>) ((ParameterizedType) getClass().getGenericSuperclass()).getActualTypeArguments()[0];
   }

   public void setSessionFactory(SessionFactory sessionFactory) {
      this.sessionFactory = sessionFactory;
   }

   public SessionFactory getSessionFactory() {
      if (sessionFactory == null) {
         throw new IllegalStateException("sessionFactory has not been set on DAO before usage");
      }
      return sessionFactory;
   }

   public Class<T> getPersistentClass() {
      return persistentClass;
   }
   
   @Override
   public Session getSession() {
      return getSessionFactory().getCurrentSession();
   }

   @SuppressWarnings("unchecked")
   @Override
   public T findById(ID id, boolean lock) {
      T entity;
      if (lock)
         entity = (T) getSession().load(getPersistentClass(), id, LockMode.UPGRADE);
      else
         entity = (T) getSession().load(getPersistentClass(), id);

      return entity;
   }

   @SuppressWarnings("unchecked")
   @Override
   public boolean isFoundById(ID id) {
      try {
         @SuppressWarnings("unused")
         T entity = (T) getSession().load(getPersistentClass(), id);
      } catch (ObjectNotFoundException e) {
         return false;
      }

      return true;
   }

   @Override
   public List<T> findAll() {
      return findObjectsByCriteria();
   }

   @Override
   public long countAllRows() {
      Criteria criteria = getSession().createCriteria(getPersistentClass());
      criteria.setProjection(Projections.rowCount());
      // TODO why I cant have a Long here ?
      Integer count = (Integer) criteria.list().get(0);
      long itemCount = count.intValue();
      return itemCount;
   }

   @Override
   public long countFoundRows() {
      Criteria criteria = getSession().createCriteria(getPersistentClass());
      criteria.setProjection(Projections.rowCount());
      // TODO why I cant have a Long here ?
      Integer count = (Integer) criteria.uniqueResult();
       long itemCount = count.intValue();
      return itemCount;
   }

   @SuppressWarnings("unchecked")
   @Override
   public List<T> findByExample(T exampleInstance, String... excludeProperty) {
      Criteria criteria = getSession().createCriteria(getPersistentClass());
      Example example = Example.create(exampleInstance);
      for (String exclude : excludeProperty) {
         example.excludeProperty(exclude);
      }
      criteria.add(example);
      return criteria.list();
   }

   @Override
   public T makePersistent(T entity) {
      getSession().saveOrUpdate(entity);
      return entity;
   }

   @Override
   public void makeTransient(T entity) {
      getSession().delete(entity);
   }

   public void flush() {
      getSession().flush();
   }

   public void clear() {
      getSession().clear();
   }

   @SuppressWarnings("unchecked")
   @Override
   public List<T> findObjectsByCriteria(Criterion... criterion) {
      Criteria criteria = getSession().createCriteria(getPersistentClass());
      for (Criterion c : criterion) {
         criteria.add(c);
      }
      return criteria.list();
   }

   @Override
   public T findObjectByCriteria(Criterion... criterion) {
      T object = null;
      List<T> results = findObjectsByCriteria(criterion);

      if (results.isEmpty()) {
         if (log.isDebugEnabled()) {
            log.debug("No search results found for: " + criterion);
         }
      } else {
         if (results.size() > 1) {
            if (log.isDebugEnabled()) {
               log.debug("The criterion : " + criterion + " should return only one result");
            }
         }
         object = results.get(0);
      }

      return object;
   }

   @SuppressWarnings("unchecked")
   @Override
   public T findObjectByCriteria(Criteria criteria) {
      T object = null;
      List<T> results = criteria.list();

      if (results.isEmpty()) {
         if (log.isDebugEnabled()) {
            log.debug("No search results found for the criteria : " + criteria);
         }
      } else {
         if (results.size() > 1) {
            if (log.isDebugEnabled()) {
               log.debug("The criteria : " + criteria + " should return only one result");
            }
         }
         object = results.get(0);
      }

      return object;
   }

}

public String save(ENTITY entity)
{
   String ret = "";
   if (StringUtils.isValid(entity.getId()))
   {
      session.update(entity);
                ret = entity.getId();
   }
   else
   {
      ret = session.save(entity).toString();
      entity.setId(ret);
   }

   return ret;
}

   @Autowired
   protected FormItemDao formItemDao;

   @Test
   public void testCollection() {
      formItem0 = new FormItem();
      formItem0.setName("name");
      formItem0.setListOrder(2);
      formItem0.setType("itemtype");
      formItem0.setForm(form0);
      formItem1 = new FormItem();
      formItem1.setName("name");
      formItem1.setListOrder(1);
      formItem1.setType("itemtype");
      formItem1.setForm(form0);
      form0 = formDao.makePersistent(form0);
//      formItem0 = formItemDao.makePersistent(formItem0);
//      formItem1 = formItemDao.makePersistent(formItem1);
      Form retrievedForm = formDao.findById(form0.getId(), false);
      assertEquals(2, retrievedForm.getFormItems().size());
   }

   @Test
   public void testCollection() {
      form0 = formDao.makePersistent(form0);
      formItem0 = new FormItem();
      formItem0.setName("name");
      formItem0.setListOrder(2);
      formItem0.setType("itemtype");
      formItem0.setForm(form0);
      formItem1 = new FormItem();
      formItem1.setName("name");
      formItem1.setListOrder(1);
      formItem1.setType("itemtype");
      formItem1.setForm(form0);
//      formItem0 = formItemDao.makePersistent(formItem0);
//      formItem1 = formItemDao.makePersistent(formItem1);
      Form retrievedForm = formDao.findById(form0.getId(), false);
      assertEquals(2, retrievedForm.getFormItems().size());
   }

   @Test
   public void testCollection() {
      formItem0 = new FormItem();
      formItem0.setName("name");
      formItem0.setListOrder(2);
      formItem0.setType("itemtype");
      formItem0.setForm(form0);
      formItem1 = new FormItem();
      formItem1.setName("name");
      formItem1.setListOrder(1);
      formItem1.setType("itemtype");
      formItem1.setForm(form0);
      form0 = formDao.makePersistent(form0);
      formItem0 = formItemDao.makePersistent(formItem0);
      formItem1 = formItemDao.makePersistent(formItem1);
      Form retrievedForm = formDao.findById(form0.getId(), false);
      assertEquals(2, retrievedForm.getFormItems().size());
   }

   @Test
   public void testCollection() {
      formItem0 = new FormItem();
      formItem0.setName("name");
      formItem0.setListOrder(2);
      formItem0.setType("itemtype");
      formItem0.setForm(form0);
      formItem1 = new FormItem();
      formItem1.setName("name");
      formItem1.setListOrder(1);
      formItem1.setType("itemtype");
      formItem1.setForm(form0);
      formItem0 = formItemDao.makePersistent(formItem0);
      formItem1 = formItemDao.makePersistent(formItem1);
      form0 = formDao.makePersistent(form0);
      Form retrievedForm = formDao.findById(form0.getId(), false);
      assertEquals(2, retrievedForm.getFormItems().size());
   }