rdbmspropertyextractor.java

这是外国一个开源推理机

/*  Sesame - Storage and Querying architecture for RDF and RDF Schema
 *  Copyright (C) 2001-2005 Aduna
 *
 *  Contact: 
 *  	Aduna
 *  	Prinses Julianaplein 14 b
 *  	3817 CS Amersfoort
 *  	The Netherlands
 *  	tel. [phone]
 *  	fax. [phone]
 *
 *  	http://aduna.biz/
 *  	http://www.openrdf.org/
 *  
 *  This library is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU Lesser General Public
 *  License as published by the Free Software Foundation; either
 *  version 2.1 of the License, or (at your option) any later version.
 *
 *  This library is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *  Lesser General Public License for more details.
 *
 *  You should have received a copy of the GNU Lesser General Public
 *  License along with this library; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */

package org.openrdf.sesame.sailimpl.rdbms;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

/**
 * Utility class that extracts database properties from a JDBC-driver and prints
 * it to stdout. The printed properties are the properties that are available
 * through interface <tt>java.sql.DatabaseMetaData</tt>.
 *
 * @author Arjohn Kampman
 */
public class RdbmsPropertyExtractor {

	public static void main(String[] args)
		throws Exception
	{
		String jdbcDriver, jdbcUrl, user = null, password = null;

		jdbcDriver = args[0];
		jdbcUrl = args[1];

		if (args.length >= 3) {
			user = args[2];
		}
		if (args.length >= 4) {
			password = args[3];
		}

		Class.forName(jdbcDriver);
		Driver driver = DriverManager.getDriver(jdbcUrl);

		// Dump driver properties
		System.out.println();
		System.out.println("JDBC driver properties");
		System.out.println("======================");
		System.out.println("driver class  : " + jdbcDriver);
		System.out.println("version       : " + driver.getMajorVersion() + "." + driver.getMinorVersion());
		System.out.println("jdbc compliant: " + driver.jdbcCompliant());
		System.out.println();

		// Create connection and fetch meta data info
		Connection con;
		if (user == null) {
			con = DriverManager.getConnection(jdbcUrl);
		} else {
			con = DriverManager.getConnection(jdbcUrl, user, password);
		}

		DatabaseMetaData metaData = con.getMetaData();

		// Dump database properties
		System.out.println("Database properties");
		System.out.println("===================");
		System.out.println("Database major version                  : " + metaData.getDatabaseMajorVersion());
		System.out.println("Database minor version                  : " + metaData.getDatabaseMinorVersion());
		System.out.println("Database product name                   : " + metaData.getDatabaseProductName());
		System.out.println("Database product version                : " + metaData.getDatabaseProductVersion());
		System.out.println("Driver major version                    : " + metaData.getDriverMajorVersion());
		System.out.println("Driver minor version                    : " + metaData.getDriverMinorVersion());
		System.out.println("Driver name                             : " + metaData.getDriverName());
		System.out.println("Driver version                          : " + metaData.getDriverVersion());
		System.out.println("JDBC major version                      : " + metaData.getJDBCMajorVersion());
		System.out.println("JDBC minor version                      : " + metaData.getJDBCMinorVersion());
		System.out.println();
		System.out.println("Max binary literal length               : " + metaData.getMaxBinaryLiteralLength());
		System.out.println("Max catalog name length                 : " + metaData.getMaxCatalogNameLength());
		System.out.println("Max char literal length                 : " + metaData.getMaxCharLiteralLength());
		System.out.println("Max column name length                  : " + metaData.getMaxColumnNameLength());
		System.out.println("Max columns in table                    : " + metaData.getMaxColumnsInTable());
		System.out.println("Max columns in index                    : " + metaData.getMaxColumnsInIndex());
		System.out.println("Max columns in SELECT                   : " + metaData.getMaxColumnsInSelect());
		System.out.println("Max columns in GROUP BY                 : " + metaData.getMaxColumnsInGroupBy());
		System.out.println("Max columns in ORDER BY                 : " + metaData.getMaxColumnsInOrderBy());
		System.out.println("Max connections                         : " + metaData.getMaxConnections());
		System.out.println("Max cursor name length                  : " + metaData.getMaxCursorNameLength());
		System.out.println("Max index length                        : " + metaData.getMaxIndexLength());
		System.out.println("Max row size                            : " + metaData.getMaxRowSize());
		System.out.println("Max row size includes BLOBs             : " + metaData.doesMaxRowSizeIncludeBlobs());
		System.out.println("Max schema name length                  : " + metaData.getMaxSchemaNameLength());
		System.out.println("Max statement length                    : " + metaData.getMaxStatementLength());
		System.out.println("Max statements                          : " + metaData.getMaxStatements());
		System.out.println("Max table name length                   : " + metaData.getMaxTableNameLength());
		System.out.println("Max tables in SELECT                    : " + metaData.getMaxTablesInSelect());
		System.out.println("Max user name length                    : " + metaData.getMaxUserNameLength());
		System.out.println("Locators update copy                    : " + metaData.locatorsUpdateCopy());
		System.out.println();
		System.out.println("All procedures are callable             : " + metaData.allProceduresAreCallable());
		System.out.println("All tables are selectable               : " + metaData.allTablesAreSelectable());
		System.out.println();
		System.out.println("Extra name characters                   : " + metaData.getExtraNameCharacters());
		System.out.println("Identifier quote string                 : " + metaData.getIdentifierQuoteString());
		System.out.println("Search string escape                    : " + metaData.getSearchStringEscape());
		System.out.println("SQL keywords                            : " + metaData.getSQLKeywords());