<%-- - $RCSfile$ - $Revision$ - $Date$ - - Copyright (C) 2004 Jive Software. All rights reserved. - - This software is published under the terms of the GNU Public License (GPL), - a copy of which is included in this distribution. --%> <%@ page import="org.jivesoftware.util.*, org.jivesoftware.database.DbConnectionManager, org.jivesoftware.admin.AdminPageBean, java.sql.*" errorPage="error.jsp" %> <%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c" %> <%@ taglib uri="http://java.sun.com/jstl/fmt_rt" prefix="fmt" %> <jsp:useBean id="pageinfo" scope="request" class="org.jivesoftware.admin.AdminPageBean" /> <%-- Define Administration Bean --%> <jsp:useBean id="admin" class="org.jivesoftware.util.WebManager" /> <% admin.init(request, response, session, application, out ); %> <% // Title of this page and breadcrumbs String title = LocaleUtils.getLocalizedString("server.db.title"); pageinfo.setTitle(title); pageinfo.getBreadcrumbs().add(new AdminPageBean.Breadcrumb(LocaleUtils.getLocalizedString("global.main"), "index.jsp")); pageinfo.getBreadcrumbs().add(new AdminPageBean.Breadcrumb(title, "server-db.jsp")); pageinfo.setPageID("server-db"); %> <jsp:include page="top.jsp" flush="true" /> <jsp:include page="title.jsp" flush="true" /> <% // Get metadata about the database Connection con = null; try { con = DbConnectionManager.getConnection(); DatabaseMetaData metaData = con.getMetaData(); %> <p> <fmt:message key="server.db.info" /> </p> <div class="jive-table"> <table cellpadding="0" cellspacing="0" border="0" width="100%"> <thead> <tr> <th colspan="2"><fmt:message key="server.db.connect_info" /></th> </tr> </thead> <tbody> <tr> <td class="c1"> <fmt:message key="server.db.version" /> </td> <td class="c2"> <%= metaData.getDatabaseProductName() %> <%= metaData.getDatabaseProductVersion() %> </td> </tr> <tr> <td class="c1"> <fmt:message key="server.db.jdbc" /> </td> <td class="c2"> <%= metaData.getDriverName() %> </td> </tr> <tr> <td class="c1"> <fmt:message key="server.db.jdbc_driver" /> </td> <td class="c2"> <%= metaData.getDriverVersion() %> </td> </tr> <tr> <td class="c1"> <fmt:message key="server.db.connect_url" /> </td> <td class="c2"> <%= metaData.getURL() %> </td> </tr> <tr> <td class="c1"> <fmt:message key="server.db.user" /> </td> <td class="c2"> <%= metaData.getUserName() %> </td> </tr> <tr> <td class="c1"> <fmt:message key="server.db.transaction" /> </td> <td class="c2"> <%= (metaData.supportsTransactions()) ? "Yes" : "No" %> </td> </tr> <% if (metaData.supportsTransactions()) { %> <tr> <td class="c1"> <fmt:message key="server.db.transaction_level" /> </td> <td class="c2"> <% if (con.getTransactionIsolation() == Connection.TRANSACTION_NONE) { %> TRANSACTION_NONE <% } else if (con.getTransactionIsolation() == Connection.TRANSACTION_READ_COMMITTED) { %> TRANSACTION_READ_COMMITTED <% } else if (con.getTransactionIsolation() == Connection.TRANSACTION_READ_UNCOMMITTED) { %> TRANSACTION_READ_UNCOMMITTED <% } else if (con.getTransactionIsolation() == Connection.TRANSACTION_REPEATABLE_READ) { %> TRANSACTION_REPEATABLE_READ <% } else if (con.getTransactionIsolation() == Connection.TRANSACTION_SERIALIZABLE) { %> TRANSACTION_SERIALIZABLE <% } %> </td> </tr> <% } %> <tr> <td class="c1"> <fmt:message key="server.db.multiple_connect" /><br> <fmt:message key="server.db.multiple_connect2" /> </td> <td class="c2"> <%= (metaData.supportsMultipleTransactions()) ? "Yes" : "No" %> </td> </tr> <tr> <td class="c1"> <fmt:message key="server.db.read_only_mode" /> </td> <td class="c2"> <%= (metaData.isReadOnly()) ? "Yes" : "No" %> </td> </tr> </tbody> </table> </div> <% } finally { try { if (con != null) { con.close(); } } catch (SQLException e) { Log.error(e); } } %> <jsp:include page="bottom.jsp" flush="true" />