Hibernateでfrom dual

ここを読む
http://www.hibernate.org/hib_docs/v3/reference/en/html/querysql.html#querysql-creating


例えばseqを動かす時。

(String) getHibernateTemplate().execute(new HibernateCallback() {
  public Object doInHibernate(Session session) throws HibernateException {
    return session
             .createSQLQuery("select hoge_seq.nextval val from dual")
             .addScalar("val", Hibernate.STRING)
             .uniqueResult();
    }
});