Example usage for org.hibernate.type StandardBasicTypes YES_NO

List of usage examples for org.hibernate.type StandardBasicTypes YES_NO

Introduction

In this page you can find the example usage for org.hibernate.type StandardBasicTypes YES_NO.

Prototype

YesNoType YES_NO

To view the source code for org.hibernate.type StandardBasicTypes YES_NO.

Click Source Link

Document

The standard Hibernate type for mapping Boolean to JDBC java.sql.Types#CHAR CHAR(1) (using 'Y'/'N').

Usage

From source file:gov.utah.dts.det.ccl.dao.impl.FacilityDaoImpl.java

License:Open Source License

@Override
public List<UserCaseloadCount> getUserCaseloadCounts() {
    Session session = (Session) em.getDelegate();
    SQLQuery query = session.createSQLQuery(CASELOAD_COUNT_QUERY);
    query.addScalar("id", StandardBasicTypes.LONG);
    query.addScalar("name", StandardBasicTypes.STRING);
    query.addScalar("roleType", StandardBasicTypes.STRING);
    query.addScalar("active", StandardBasicTypes.YES_NO);
    query.addScalar("count", StandardBasicTypes.LONG);
    query.setResultTransformer(Transformers.aliasToBean(UserCaseloadCount.class));
    return (List<UserCaseloadCount>) query.list();
}