Thursday 9 April 2009

[Hibernate] native SQL example- One return column case

String gSql = "select sYear from VIEW_REPORT_BillingRegion group by sYear";

// Query query = sessionFactory.getCurrentSession().createQuery(gSql);
SQLQuery query = this.sessionFactory.getCurrentSession().createSQLQuery(gSql).addScalar("sYear", Hibernate.STRING);


List[Object] list = query.list();
System.out.println("======="+list.size());
for( Object objArr : list){
System.out.println(objArr );
}
System.out.println("============"+list.size());

No comments: