Displaying differences for changeset
 
display as  

src/java/m/rhem/rhem04_surfacetextureclasses/V1_0.java

@@ -22,6 +22,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;
 
@@ -43,14 +44,14 @@
     public void doProcess() throws ServiceException, ClassNotFoundException {
         try (Connection connection = getResourceJDBC(MSSQL_RHEM);
                 Statement statement = connection.createStatement();) {
-            String query = "SELECT text_id, text_abreviation, text_label "
-                    + "FROM rhem.d_rhem_text_lookup "
-                    + "WHERE text_id "
-                    + "IN (SELECT DISTINCT(text_class_id) "
-                    + "FROM rhem.d_rhem_texture_class_subclass "
-                    + "WHERE obsolete = 'false');";
+//            String query = "SELECT text_id, text_abreviation, text_label "
+//                    + "FROM rhem.d_rhem_text_lookup "
+//                    + "WHERE text_id "
+//                    + "IN (SELECT DISTINCT(text_class_id) "
+//                    + "FROM rhem.d_rhem_texture_class_subclass "
+//                    + "WHERE obsolete = 'false');";
 
-            try (ResultSet resultSet = statement.executeQuery(query)) {
+            try (ResultSet resultSet = statement.executeQuery(DBQueries.RHEM04Query01())) {
                 while (resultSet.next()) {
                     int id = resultSet.getInt("text_id");
                     String kind = "texture class";