1 14 package org.compiere.web; 15 16 import javax.servlet.*; 17 import javax.servlet.http.*; 18 import java.io.*; 19 import java.util.*; 20 import javax.naming.*; 21 22 import javax.sql.*; 23 import java.sql.*; 24 25 import org.compiere.interfaces.*; 26 27 33 public class StatusInfo extends HttpServlet 34 { 35 static final private String CONTENT_TYPE = "text/html"; 36 public void init() throws ServletException 38 { 39 getServletContext().log("StatusInfo.init"); 40 } 41 42 public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 44 { 45 response.setContentType(CONTENT_TYPE); 46 PrintWriter out = response.getWriter(); 47 out.println("<html>"); 48 out.println("<head><title>Status Info</title></head>"); 49 out.println("<body>"); 50 51 InitialContext context = null; 52 try 53 { 54 context = new InitialContext(); 55 } 56 catch (Exception ex) 57 { 58 out.println("<p><b>" + ex + "</b></p>"); 59 } 60 61 try 62 { 63 StatusHome statusHome = (StatusHome)context.lookup (StatusHome.JNDI_NAME); 64 Status status = statusHome.create(); 65 out.println("<p>" + status.getStatus() + "</p>"); 66 status.remove(); 67 } 68 catch (Exception ex) 69 { 70 out.println("<p><b>" + ex + "</b></p>"); 71 } 72 73 try 74 { 75 ServerHome serverHome = (ServerHome)context.lookup (ServerHome.JNDI_NAME); 76 Server server = serverHome.create(); 77 out.println("<p>" + server.getStatus() + "</p>"); 78 server.remove(); 79 } 80 catch (Exception ex) 81 { 82 out.println("<p><b>" + ex + "</b></p>"); 83 } 84 85 try 86 { 87 out.println("<h2>-- /</h2>"); 88 NamingEnumeration ne = context.list("/"); 89 while (ne.hasMore()) 90 out.println("<br> " + ne.nextElement()); 91 out.println("<h2>-- java</h2>"); 92 ne = context.list("java:"); 93 while (ne.hasMore()) 94 out.println("<br> " + ne.nextElement()); 95 out.println("<h2>-- ejb</h2>"); 96 ne = context.list("ejb"); 97 while (ne.hasMore()) 98 out.println("<br> " + ne.nextElement()); 99 100 102 out.println("<h2>-- DS</h2>"); 103 DataSource ds = (DataSource)context.lookup("java:/OracleDS"); 104 out.println("<br> DataSource " + ds.getClass().getName() + " LoginTimeout=" + ds.getLoginTimeout()); 105 106 Connection con = ds.getConnection("compiere","compiere"); 107 out.println("<br> Connection "); 108 109 getServletContext().log("Connection closed=" + con.isClosed()); 110 DatabaseMetaData dbmd = con.getMetaData(); 111 getServletContext().log("DB " + dbmd.getDatabaseProductName()); 112 getServletContext().log("DB V " + dbmd.getDatabaseProductVersion()); 113 getServletContext().log("Driver " + dbmd.getDriverName()); 114 getServletContext().log("Driver V " + dbmd.getDriverVersion()); 115 getServletContext().log("JDBC " + dbmd.getJDBCMajorVersion()); 116 getServletContext().log("JDBC mV " + dbmd.getJDBCMinorVersion()); 117 118 getServletContext().log("User " + dbmd.getUserName()); 119 120 getServletContext().log("ANSI 92 " + dbmd.supportsANSI92FullSQL()); 121 getServletContext().log("Connection Alter Table ADD" + dbmd.supportsAlterTableWithAddColumn()); 122 getServletContext().log("Connection Alter Table DROP " + dbmd.supportsAlterTableWithDropColumn()); 123 getServletContext().log("Connection DDL&DML " + dbmd.supportsDataDefinitionAndDataManipulationTransactions()); 124 getServletContext().log("Connection CatalogsIn DML " + dbmd.supportsCatalogsInDataManipulation()); 125 getServletContext().log("Connection Schema In DML " + dbmd.supportsSchemasInDataManipulation()); 126 127 128 129 } 130 catch (Exception e) 131 { 132 out.println("<p><b>" + e + "</b></p>"); 133 } 134 135 136 out.println("</body></html>"); 137 } 138 public void doPut(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 140 { 141 doGet (request, response); 142 } 143 public void destroy() 145 { 146 getServletContext().log("StatusInfo.destroy"); 147 } 148 } | Popular Tags |