Displaying differences for changeset
 
display as  

src/java/m/rhem/rhem05_slopeShapes/V1_0.java

@@ -21,6 +21,7 @@
 import oms3.annotations.Name;
 import org.codehaus.jettison.json.JSONArray;
 import org.codehaus.jettison.json.JSONException;
+import rhem.utils.DBQueries;
 import rhem.utils.DBResources;
 import static rhem.utils.DBResources.MSSQL_RHEM;
 
@@ -48,11 +49,11 @@
 
         try (Connection conn = getResourceJDBC(MSSQL_RHEM);
                 Statement statement = conn.createStatement();) {
-            String query = "SELECT choice_id, choice_label "
-                    + "FROM rhem.d_rhem_slope_shape "
-                    + "WHERE obsolete = 'false';";
+//            String query = "SELECT choice_id, choice_label "
+//                    + "FROM rhem.d_rhem_slope_shape "
+//                    + "WHERE obsolete = 'false';";
 
-            try (ResultSet resultSet = statement.executeQuery(query)) {
+            try (ResultSet resultSet = statement.executeQuery(DBQueries.RHEM05Query01())) {
                 while (resultSet.next()) {
                     int id = resultSet.getInt("choice_id");
                     String kind = "slope shape";