public int getServerCount() { Query query = PersistenceUtility.createCountQuery(entityManager, Server.QUERY_FIND_ALL); try { long serverCount = (Long) query.getSingleResult(); return (int) serverCount; } catch (NoResultException nre) { log.debug("Could not get count of cloud instances, returning 0..."); return 0; } }
@RequiredPermissions({ @RequiredPermission(Permission.MANAGE_SETTINGS), @RequiredPermission(Permission.MANAGE_INVENTORY) }) public PageList<FailoverListDetails> getFailoverListDetailsByAgentId( Subject subject, int agentId, PageControl pc) { pc.initDefaultOrderingField("fld.ordinal"); Query query = PersistenceUtility.createQueryWithOrderBy( entityManager, FailoverListDetails.QUERY_GET_VIA_AGENT_ID_WITH_SERVERS, pc); Query countQuery = PersistenceUtility.createCountQuery( entityManager, FailoverListDetails.QUERY_GET_VIA_AGENT_ID); query.setParameter("agentId", agentId); countQuery.setParameter("agentId", agentId); @SuppressWarnings("unchecked") List<FailoverListDetails> list = query.getResultList(); long count = (Long) countQuery.getSingleResult(); return new PageList<FailoverListDetails>(list, (int) count, pc); }
@SuppressWarnings("unchecked") @RequiredPermissions({ @RequiredPermission(Permission.MANAGE_SETTINGS), @RequiredPermission(Permission.MANAGE_INVENTORY) }) public PageList<ServerWithAgentCountComposite> getServerComposites( Subject subject, PageControl pc) { pc.initDefaultOrderingField("s.name"); Query query = PersistenceUtility.createQueryWithOrderBy( entityManager, Server.QUERY_FIND_ALL_COMPOSITES, pc); List<ServerWithAgentCountComposite> results = query.getResultList(); int count = getServerCount(); return new PageList<ServerWithAgentCountComposite>(results, count, pc); }
@Override public void enableHibernateStatistics() { PersistenceUtility.enableHibernateStatistics( this.entityManager, ManagementFactory.getPlatformMBeanServer()); }