sqlrelaydatabasemetadata.java

适合于Unix/Linux下的一个持久数据库连接池

package com.firstworks.sql;
    
import java.sql;
    
public class SQLRelayDatabaseMetaData implements java.sql.DatabaseMetaData {
    
    /** 
     *  PROCEDURE_TYPE - May return a result.
     */
    public static final int procedureResultUnknown
    
    /**
     *  PROCEDURE_TYPE - Does not return a result.
     */
    public static final int procedureNoResult
    
    /**
     *  PROCEDURE_TYPE - Returns a result.
     */
    public static final int procedureReturnsResult
    
    /**
     *  COLUMN_TYPE - nobody knows.
     */
    public static final int procedureColumnUnknown
    
    /**
     *  COLUMN_TYPE - IN parameter.
     */
    public static final int procedureColumnIn
    
    
    /**
     *  COLUMN_TYPE - INOUT parameter.
     */
    public static final int procedureColumnInOut
    
    /**
     *  COLUMN_TYPE - OUT parameter.
     */
    public static final int procedureColumnOut
    
    /**
     *  COLUMN_TYPE - procedure return value.
     */
    public static final int procedureColumnReturn
    
    /**
     *  COLUMN_TYPE - result column in ResultSet.
     */
    public static final int procedureColumnResult
    
    /**
     *  TYPE NULLABLE - does not allow NULL values.
     */
    public static final int procedureNoNulls
    
    /**
     *  TYPE NULLABLE - allows NULL values.
     */
    public static final int procedureNullable
    
    /**
     *  TYPE NULLABLE - nullability unknown.
     */
    public static final int procedureNullableUnknown
    
    /**
     *  COLUMN NULLABLE - might not allow NULL values.
     */
    public static final int columnNoNulls
    
    /**
     *  COLUMN NULLABLE - definitely allows NULL values.
     */
    public static final int columnNullable
    
    /**
     *  COLUMN NULLABLE - nullability unknown.
     */
    public static final int columnNullableUnknown
    
    /**
     *  BEST ROW SCOPE - very temporary, while using row.
     */
    public static final int bestRowTemporary
    
    /**
     *  BEST ROW SCOPE - valid for remainder of current transaction.
     */
    public static final int bestRowTransaction
    
    /**
     *  BEST ROW SCOPE - valid for remainder of current session.
     */
    public static final int bestRowSession
    
    /**
     *  BEST ROW PSEUDO_COLUMN - may or may not be pseudo column.
     */
    public static final int bestRowUnknown
    
    /**
     *  BEST ROW PSEUDO_COLUMN - is NOT a pseudo column.
     */
    public static final int bestRowNotPseudo
    
    /**
     *  BEST ROW PSEUDO_COLUMN - is a pseudo column.
     */
    public static final int bestRowPseudo
    
    /**
     *  VERSION COLUMNS PSEUDO_COLUMN - may or may not be pseudo column.
     */
    public static final int versionColumnUnknown
    
    /**
     *  VERSION COLUMNS PSEUDO_COLUMN - is NOT a pseudo column.
     */
    public static final int versionColumnNotPseudo
    
    /**
     *  VERSION COLUMNS PSEUDO_COLUMN - is a pseudo column.
     */
    public static final int versionColumnPseudo
    
    /**
     *  IMPORT KEY UPDATE_RULE and DELETE_RULE - for update, change imported
     *  key to agree with primary key update; for delete, delete rows that
     *  import a deleted key.
     */
    public static final int importedKeyCascade
    
    /**
     *  IMPORT KEY UPDATE_RULE and DELETE_RULE - do not allow update or delete
     *  of primary key if it has been imported.
     */
    public static final int importedKeyRestrict
    
    /**
     *  IMPORT KEY UPDATE_RULE and DELETE_RULE - change imported key to NULL if 
     *  its primary key has been updated or deleted.
     */
    public static final int importedKeySetNull
    
    /**
     *  IMPORT KEY UPDATE_RULE and DELETE_RULE - do not allow update or delete
     *  of primary key if it has been imported.
     */
    public static final int importedKeyNoAction
    
    /**
     *  IMPORT KEY UPDATE_RULE and DELETE_RULE - change imported key to default 
     *  values if its primary key has been updated or deleted.
     */
    public static final int importedKeySetDefault
    
    /**
     *  IMPORT KEY DEFERRABILITY - see SQL92 for definition
     */
    public static final int importedKeyInitiallyDeferred
    
