org.hibernate.Query#setLong

Source File: DbManager.java From megatron-java with Apache License 2.0

6 votes

public boolean isRangeOverlapping(long start, long end) 
        throws DbException { 
    try {
        String sql = "SELECT COUNT(*) FROM ip_range WHERE (end_address >= ? AND end_address <= ?) OR (start_address <=  ? AND end_address >= ?) OR  (start_address >= ? AND start_address <= ?) OR (start_address >= ? AND end_address <= ?)";

        Query query = session.createSQLQuery(sql);
        query.setLong(0, start);   
        query.setLong(1, end);
        query.setLong(2, start);
        query.setLong(3, end);
        query.setLong(4, start);
        query.setLong(5, end);
        query.setLong(6, start);
        query.setLong(7, end);

        long result = ((BigInteger)query.list().get(0)).longValue();

        return query.list() != null && result > 0;
    }
    catch (Exception e) {
        throw handleException(e.getClass().getSimpleName() + " exception in isRangeOverlapping", e);
    }           
}

Source File: AutomationDAO.java From document-management-system with GNU General Public License v2.0

6 votes

/**
 * Get validation by pk
 */
public AutomationValidation findValidationByPk(long avId) throws DatabaseException {
	log.debug("findValidationByPk({})", avId);
	String qs = "from AutomationValidation av where av.id=:id";
	Session session = null;

	try {
		session = HibernateUtil.getSessionFactory().openSession();
		Query q = session.createQuery(qs);
		q.setLong("id", avId);
		AutomationValidation ret = (AutomationValidation) q.setMaxResults(1).uniqueResult();
		initialize(ret);
		log.debug("findValidationByPk: {}", ret);
		return ret;
	} catch (HibernateException e) {
		throw new DatabaseException(e.getMessage(), e);
	} finally {
		HibernateUtil.close(session);
	}
}

Source File: MailAccountDAO.java From document-management-system with GNU General Public License v2.0

6 votes

/**
 * Find by pk
 */
public static MailAccount findByPk(long maId) throws DatabaseException {
	log.debug("findByPk({})", maId);
	String qs = "from MailAccount ma where ma.id=:id";
	Session session = null;

	try {
		session = HibernateUtil.getSessionFactory().openSession();
		Query q = session.createQuery(qs);
		q.setLong("id", maId);
		MailAccount ret = (MailAccount) q.setMaxResults(1).uniqueResult();
		log.debug("findByPk: {}", ret);
		return ret;
	} catch (HibernateException e) {
		throw new DatabaseException(e.getMessage(), e);
	} finally {
		HibernateUtil.close(session);
	}
}

Source File: MessageForumsMessageManagerImpl.java From sakai with Educational Community License v2.0

6 votes

/**
 * Returns count of all read msgs for given user that have been approved or
 * were authored by user
 * @param topicId
 * @param userId
 * @return
 */
public int findReadViewableMessageCountByTopicIdByUserId(final Long topicId, final String userId) {
	if (topicId == null || userId == null) {
        log.error("findReadViewableMessageCountByTopicIdByUserId failed with topicId: " + topicId + 
        			" and userId: " + userId);
        throw new IllegalArgumentException("Null Argument");
    }

    log.debug("findReadViewableMessageCountByTopicIdByUserId executing with topicId: " + topicId + 
    				" and userId: " + userId);

    HibernateCallback<Number> hcb = session -> {
        Query q = session.getNamedQuery(QUERY_COUNT_READ_VIEWABLE_BY_TOPIC_ID);
        q.setLong("topicId", topicId);
        q.setString("userId", userId);
        return (Number) q.uniqueResult();
    };

    return getHibernateTemplate().execute(hcb).intValue();
}

Source File: GradebookServiceHibernateImpl.java From sakai with Educational Community License v2.0

6 votes

