--- dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/02/24 07:43:04 2355
+++ dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/02/24 07:57:47 2356
@@ -4,6 +4,7 @@
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
+import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
@@ -27,9 +28,14 @@
out.print("DaoAdresseService");
out.print("DaoAdresseService
");
- try {
- Connection conn = DBConnection.getConnection();
- conn.close();
+
+ try (
+ Connection conn = DBConnection.getConnection();
+ Statement stmt = conn.createStatement()
+ ) {
+
+ stmt.executeQuery("SELECT 1");
+
out.print("Got DB Connection");
} catch (SQLException e) {