public static ScrCity getScrCityById(String sessionID, int id, String entidad) throws AttributesException, SessionException, ValidationException { Validator.validate_String_NotNull_LengthMayorZero( sessionID, ValidationException.ATTRIBUTE_SESSION); ScrCity result = null; Transaction tran = null; try { Session session = HibernateUtil.currentSession(entidad); tran = session.beginTransaction(); // Recuperamos la sesión CacheFactory.getCacheInterface().getCacheEntry(sessionID); result = (ScrCity) session.load(ScrCity.class, new Integer(id)); HibernateUtil.commitTransaction(tran); return result; } catch (SessionException sE) { HibernateUtil.rollbackTransaction(tran); throw sE; } catch (Exception e) { HibernateUtil.rollbackTransaction(tran); log.error("Impossible to load ScrCity for session [" + sessionID + "]", e); throw new AttributesException(AttributesException.ERROR_CANNOT_FIND_CITIES); } finally { HibernateUtil.closeSession(entidad); } }
public static ValidationResults getProvForCities( String sessionID, int firstRow, int maxResults, String where, String additionalFieldName, String docColName, String entidad) throws AttributesException, SessionException, ValidationException { Validator.validate_String_NotNull_LengthMayorZero( sessionID, ValidationException.ATTRIBUTE_SESSION); Validator.validate_String_NotNull_LengthMayorZero( sessionID, ValidationException.ATTRIBUTE_SESSION); ValidationResults result = new ValidationResults(); Transaction tran = null; try { Session session = HibernateUtil.currentSession(entidad); tran = session.beginTransaction(); // Recuperamos la sesión CacheFactory.getCacheInterface().getCacheEntry(sessionID); // Calculamos el tamaño de los resultados StringBuffer querySize = new StringBuffer(); querySize.append("select count(*) from "); querySize.append(HIBERNATE_ScrProv); querySize.append(" as scr"); if (where != null && where.length() > 0) { querySize.append(" as scr where "); } Criteria criteriaResults = session.createCriteria(ScrProv.class); result = getValidationResults( session, criteriaResults, querySize.toString(), where, 1, firstRow, maxResults, "name"); result.setAdditionalFieldName(additionalFieldName); result.setDocColName(docColName); // result.setResults(provincies); HibernateUtil.commitTransaction(tran); return result; } catch (Exception e) { log.error( "Impossible to load provinces for getProvForCities for session [" + sessionID + "]", e); throw new AttributesException(AttributesException.ERROR_CANNOT_FIND_PROV); } finally { HibernateUtil.closeSession(entidad); } }