Example usage for org.hibernate.type StandardBasicTypes INTEGER

Introduction

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

Prototype

IntegerType INTEGER

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

Click Source Link

Document

The standard Hibernate type for mapping Integer to JDBC java.sql.Types#INTEGER INTEGER .

Usage

From source file:org.jmangos.world.persistence.MySQLDialect.java

License:Open Source License

public MySQLDialect() {
    super();
    registerFunction("bitwise_and", new SQLFunctionTemplate(StandardBasicTypes.INTEGER, "(?1 & ?2)"));
}

From source file:org.joda.time.contrib.hibernate.PersistentLocalTimeExact.java

License:Apache License

public Object nullSafeGet(ResultSet rs, String[] names, SessionImplementor session, Object owner)
        throws HibernateException, SQLException {
    Object timestamp = StandardBasicTypes.INTEGER.nullSafeGet(rs, names[0], session, owner);
    if (timestamp == null) {
        return null;
    }/*from   w  w  w.j a v  a2  s  .c  o  m*/

    return LocalTime.fromMillisOfDay(((Number) timestamp).intValue());
}

From source file:org.joda.time.contrib.hibernate.PersistentLocalTimeExact.java

License:Apache License

public void nullSafeSet(PreparedStatement statement, Object value, int index, SessionImplementor session)
        throws HibernateException, SQLException {
    if (value == null) {
        StandardBasicTypes.INTEGER.nullSafeSet(statement, null, index, session);
    } else {//from w ww .  j a  va2  s.  co  m
        LocalTime lt = ((LocalTime) value);
        StandardBasicTypes.INTEGER.nullSafeSet(statement, new Integer(lt.getMillisOfDay()), index, session);
    }
}

From source file:org.libreplan.business.workingday.hibernate.EffortDurationType.java

License:Open Source License

@Override
public Object nullSafeGet(ResultSet rs, String[] names, SessionImplementor session, Object owner)
        throws HibernateException, SQLException {
    Integer seconds = StandardBasicTypes.INTEGER.nullSafeGet(rs, names[0], session);
    if (seconds == null) {
        return null;
    }/* ww w  .j a v a  2  s.c o  m*/
    return EffortDuration.elapsing(seconds, Granularity.SECONDS);
}

From source file:org.libreplan.business.workingday.hibernate.EffortDurationType.java

License:Open Source License

@Override
public void nullSafeSet(PreparedStatement st, Object value, int index, SessionImplementor session)
        throws HibernateException, SQLException {
    EffortDuration duration = (EffortDuration) value;
    Integer seconds = duration != null ? duration.getSeconds() : null;
    StandardBasicTypes.INTEGER.nullSafeSet(st, seconds, index, session);
}

From source file:org.n52.sos.config.sqlite.HibernateSQLiteDialect.java

License:Open Source License

public HibernateSQLiteDialect() {
    registerColumnType(Types.BIT, "integer");
    registerColumnType(Types.TINYINT, "tinyint");
    registerColumnType(Types.SMALLINT, "smallint");
    registerColumnType(Types.INTEGER, "integer");
    registerColumnType(Types.BIGINT, "bigint");
    registerColumnType(Types.FLOAT, "float");
    registerColumnType(Types.REAL, "real");
    registerColumnType(Types.DOUBLE, "double");
    registerColumnType(Types.NUMERIC, "numeric");
    registerColumnType(Types.DECIMAL, "decimal");
    registerColumnType(Types.CHAR, "char");
    registerColumnType(Types.VARCHAR, "varchar");
    registerColumnType(Types.LONGVARCHAR, "longvarchar");
    registerColumnType(Types.DATE, "date");
    registerColumnType(Types.TIME, "time");
    registerColumnType(Types.TIMESTAMP, "timestamp");
    registerColumnType(Types.BINARY, "blob");
    registerColumnType(Types.VARBINARY, "blob");
    registerColumnType(Types.LONGVARBINARY, "blob");
    registerColumnType(Types.BLOB, "blob");
    registerColumnType(Types.CLOB, "clob");
    registerColumnType(Types.BOOLEAN, "integer");
    registerFunction("concat", new VarArgsSQLFunction(StandardBasicTypes.STRING, "", "||", ""));
    registerFunction("mod", new SQLFunctionTemplate(StandardBasicTypes.INTEGER, "?1 % ?2"));
    registerFunction("substr", new StandardSQLFunction("substr", StandardBasicTypes.STRING));
    registerFunction("substring", new StandardSQLFunction("substr", StandardBasicTypes.STRING));

    sqliteUniqueDelegate = new SQLiteUniqueDelegate(this);
}

