dive4elements/river: backend/src/main/java/org/dive4elements/river/model/Gauge.java comparison

Use explicit query to avoid hibernate connection leak.

author	Tom Gottfried <tom@intevation.de>
date	Thu, 27 Nov 2014 20:15:38 +0100
parents	a895eb07a7dc
children	5e38e2924c07

comparison

equal deleted inserted replaced

-:7dd39219bd68
+:0c22ef71d154
 * @return the min and max W value of this gauge [min,max].
 */
 public double[] determineMinMaxW() {
 Session session = SessionHolder.HOLDER.get();
-List<DischargeTable> tables   = getDischargeTables();
+DischargeTable dischargeTable = fetchMasterDischargeTable();
-DischargeTable dischargeTable = null;
-for (DischargeTable tmp: tables) {
-if (tmp.getKind() == 0) {
-dischargeTable = tmp;
-break;
-}
-}
 if (dischargeTable == null) {
 return null;
 }
 return results.isEmpty() ? null : results.get(0);
 }
 public DischargeTable fetchMasterDischargeTable() {
-for (DischargeTable dt: dischargeTables) {
+Session session = SessionHolder.HOLDER.get();
-if (dt.getKind() == MASTER_DISCHARGE_TABLE) {
-return dt;
+Query query = session.createQuery(
-}
+"from DischargeTable " +
-}
+"where kind = 0 " +
+"and gauge = :gauge");
-return null;
+query.setParameter("gauge", this);
+List<Object> results = query.list();
+return results.isEmpty()
+? null
+: (DischargeTable)results.get(0);
 }
 /**
 * Returns an array of [days, qs] necessary to create duration curves.
 *

Mercurial > dive4elements > river