001: /*
002: * $Header: /cvsroot/mvnforum/myvietnam/src/net/myvietnam/mvncore/info/DatabaseInfo.java,v 1.11 2007/01/15 10:31:13 dungbtm Exp $
003: * $Author: dungbtm $
004: * $Revision: 1.11 $
005: * $Date: 2007/01/15 10:31:13 $
006: *
007: * ====================================================================
008: *
009: * Copyright (C) 2002-2007 by MyVietnam.net
010: *
011: * All copyright notices regarding MyVietnam and MyVietnam CoreLib
012: * MUST remain intact in the scripts and source code.
013: *
014: * This library is free software; you can redistribute it and/or
015: * modify it under the terms of the GNU Lesser General Public
016: * License as published by the Free Software Foundation; either
017: * version 2.1 of the License, or (at your option) any later version.
018: *
019: * This library is distributed in the hope that it will be useful,
020: * but WITHOUT ANY WARRANTY; without even the implied warranty of
021: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
022: * Lesser General Public License for more details.
023: *
024: * You should have received a copy of the GNU Lesser General Public
025: * License along with this library; if not, write to the Free Software
026: * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
027: *
028: * Correspondence and Marketing Questions can be sent to:
029: * info at MyVietnam net
030: *
031: * @author: Minh Nguyen
032: * @author: Mai Nguyen
033: */
034: package net.myvietnam.mvncore.info;
035:
036: import java.sql.Connection;
037: import java.sql.DatabaseMetaData;
038:
039: import org.apache.commons.logging.Log;
040: import org.apache.commons.logging.LogFactory;
041: import net.myvietnam.mvncore.db.DBUtils;
042:
043: public class DatabaseInfo {
044:
045: private static Log log = LogFactory.getLog(DatabaseInfo.class);
046:
047: private String databaseProductName;
048: private String databaseProductVersion;
049: private String databaseUrl;
050: private String databaseUsername;
051: private String driverName;
052: private String driverVersion;
053:
054: private String errorMessage;
055:
056: public DatabaseInfo() {
057: Connection connection = null;
058: try {
059: connection = DBUtils.getConnection();
060: DatabaseMetaData dbmd = connection.getMetaData();
061: databaseUrl = dbmd.getURL();
062: databaseUsername = dbmd.getUserName();
063: databaseProductName = dbmd.getDatabaseProductName();
064: databaseProductVersion = dbmd.getDatabaseProductVersion();
065: driverName = dbmd.getDriverName();
066: driverVersion = dbmd.getDriverVersion();
067: } catch (Exception ex) {
068: log.error("Error when access database info", ex);
069: errorMessage = ex.getMessage();
070: } finally {
071: DBUtils.closeConnection(connection);
072: }
073: }
074:
075: public String getDatabaseProductName() {
076: return databaseProductName;
077: }
078:
079: public String getDatabaseProductVersion() {
080: return databaseProductVersion;
081: }
082:
083: public String getDatabaseUrl() {
084: return databaseUrl;
085: }
086:
087: public String getDatabaseUsername() {
088: return databaseUsername;
089: }
090:
091: public String getDriverName() {
092: return driverName;
093: }
094:
095: public String getDriverVersion() {
096: return driverVersion;
097: }
098:
099: public String getErrorMessage() {
100: return errorMessage;
101: }
102: }
|