--- dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/02/24 08:00:03 2357
+++ dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/07/17 08:41:58 2628
@@ -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,12 +23,13 @@
// TODO Auto-generated constructor stub
}
+
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
- out.print("DaoAdresseService");
- out.print("DaoAdresseService
");
+ //out.print("DaoAdresseService");
+ //out.print("DaoAdresseService
");
try (
Connection conn = DBConnection.getConnection();
@@ -36,9 +38,15 @@
out.print("Got DB Connection
");
- stmt.executeQuery("SELECT 1");
-
- out.print("'SELECT 1' query ok");
+ try (ResultSet res = stmt.executeQuery("SELECT 1") ) {
+ res.next();
+ int i = res.getInt(1);
+ if (i == 1) {
+ out.print("'SELECT 1' query ok");
+ } else{
+ out.print("'SELECT 1' returned unexpected result : " + i);
+ }
+ }
} catch (SQLException e) {