    /**
     *  IMPORT KEY DEFERRABILITY - see SQL92 for definition
     */
    public static final int importedKeyInitiallyImmediate
    
    /**
     *  IMPORT KEY DEFERRABILITY - see SQL92 for definition
     */
    public static final int importedKeyNotDeferrable
    
    /**
     *  TYPE NULLABLE - does not allow NULL values.
     */
    public static final int typeNoNulls
    
    /**
     *  TYPE NULLABLE - allows NULL values.
     */
    public static final int typeNullable
    
    /**
     *  TYPE NULLABLE - nullability unknown.
     */
    public static final int typeNullableUnknown
    
    /**
     *  TYPE INFO SEARCHABLE - No support.
     */
    public static final int typePredNone
    
    /**
     *  TYPE INFO SEARCHABLE - Only supported with WHERE .. LIKE.
     */
    public static final int typePredChar
    
    /**
     *  TYPE INFO SEARCHABLE - Supported except for WHERE .. LIKE.
     */
    public static final int typePredBasic
    
    /**
     *  TYPE INFO SEARCHABLE - Supported for all WHERE ...
     */
    public static final int typeSearchable
    
    /**
     *  INDEX INFO TYPE - this identifies table statistics that are returned in 
     *  conjuction with a table's index descriptions
     */
    public static final short tableIndexStatistic
    
    /**
     *  INDEX INFO TYPE - this identifies a clustered index
     */
    public static final short tableIndexClustered
    
    /**
     *  INDEX INFO TYPE - this identifies a hashed index
     */
    public static final short tableIndexHashed
    
    /**
     *  INDEX INFO TYPE - this identifies some other form of index
     */
    public static final short tableIndexOther
    
    
    
    
    /**
     *  Can all the procedures returned by getProcedures be called by the
     *  current user?
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean allProceduresAreCallable() throws SQLException {
    }
    
    /**
     *  Can all the tables returned by getTable be SELECTed by the current
     *  user?  
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean allTablesAreSelectable() throws SQLException {
    }
    
    /**
     *  What's the url for this database?
     *
     *  Returns:
     *  the url or null if it can't be generated
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract String getURL() throws SQLException {
    }
    
    /**
     *  What's our user name as known to the database?
     *
     *  Returns:
     *  our database user name
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract String getUserName() throws SQLException {
    }
    
    /**
     *  Is the database in read-only mode?
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean isReadOnly() throws SQLException {
    }
    
    /**
     *  Are NULL values sorted high?
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean nullsAreSortedHigh() throws SQLException {
    }
    
    /**
     *  Are NULL values sorted low?
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean nullsAreSortedLow() throws SQLException {
    }
    
    /**
     *
     *  Are NULL values sorted at the start regardless of sort order?
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean nullsAreSortedAtStart() throws SQLException {
    }
    
    /**
     *  Are NULL values sorted at the end regardless of sort order?
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean nullsAreSortedAtEnd() throws SQLException {
    }
    
    /**
     *  What's the name of this database product?
     *
     *  Returns:
     *  database product name
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract String getDatabaseProductName() throws SQLException {
    }
    
    /**
     *  What's the version of this database product?
     *
     *  Returns:
     *  database version
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract String getDatabaseProductVersion() throws SQLException {
    }
    
    /**
     *  What's the name of this JDBC driver?
     *
     *  Returns:
     *  JDBC driver name
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract String getDriverName() throws SQLException {
    }
    
    
    /**
     * What's the version of this JDBC driver?
     *
     * Returns:
     *  JDBC driver version
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract String getDriverVersion() throws SQLException {
    }
    
    /**
     *  What's this JDBC driver's major version number?
     *
     *  Returns:
     *  JDBC driver major version
     */
    public abstract int getDriverMajorVersion() {
    }
    
    /**
     *  What's this JDBC driver's minor version number?
     *
     *  Returns:
     *  JDBC driver minor version
     */
    public abstract int getDriverMinorVersion() {
    }
    
    /**
     *  Does the database store tables in a local file?
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean usesLocalFiles() throws SQLException {
    }
    
    /**
     *  Does the database use a file for each table?
     *
     *  Returns:
     *  true if the database uses a local file for each table
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean usesLocalFilePerTable() throws SQLException {
    }
    
    /**
     *  Does the database treat mixed case unquoted SQL identifiers as case 
     *  sensitive and as a result store them in mixed case? A JDBC-Compliant
     *  driver will always return false.