simpletextdatabasemetadata.java

codebook!

    //-----------------------------------------------------------------------
    // getIdentifierQuoteString - JDBC API
    // What's the string used to quote SQL identifiers?
    // This returns a space " " if identifier quoting isn't supported.
    //
    // A JDBC compliant driver always uses a double quote character.
    //-----------------------------------------------------------------------

    public String getIdentifierQuoteString()
        throws SQLException
    {
        // The SimpleText driver does not support quoting

        return " ";
    }

    //-----------------------------------------------------------------------
    // getSQLKeywords - JDBC API
    // Get a comma separated list of all a database's SQL keywords
    // that are NOT also SQL92 keywords.
    //-----------------------------------------------------------------------

    public String getSQLKeywords()
        throws SQLException
    {
        return "";
    }

    //-----------------------------------------------------------------------
    // getNumericFunctions - JDBC API
    // Get a comma separated list of math functions.
    //-----------------------------------------------------------------------

    public String getNumericFunctions()
        throws SQLException
    {
        // The SimpleText driver does not support any math functions

        return "";
    }

    //-----------------------------------------------------------------------
    // getStringFunctions - JDBC API
    // Get a comma separated list of string functions.
    //-----------------------------------------------------------------------

    public String getStringFunctions()
        throws SQLException
    {
        // The SimpleText driver does not support any String functions

        return "";
    }

    //-----------------------------------------------------------------------
    // getSystemFunctions - JDBC API
    // Get a comma separated list of system functions.
    //-----------------------------------------------------------------------

    public String getSystemFunctions()
        throws SQLException
    {
        // The SimpleText driver does not support any System functions

        return "";
    }

    //-----------------------------------------------------------------------
    // getTimeDateFunctions - JDBC API
    // Get a comma separated list of time and date functions.
    //-----------------------------------------------------------------------

    public String getTimeDateFunctions()
        throws SQLException
    {
        // The SimpleText driver does not support any Time or Date functions

        return "";
    }

    //-----------------------------------------------------------------------
    // getSearchStringEscape - JDBC API
    // This is the string that can be used to escape '_' or '%' in
    // the string pattern style catalog search parameters.
    //
    // The '_' character represents any single character.
    // The '%' character represents any sequence of zero or
    // more characters.
    //-----------------------------------------------------------------------

    public String getSearchStringEscape()
        throws SQLException
    {
        // The SimpleText driver does not support search patterns, so
        // return an empty string

        return "";
    }

    //-----------------------------------------------------------------------
    // getExtraNameCharacters - JDBC API
    // Get all the "extra" characters that can be used in unquoted
    // identifier names (those beyond a-z, 0-9 and _).
    //-----------------------------------------------------------------------

    public String getExtraNameCharacters()
        throws SQLException
    {
        // The SimpleText driver does not allow any special characters
        // in indentifier names

        return "";
    }


    //-----------------------------------------------------------------------
    // supportsAlterTableWithAddColumn - JDBC API
    // Is "ALTER TABLE" with add column supported?
    //-----------------------------------------------------------------------

    public boolean supportsAlterTableWithAddColumn()
        throws SQLException
    {
        // The SimpleText driver does not support ALTER TABLE at all

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsAlterTableWithDropColumn - JDBC API
    // Is "ALTER TABLE" with drop column supported?
    //-----------------------------------------------------------------------

    public boolean supportsAlterTableWithDropColumn()
        throws SQLException
    {
        // The SimpleText driver does not support ALTER TABLE at all

        return false;
    }


    //-----------------------------------------------------------------------
    // supportsColumnAliasing - JDBC API
    // Is column aliasing supported?
    //
    // If so, the SQL AS clause can be used to provide names for
    // computed columns or to provide alias names for columns as
    // required.
    //
    // A JDBC compliant driver always returns true.
    //-----------------------------------------------------------------------

    public boolean supportsColumnAliasing()
        throws SQLException
    {
        // The SimpleText driver does not support column alias names

        return false;
    }

    //-----------------------------------------------------------------------
    // nullPlusNonNullIsNull - JDBC API
    // Are concatenations between NULL and non-NULL values NULL?
    //
    // A JDBC compliant driver always returns true.
    //-----------------------------------------------------------------------

    public boolean nullPlusNonNullIsNull()
        throws SQLException
    {
        // The SimpleText driver does not support nulls

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsConvert - JDBC API
    // Is the CONVERT function between SQL types supported?
    //-----------------------------------------------------------------------

    public boolean supportsConvert()
        throws SQLException
    {
        // The SimpleText driver does not support the CONVERT function

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsConvert - JDBC API
    // Is CONVERT between the given SQL types supported?
    //
    //    fromType    the type to convert from
    //    param        toType the type to convert to
    //-----------------------------------------------------------------------

    public boolean supportsConvert(
        int fromType,
        int toType)
        throws SQLException
    {
        // The SimpleText driver does not support the CONVERT function

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsTableCorrelationNames - JDBC API
    // Are table correlation names supported?
    //
    // A JDBC compliant driver always returns true.
    //-----------------------------------------------------------------------

    public boolean supportsTableCorrelationNames()
        throws SQLException
    {
        // The SimpleText driver does not support table correlation names

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsDifferentTableCorrelationNames - JDBC API
    // If table correlation names are supported, are they restricted
    // to be different from the names of the tables?
    //
    // A JDBC compliant driver always returns true.
    //-----------------------------------------------------------------------

    public boolean supportsDifferentTableCorrelationNames()
        throws SQLException
    {
        // The SimpleText driver does not support table correlation names

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsExpressionsInOrderBy - JDBC API
    // Are expressions in "ORDER BY" lists supported?
    //-----------------------------------------------------------------------

    public boolean supportsExpressionsInOrderBy()
        throws SQLException
    {
        // The SimpleText driver does not support ORDER BY

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsOrderByUnrelated - JDBC API
    // Can an "ORDER BY" clause use columns not in the SELECT?
    //-----------------------------------------------------------------------

    public boolean supportsOrderByUnrelated()
        throws SQLException
    {
        // The SimpleText driver does not support ORDER BY

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsGroupBy - JDBC API
    // Is some form of "GROUP BY" clause supported?
    //-----------------------------------------------------------------------

    public boolean supportsGroupBy()
        throws SQLException
    {
        // The SimpleText driver does not support GROUP BY

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsGroupByUnrelated - JDBC API
    // Can a "GROUP BY" clause use columns not in the SELECT?
    //-----------------------------------------------------------------------

    public boolean supportsGroupByUnrelated()
        throws SQLException
    {
        // The SimpleText driver does not support GROUP BY

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsGroupByBeyondSelect - JDBC API
    // Can a "GROUP BY" clause add columns not in the SELECT
    // provided it specifies all the columns in the SELECT?
    //-----------------------------------------------------------------------

    public boolean supportsGroupByBeyondSelect()
        throws SQLException
    {
        // The SimpleText driver does not support GROUP BY

        return false;
    }


    //-----------------------------------------------------------------------
    // supportsLikeEscapeClause - JDBC API
    // Is the escape character in "LIKE" clauses supported?
    //
    // A JDBC compliant driver always returns true.
    //-----------------------------------------------------------------------

    public boolean supportsLikeEscapeClause()
        throws SQLException
    {
        // The SimpleText driver does not support the LIKE clause

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsMultipleResultSets - JDBC API
    // Are multiple ResultSets from a single execute supported?
    //-----------------------------------------------------------------------

    public boolean supportsMultipleResultSets()
        throws SQLException
    {
        // The SimpleText driver does not support multiple result sets

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsMultipleTransactions - JDBC API
    // Can we have multiple transactions open at once (on different
    // connections)?
    //-----------------------------------------------------------------------

    public boolean supportsMultipleTransactions()
        throws SQLException
    {
        // The SimpleText driver does not support transactions

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsNonNullableColumns - JDBC API
    // Can columns be defined as non-nullable?
    //
    // A JDBC compliant driver always returns true.
    //-----------------------------------------------------------------------

    public boolean supportsNonNullableColumns()
        throws SQLException
    {
        // The SimpleText driver does not support nulls, so all columns by
        // default are non-nullable.  This, however, specifies whether the
        // column can be defined as NON NULL in the DDL (Data Definition
        // Language) statement, which is not supported.

        return false;
    }

    //-----------------------------------------------------------------------
    // supportsMinimumSQLGrammar - JDBC API
    // Is the ODBC Minimum SQL grammar supported?
    //
    // All JDBC compliant drivers must return true.
    //-----------------------------------------------------------------------

    public boolean supportsMinimumSQLGrammar()
        throws SQLException
    {
        // The SimpleText driver does not even support the most minimum
        // SQL grammar