From source file:org.niord.core.db.MySQLSpatialDialect.java

License:Apache License

MySQLSpatialFunctions() {
    functionsToRegister.put("dimension", new StandardSQLFunction("dimension", StandardBasicTypes.INTEGER));
    functionsToRegister.put("geometrytype", new StandardSQLFunction("geometrytype", StandardBasicTypes.STRING));
    functionsToRegister.put("srid", new StandardSQLFunction("srid", StandardBasicTypes.INTEGER));
    functionsToRegister.put("envelope", new StandardSQLFunction("envelope"));
    functionsToRegister.put("astext", new StandardSQLFunction("astext", StandardBasicTypes.STRING));
    functionsToRegister.put("asbinary", new StandardSQLFunction("asbinary", StandardBasicTypes.BINARY));
    functionsToRegister.put("isempty", new StandardSQLFunction("isempty", StandardBasicTypes.BOOLEAN));
    functionsToRegister.put("issimple", new StandardSQLFunction("issimple", StandardBasicTypes.BOOLEAN));
    // Register functions for spatial relation constructs
    functionsToRegister.put("overlaps", new StandardSQLFunction("overlaps", StandardBasicTypes.BOOLEAN));
    functionsToRegister.put("intersects", new StandardSQLFunction("intersects", StandardBasicTypes.BOOLEAN));
    functionsToRegister.put("equals", new StandardSQLFunction("equals", StandardBasicTypes.BOOLEAN));
    functionsToRegister.put("contains", new StandardSQLFunction("contains", StandardBasicTypes.BOOLEAN));
    functionsToRegister.put("crosses", new StandardSQLFunction("crosses", StandardBasicTypes.BOOLEAN));
    functionsToRegister.put("disjoint", new StandardSQLFunction("disjoint", StandardBasicTypes.BOOLEAN));
    functionsToRegister.put("touches", new StandardSQLFunction("touches", StandardBasicTypes.BOOLEAN));
    functionsToRegister.put("within", new StandardSQLFunction("within", StandardBasicTypes.BOOLEAN));
}

From source file:org.openmrs.hl7.db.hibernate.HibernateHL7DAO.java

License:Mozilla Public License

/**
 * @see org.openmrs.hl7.db.HL7DAO#getAllHL7InQueues()
 *///  www  .j  a v a2s  .  c  om
@SuppressWarnings("unchecked")
public List<HL7InQueue> getAllHL7InQueues() throws DAOException {
    return sessionFactory.getCurrentSession()
            .createQuery("from HL7InQueue where messageState = ? order by HL7InQueueId")
            .setParameter(0, HL7Constants.HL7_STATUS_PENDING, StandardBasicTypes.INTEGER).list();
}

From source file:org.openmrs.hl7.db.hibernate.HibernateHL7DAO.java

License:Mozilla Public License

/**
 * @see org.openmrs.hl7.db.HL7DAO#getNextHL7InQueue()
 *//*from w ww.j a va2  s  .  com*/
public HL7InQueue getNextHL7InQueue() throws DAOException {
    Query query = sessionFactory.getCurrentSession()
            .createQuery("from HL7InQueue as hiq where hiq.messageState = ? order by HL7InQueueId")
            .setParameter(0, HL7Constants.HL7_STATUS_PENDING, StandardBasicTypes.INTEGER).setMaxResults(1);
    if (query == null) {
        return null;
    }
    return (HL7InQueue) query.uniqueResult();
}

From source file:org.openmrs.hl7.db.hibernate.HibernateHL7DAO.java

License:Mozilla Public License

/**
 * limits results of getHL7InArchiveByState
 *//*w w w .  ja  v a 2s. c  o m*/
@SuppressWarnings("unchecked")
private List<HL7InArchive> getHL7InArchiveByState(Integer state, Integer maxResults) throws DAOException {
    Query q = sessionFactory.getCurrentSession().createQuery("from HL7InArchive where messageState = ?")
            .setParameter(0, state, StandardBasicTypes.INTEGER);
    if (maxResults != null) {
        q.setMaxResults(maxResults);
    }
    return q.list();
}