--- dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionTest.java 2015/02/12 13:57:32 2267
+++ dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/02/24 08:00:03 2357
@@ -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;
@@ -12,11 +13,11 @@
import javax.servlet.http.HttpServletResponse;
-@WebServlet("/DbConnectionTest")
-public class DbConnectionTest extends HttpServlet {
+@WebServlet("/DbConnectionProbe")
+public class DbConnectionProbe extends HttpServlet {
private static final long serialVersionUID = 1L;
- public DbConnectionTest() {
+ public DbConnectionProbe() {
super();
// TODO Auto-generated constructor stub
}
@@ -27,10 +28,18 @@
out.print("DaoAdresseService");
out.print("DaoAdresseService
");
- try {
- Connection conn = DBConnection.getConnection();
- conn.close();
- out.print("Got DB Connection");
+
+ try (
+ Connection conn = DBConnection.getConnection();
+ Statement stmt = conn.createStatement()
+ ) {
+
+ out.print("Got DB Connection
");
+
+ stmt.executeQuery("SELECT 1");
+
+ out.print("'SELECT 1' query ok");
+
} catch (SQLException e) {
out.print("DB Connection failed: " + e.getMessage());