[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());

[Hibernate] native SQL example

@SuppressWarnings("unchecked")
@Transactional
public void getTest(IUiListCfg uiListCfg) throws ReportException {

try {
String sSql = "select sGroupId, sGroupName from tRmCo_Group";
SQLQuery query = this.sessionFactory.getCurrentSession().createSQLQuery(sSql).addScalar("sGroupId", Hibernate.STRING).addScalar("sGroupName", Hibernate.STRING);

List list = query.list();
for( Object[] objArr : list){
for( Object obj : objArr){

System.out.println(obj );
}
}
System.out.println("============"+list.size());

} catch (Exception e) {
e.printStackTrace();
}
}

[Hibernate] many-to-many

There are 3 tables
=== Table1 ====
fooId
a

==== Table2 -====
barId
b

==== Table3 ==== (This table is joined from Table1 and Table2)
fooIdEx
barIdEx


===== a.java ===
....
private int foodId;
private String a;

private Set[b] bEnitty;
.......

===== b.java ======
......
private int barId;
private STring b;
............

===== a.hbm.xml (Mapping xml file) ======
.......





......

please refer to http://www.xylax.net/hibernate/manytomany.html

[Hibernate] one-to-many

one-to-many [hibernate]

===== a.java ========
......
private Set[b] bSet;
.......

==== b.java ======
....
....

==== a.hbm.xml -(mapping for a entity xml file) ====