--- dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/07/15 10:41:57 2613 +++ dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/07/15 13:31:28 2614 @@ -3,6 +3,7 @@ import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; +import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; @@ -22,6 +23,7 @@ // TODO Auto-generated constructor stub } + protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); @@ -36,9 +38,9 @@ out.print("Got DB Connection
"); - stmt.executeQuery("SELECT 1"); - - out.print("'SELECT 1' query ok"); + try (ResultSet res = stmt.executeQuery("SELECT 1") ) { + out.print("'SELECT 1' query ok"); + } } catch (SQLException e) {