@SuppressWarnings({ "rawtypes", "unchecked" })
private List getAllAssignmentGradeRecordsForGbItem(final Long gradableObjectId,
		final Collection studentUids) {
	final HibernateCallback hc = new HibernateCallback() {
		@Override
		public Object doInHibernate(final Session session) throws HibernateException {
			if (studentUids.isEmpty()) {
				// If there are no enrollments, no need to execute the query.
				if (log.isInfoEnabled()) {
					log.info("No enrollments were specified.  Returning an empty List of grade records");
				}
				return new ArrayList();
			} else {
				final Query q = session.createQuery("from AssignmentGradeRecord as agr where agr.gradableObject.removed=false and " +
						"agr.gradableObject.id=:gradableObjectId order by agr.pointsEarned");
				q.setLong("gradableObjectId", gradableObjectId);
				return filterGradeRecordsByStudents(q.list(), studentUids);
			}
		}
	};
	return (List) getHibernateTemplate().execute(hc);
}

Source File: CronTabDAO.java From document-management-system with GNU General Public License v2.0

6 votes

/**
 * Find by pk
 */
public static CronTab findByPk(long ctId) throws DatabaseException {
	log.debug("findByPk({})", ctId);
	String qs = "from CronTab ct where ct.id=:id";
	Session session = null;

	try {
		session = HibernateUtil.getSessionFactory().openSession();
		Query q = session.createQuery(qs);
		q.setLong("id", ctId);
		CronTab ret = (CronTab) q.setMaxResults(1).uniqueResult();
		log.debug("findByPk: {}", ret);
		return ret;
	} catch (HibernateException e) {
		throw new DatabaseException(e.getMessage(), e);
	} finally {
		HibernateUtil.close(session);
	}
}

Source File: CourseOffering.java From unitime with Apache License 2.0

6 votes

public static CourseOffering findBySessionSubjAreaAbbvCourseNbrTitle(Long acadSessionId, String subjAreaAbbv, String courseNbr, String title) {

        InstructionalOfferingDAO iDao = new InstructionalOfferingDAO();
        org.hibernate.Session hibSession = iDao.getSession();
        
        String sql = " from CourseOffering co " +
                     " where co.subjectArea.subjectAreaAbbreviation=:subjArea" +
                     " and co.courseNbr = :crsNbr" +
                     " and co.title = :title" +
                     " and co.instructionalOffering.session.uniqueId = :acadSessionId";
        Query query = hibSession.createQuery(sql);
        query.setString("crsNbr", courseNbr);
        query.setString("subjArea", subjAreaAbbv);
        query.setLong("acadSessionId", acadSessionId.longValue());
        query.setString("title", title);
        
        return (CourseOffering)query.uniqueResult();

    }

Source File: DBQueryUtil.java From kardio with Apache License 2.0

6 votes

/**
 * Update the k8s_pods_containers table with number of Pods&Containers
 * @param envId
 * @param compName
 * @param numOfPods
 * @param parentCompName
 * @param numOfCont
 */
public static void updatePodsAndContainers(final int envId, String compName, int numOfPods, String parentCompName, int numOfCont){
	final java.sql.Date todayDate = new java.sql.Date(Calendar.getInstance().getTimeInMillis());;
	final int compId = getComponentId(compName, parentCompName);
	if(compId == 0){
		logger.info("Component Name = " + compName + "; Parent Component Name = " + parentCompName + "; is not available in the DB");
		return;
	}
	Session session = HibernateConfig.getSessionFactory().getCurrentSession();
	Transaction txn = session.beginTransaction();
	Query query = session.createQuery(HQLConstants.UPDATE_K8S_PODS_CONT_DETAILS);
	query.setInteger("totalPods", numOfPods);
	query.setInteger("totalContainers", numOfCont);
	query.setLong("compId", compId);
	query.setLong("environmentId", envId);
	query.setDate("stsDate", todayDate);
	query.executeUpdate();
	txn.commit();
}