Displaying differences for changeset
 
display as  

src/java/m/wqm/wqsr/V1_0.java

@@ -43,12 +43,7 @@
         + "level required for mitigating nutrient and pesticide loss potentials and hazards.")
 @Path("m/wqm/wqsr/1.0")
 @Resource(from = DBResources.class)
-@Resource(type = JDBC, file = "${mssql-ssurgo.db}", id = "mssql", env = {
-    "removeAbandoned=false", "defaultReadOnly=true", "defaultAutoCommit=false",
-    "jdbcInterceptors=org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;"
-    + "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;"
-    + "org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer"
-})
+
 public class V1_0 extends ModelDataService {
 
     private List<m.wqm.wqsr.V1_0.AoA> list;
@@ -66,7 +61,7 @@
                 JSONObject aoaGeometry = JSONUtils.getJSONObjectParam(thisAoA, "aoa_geometry");
 
                 GISObject aoa_geometry;
-                try (Connection connection = getResourceJDBC("mssql");) {
+                try (Connection connection = getResourceJDBC(WQM_ID);) {
                     //  Sets the GIS Engine of the GISObjects to the DBMS specified in
                     //the creation of the “connection” variable.  MsSQL in this case
                     GISObjectFactory.setGISObjectEngine(GISEngineFactory.createGISEngine(connection));