HQLからSQL
例えばこんな感じ。
Job job = (Job) jobDao.getHibernateTemplate().load(Job.class, 1L);
QueryTranslator t = new QueryTranslatorImpl("select man from Man as man where job=:job", "select man from Man as man where job=:job" ,null, (SessionFactoryImplementor)jobDao.getHibernateTemplate().getSessionFactory());
t.compile(null, false);
List list = jobDao.getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery("select count(*) from ( " + t.getSQLString() +")").setEntity(0, job).list();