sqlrelaydatabasemetadata.java

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

     */
    public abstract boolean supportsUnion() throws SQLException {
    }
    
    /**
     *  Is SQL UNION ALL supported?
     *
     *  Returns:
     *  true if so
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean supportsUnionAll() throws SQLException {
    }
    
    /**
     *  Can cursors remain open across commits?
     *
     *  Returns:
     *  true if cursors always remain open;
     *  false if they might not remain open
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean supportsOpenCursorsAcrossCommit()
                                                    throws SQLException {
    }
    
    /**
     *  Can cursors remain open across rollbacks?
     *
     *  Returns:
     *  true if cursors always remain open;
     *  false if they might not remain open
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean supportsOpenCursorsAcrossRollback()
                                                    throws SQLException {
    }
    
    /**
     *  Can statements remain open across commits?
     *
     *  Returns:
     *  true if statements always remain open;
     *  false if they might not remain open
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean supportsOpenStatementsAcrossCommit()
                                                    throws SQLException {
    }
    
    /**
     *  Can statements remain open across rollbacks?
     *
     *  Returns:
     *  true if statements always remain open;
     *  false if they might not remain open
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     */
    public abstract boolean supportsOpenStatementsAcrossRollback()
                                                    throws SQLException {
    }
    
    /**
     *  How many hex characters can you have in an inline binary literal?
     *
     *  Returns:
     *  max literal length Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxBinaryLiteralLength() throws SQLException {
    }
    
    /**
     *  What's the max length for a character literal?
     *
     *  Returns:
     *  max literal length Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxCharLiteralLength() throws SQLException {
    }
    
    /**
     *  What's the limit on column name length?
     *
     * Returns:
     * max literal length Throws: SQLException
     * if a database-access error occurs.
     */
    public abstract int getMaxColumnNameLength() throws SQLException {
    }
    
    /**
     *  What's the maximum number of columns in a "GROUP BY" clause?
     *
     *  Returns:
     *  max number of columns Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxColumnsInGroupBy() throws SQLException {
    }
    
    /**
     *  What's the maximum number of columns allowed in an index?
     *
     *  Returns:
     *  max columns Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxColumnsInIndex() throws SQLException {
    }
    
    /**
     *  What's the maximum number of columns in an "ORDER BY" clause?
     *
     *  Returns:
     *  max columns Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxColumnsInOrderBy() throws SQLException {
    }
    
    /**
     *  What's the maximum number of columns in a "SELECT" list?
     *
     *  Returns:
     *  max columns Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxColumnsInSelect() throws SQLException {
    }
    
    /**
     *  What's the maximum number of columns in a table?
     *
     *  Returns:
     *  max columns Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxColumnsInTable() throws SQLException {
    }
    
    /**
     *  How many active connections can we have at a time to this database?
     *
     *  Returns:
     *  max connections Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxConnections() throws SQLException {
    }
    
    /**
     *  What's the maximum cursor name length?
     *
     *  Returns:
     *  max cursor name length in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxCursorNameLength() throws SQLException {
    }
    
    /**
     *  What's the maximum length of an index (in bytes)?
     *
     *  Returns:
     *  max index length in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxIndexLength() throws SQLException {
    }
    
    /**
     *  What's the maximum length allowed for a schema name?
     *
     *  Returns:
     *  max name length in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxSchemaNameLength() throws SQLException {
    }
    
    /**
     *  What's the maximum length of a procedure name?
     *
     *  Returns:
     *  max name length in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxProcedureNameLength() throws SQLException {
    }
    
    /**
     *  What's the maximum length of a catalog name?
     *
     *  Returns:
     *  max name length in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxCatalogNameLength() throws SQLException {
    }
    
    /**
     *  What's the maximum length of a single row?
     *
     *  Returns:
     *  max row size in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxRowSize() throws SQLException {
    }
    
    /**
     *  Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
     *
     *  Returns:
     *  true if so Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract boolean doesMaxRowSizeIncludeBlobs() throws SQLException {
    }
    
    /**
     *  What's the maximum length of a SQL statement?
     *
     *  Returns:
     *  max length in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxStatementLength() throws SQLException {
    }
    
    /**
     *  How many active statements can we have open at one time to this
     *  database?
     *
     *  Returns:
     *  the maximum Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxStatements() throws SQLException {
    }
    
    /**
     *  What's the maximum length of a table name?
     *
     *  Returns:
     *  max name length in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxTableNameLength() throws SQLException {
    }
    
    /**
     *  What's the maximum number of tables in a SELECT?
     *
     *  Returns:
     *  the maximum Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxTablesInSelect() throws SQLException {
    }
    
    /**
     *  What's the maximum length of a user name?
     *
     *  Returns:
     *  max name length in bytes Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract int getMaxUserNameLength() throws SQLException {
    }
    
    /**
     *  What's the database's default transaction isolation level? The values
     *  are defined in java.sql.Connection.
     *
     *  Returns:
     *  the default isolation level Throws: SQLException
     *  if a database-access error occurs. See Also: Connection
     */
    public abstract int getDefaultTransactionIsolation() throws SQLException {
    }
    
    /**
     *  Are transactions supported? If not, commit is a noop and the isolation
     *  level is TRANSACTION_NONE.
     *
     *  Returns:
     *  true if transactions are supported Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract boolean supportsTransactions() throws SQLException {
    }
    
    /**
     *  Does the database support the given transaction isolation level?
     *
     *  Parameters:
     *  level - the values are defined in java.sql.Connection Returns:
     *  true if so Throws: SQLException
     *  if a database-access error occurs. See Also:
     *  Connection
     */
    public abstract boolean supportsTransactionIsolationLevel(int level)
                                                        throws SQLException {
    }
    
    /**
     *  Are both data definition and data manipulation statements within a
     *  transaction supported?
     *
     *  Returns:
     *  true if so Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract
        boolean supportsDataDefinitionAndDataManipulationTransactions() 
                                                        throws SQLException {
    }
    
    /**
     *  Are only data manipulation statements within a transaction supported?
     *
     *  Returns:
     *  true if so Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract boolean supportsDataManipulationTransactionsOnly()
                                                        throws SQLException {
    }
    
    /**
     *  Does a data definition statement within a transaction force the
     *  transaction to commit?
     *
     *  Returns:
     *  true if so Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract boolean dataDefinitionCausesTransactionCommit()
                                                        throws SQLException {
    }
    
    /**
     *  Is a data definition statement within a transaction ignored?
     *
     *  Returns:
     *  true if so Throws: SQLException
     *  if a database-access error occurs.
     */
    public abstract boolean dataDefinitionIgnoredInTransactions()
                                                        throws SQLException {
    }
    
    /**
     *  Get a description of stored procedures available in a catalog.
     *
     *  Only procedure descriptions matching the schema and procedure name
     *  criteria are returned. They are ordered by PROCEDURE_SCHEM, and
     *  PROCEDURE_NAME.
     *
     *  Each procedure description has the the following columns:
     *
     *     1. PROCEDURE_CAT String => procedure catalog (may be null)
     *     2. PROCEDURE_SCHEM String => procedure schema (may be null)
     *     3. PROCEDURE_NAME String => procedure name
     *     4. reserved for future use
     *     5. reserved for future use
     *     6. reserved for future use
     *     7. REMARKS String => explanatory comment on the procedure
     *     8. PROCEDURE_TYPE short => kind of procedure:
     *            * procedureResultUnknown - May return a result
     *            * procedureNoResult - Does not return a result
     *            * procedureReturnsResult - Returns a result
     *
     *  Parameters:
     *  catalog - a catalog name;
     *      "" retrieves those without a catalog;
     *      null means drop catalog name from the selection criteria
     *  schemaPattern - a schema name pattern;
     *      "" retrieves those without a schema
     *  procedureNamePattern - a procedure name pattern
     *
     *  Returns:
     *  ResultSet - each row is a procedure description
     *
     *  Throws:
     *  SQLException if a database-access error occurs.
     *
     *  See Also:
     *  getSearchStringEscape
     */
    public abstract ResultSet getProcedures(String catalog,
                                             String schemaPattern,
                                             String procedureNamePattern)
                                                        throws SQLException {
    }
    
    
    /**
     *  Get a description of a catalog's stored procedure parameters and result
     *  columns.
     *
     *  Only descriptions matching the schema, procedure and parameter name 
     *  criteria are returned. They are ordered by PROCEDURE_SCHEM and 
     *  PROCEDURE_NAME. Within this, the return value, if any, is first. Next 
     *  are the parameter descriptions in call order. The column descriptions 
     *  follow in column number order.
     *
     *  Each row in the ResultSet is a parameter description or column 
     *  description with the following fields:
     *
     *     1. PROCEDURE_CAT String => procedure catalog (may be null)
     *     2. PROCEDURE_SCHEM String => procedure schema (may be null)
     *     3. PROCEDURE_NAME String => procedure name
     *     4. COLUMN_NAME String => column/parameter name
     *     5. COLUMN_TYPE Short => kind of column/parameter:
     *            * procedureColumnUnknown - nobody knows
     *            * procedureColumnIn - IN parameter
     *            * procedureColumnInOut - INOUT parameter
     *            * procedureColumnOut - OUT parameter
     *            * procedureColumnReturn - procedure return value
     *            * procedureColumnResult - result column in ResultSet
     *     6. DATA_TYPE short => SQL type from java.sql.Types
     *     7. TYPE_NAME String => SQL type name
     *     8. PRECISION int => precision
     *     9. LENGTH int => length in bytes of data