/*
 * @{#}SampleSelectWithHibernate.java
 */

package i.am.a.package;

import com.foxone.cms.persistence.HibernateUtil;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.SQLQuery;
import org.hibernate.Session;

/**
 * Sample select using hiberante.
 * 
 * @author koala_man_sucks
 * @version 1.0, 04/04/08
 */
public class SampleSelectWithHibernate {

    public static List<Object[]> sampleSelect() {
        List<Object[]> records = null;
        final Session s = HibernateUtil.getSession();
        final boolean isActive = s.getTransaction().isActive();
        if (!isActive) {
            s.beginTransaction();
        }
        try {
            SQLQuery q = s.createSQLQuery("SELECT col1,col2,col3 FROM donkey");
            records = q.list();
            if (!isActive) {
                s.getTransaction().commit();
            }
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (!isActive) {
                s.getTransaction().rollback();
            }
        }
        return records;
    }
}