/[projects]/dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionProbe.java
ViewVC logotype

Diff of /dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionProbe.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionTest.java revision 2267 by torben, Thu Feb 12 13:57:32 2015 UTC dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionProbe.java revision 2357 by torben, Tue Feb 24 08:00:03 2015 UTC
# Line 4  import java.io.IOException; Line 4  import java.io.IOException;
4  import java.io.PrintWriter;  import java.io.PrintWriter;
5  import java.sql.Connection;  import java.sql.Connection;
6  import java.sql.SQLException;  import java.sql.SQLException;
7    import java.sql.Statement;
8    
9  import javax.servlet.ServletException;  import javax.servlet.ServletException;
10  import javax.servlet.annotation.WebServlet;  import javax.servlet.annotation.WebServlet;
# Line 12  import javax.servlet.http.HttpServletReq Line 13  import javax.servlet.http.HttpServletReq
13  import javax.servlet.http.HttpServletResponse;  import javax.servlet.http.HttpServletResponse;
14    
15    
16  @WebServlet("/DbConnectionTest")  @WebServlet("/DbConnectionProbe")
17  public class DbConnectionTest extends HttpServlet {  public class DbConnectionProbe extends HttpServlet {
18          private static final long serialVersionUID = 1L;          private static final long serialVersionUID = 1L;
19                
20      public DbConnectionTest() {      public DbConnectionProbe() {
21          super();          super();
22          // TODO Auto-generated constructor stub          // TODO Auto-generated constructor stub
23      }      }
# Line 27  public class DbConnectionTest extends Ht Line 28  public class DbConnectionTest extends Ht
28                                    
29                  out.print("<html><head><title>DaoAdresseService</title></head><body>");                  out.print("<html><head><title>DaoAdresseService</title></head><body>");
30                  out.print("<h2>DaoAdresseService</h2>");                  out.print("<h2>DaoAdresseService</h2>");
31                  try {                  
32                          Connection conn = DBConnection.getConnection();                  try (
33                          conn.close();                          Connection conn = DBConnection.getConnection();
34                          out.print("Got DB Connection");                          Statement stmt = conn.createStatement()
35                            ) {
36                            
37                            out.print("Got DB Connection<br>");
38                            
39                            stmt.executeQuery("SELECT 1");
40                            
41                            out.print("'SELECT 1' query ok");
42                            
43                                                    
44                  } catch (SQLException e)  {                  } catch (SQLException e)  {
45                          out.print("DB Connection failed: " + e.getMessage());                          out.print("DB Connection failed: " + e.getMessage());
Legend:
Removed from v.2267  
changed lines
  Added in v.2357
  ViewVC Help
Powered by ViewVC 1.1.20