Displaying differences for changeset |
@@ -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"; |