final Query query = this.getSession().createQuery("select s.code from Sample as s where s.id=:id and name=:name");
query.setParameter("id", idLong);
query.setParameter("name", nameStr);
finalLong result = (Long) query.uniqueResult();
Nowadays, I'll consider the fact of Hibernate 3.x-5.1 are no longer mantained.