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

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

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

revision 2269 by torben, Thu Feb 12 14:26:36 2015 UTC revision 2356 by torben, Tue Feb 24 07:57:47 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 27  public class DbConnectionProbe extends H Line 28  public class DbConnectionProbe extends H
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                            Statement stmt = conn.createStatement()
35                            ) {
36                            
37                            stmt.executeQuery("SELECT 1");                  
38                            
39                          out.print("Got DB Connection");                          out.print("Got DB Connection");
40                                                    
41                  } catch (SQLException e)  {                  } catch (SQLException e)  {
Legend:
Removed from v.2269  
changed lines
  Added in v.2356
  ViewVC Help
Powered by ViewVC 1.1.20