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)); |