/[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 2613 by torben, Fri Mar 20 13:57:47 2015 UTC revision 2614 by torben, Wed Jul 15 13:31:28 2015 UTC
# Line 3  package dk.daoas.daoadresseservice.db; Line 3  package dk.daoas.daoadresseservice.db;
3  import java.io.IOException;  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.ResultSet;
7  import java.sql.SQLException;  import java.sql.SQLException;
8  import java.sql.Statement;  import java.sql.Statement;
9    
# Line 22  public class DbConnectionProbe extends H Line 23  public class DbConnectionProbe extends H
23          // TODO Auto-generated constructor stub          // TODO Auto-generated constructor stub
24      }      }
25    
26    
27          protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {          protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
28                  response.setContentType("text/html");                  response.setContentType("text/html");
29                  PrintWriter out = response.getWriter();                  PrintWriter out = response.getWriter();
# Line 36  public class DbConnectionProbe extends H Line 38  public class DbConnectionProbe extends H
38                                                    
39                          out.print("Got DB Connection<br>");                          out.print("Got DB Connection<br>");
40                                                    
41                          stmt.executeQuery("SELECT 1");                          try (ResultSet res = stmt.executeQuery("SELECT 1") ) {
42                                                            out.print("'SELECT 1' query ok");      
43                          out.print("'SELECT 1' query ok");                          }
44                                                    
45                                                    
46                  } catch (SQLException e)  {                  } catch (SQLException e)  {
Legend:
Removed from v.2613  
changed lines
  Added in v.2614
  ViewVC Help
Powered by ViewVC 1.1.20