Skip to content

Instantly share code, notes, and snippets.

@alwold

alwold/jdbcinfo.jsp

Created April 9, 2010 22:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alwold/361633 to your computer and use it in GitHub Desktop.
Save alwold/361633 to your computer and use it in GitHub Desktop.
Download ZIP
jsp to get tomcat data source info
Raw
jdbcinfo.jsp
<%@page import="javax.naming.InitialContext"%>
<%@page import="javax.naming.Context"%>
<%@page import="javax.naming.NamingEnumeration"%>
<%@page import="javax.naming.NameClassPair"%>
<%@page import="org.apache.tomcat.dbcp.dbcp.BasicDataSource"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Driver"%>
<%@page import="java.util.Enumeration"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<body>
<h1>Connections</h1>
<ul>
<%
InitialContext ic = new InitialContext();
NamingEnumeration<NameClassPair> ne = ic.list("java:comp/env/jdbc");
while (ne.hasMore()) {
NameClassPair ncp = ne.next();
Object o = ic.lookup("java:comp/env/jdbc/"+ncp.getName());
if (o instanceof BasicDataSource) {
BasicDataSource ds = (BasicDataSource) o;
out.println("<li>"+ncp.getName()+"</li><ul>");
out.println("<li>"+ds.getUrl()+"</li>");
out.println("<li>"+ds.getUsername()+"</li>");
out.println("<li>"+ds.getPassword()+"</li>");
out.println("</ul>");
} else {
out.println("<li>found odd object "+ncp.getName()+" of type "+o.getClass().getName());
}
}
%>
</ul>
<h1>Drivers</h1>
<%
for (Enumeration<Driver> d = DriverManager.getDrivers(); d.hasMoreElements(); ) {
Driver driver = d.nextElement();
out.println("<ul>");
out.println("<li>"+driver.getClass().getName()+"</li>");
out.println("<li>major = "+driver.getMajorVersion()+"</li>");
out.println("<li>minor = "+driver.getMinorVersion()+"</li>");
}
%>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment