- DB db = new DB();\r
- String sql = "select SUBID, NODEID from EGRESS_ROUTES";\r
- try (Connection conn = db.getConnection()) {\r
- try (Statement stmt = conn.createStatement()) {\r
- try (ResultSet rs = stmt.executeQuery(sql)) {\r
- addEgressRouteToSet(set, rs);\r
- }\r
- } finally {\r
- db.release(conn);\r
- }\r
+ try (Connection conn = ProvDbUtils.getInstance().getConnection();\r
+ Statement stmt = conn.createStatement();\r
+ ResultSet rs = stmt.executeQuery("select SUBID, NODEID from EGRESS_ROUTES")) {\r
+ addEgressRouteToSet(set, rs);\r