Here is what a minor issue makes me do:
@Override @SuppressWarnings("unchecked") public List<NavlinkItem> findWithNavlink(Navlink navlink) { String statement = "select id, version, name, description, image, image_over as imageOver, url, blank_target as blankTarget, language_code as languageCode from navlink_item where navlink_id = :navlinkId order by language_code nulls first"; Query query = getSession().createSQLQuery(statement) .addScalar("id", StandardBasicTypes.INTEGER) .addScalar("version", StandardBasicTypes.INTEGER) .addScalar("name") .addScalar("description") .addScalar("image") .addScalar("imageOver") .addScalar("url") .addScalar("blankTarget", StandardBasicTypes.BOOLEAN) .addScalar("languageCode"); query.setInteger("navlinkId", navlink.getId()); return query.setResultTransformer(Transformers.aliasToBean(NavlinkItem.class)).list(); }
instead of:
public List<NavlinkItem> findWithNavlink(Navlink navlink) { Criteria criteria = getSession().createCriteria(getPersistentClass()); criteria.add(Restrictions.eq("navlink", navlink)).addOrder(Order.asc("languageCode").nullsFirst()); return criteria.list(); }
Here is what a minor issue makes me do:
@Override
@SuppressWarnings("unchecked")
public List<NavlinkItem> findWithNavlink(Navlink navlink) { String statement = "select id, version, name, description, image, image_over as imageOver, url, blank_target as blankTarget, language_code as languageCode from navlink_item where navlink_id = :navlinkId order by language_code nulls first"; Query query = getSession().createSQLQuery(statement) .addScalar("id", StandardBasicTypes.INTEGER) .addScalar("version", StandardBasicTypes.INTEGER) .addScalar("name") .addScalar("description") .addScalar("image") .addScalar("imageOver") .addScalar("url") .addScalar("blankTarget", StandardBasicTypes.BOOLEAN) .addScalar("languageCode"); query.setInteger("navlinkId", navlink.getId()); return query.setResultTransformer(Transformers.aliasToBean(NavlinkItem.class)).list(); }
instead of:
public List<NavlinkItem> findWithNavlink(Navlink navlink) { Criteria criteria = getSession().createCriteria(getPersistentClass()); criteria.add(Restrictions.eq("navlink", navlink)).addOrder(Order.asc("languageCode").nullsFirst()); return criteria.list(); }