Class SQLite4JDatabaseMetaData

    • Constructor Detail

      • SQLite4JDatabaseMetaData

        public SQLite4JDatabaseMetaData​(SQLite4JConnection con,
                                        java.sql.DatabaseMetaData metadata)
    • Method Detail

      • allProceduresAreCallable

        public boolean allProceduresAreCallable()
                                         throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not all the procedures returned by the getProcedures method can be called by this user.
        Specified by:
        allProceduresAreCallable in interface DatabaseMetaData
        Returns:
        true if all the procedures can be called, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • allTablesAreSelectable

        public boolean allTablesAreSelectable()
                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not all the table returned by the getTables method can be selected by this user.
        Specified by:
        allTablesAreSelectable in interface DatabaseMetaData
        Returns:
        true if all the procedures can be called, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getURL

        public java.lang.String getURL()
                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the URL for this database.
        Specified by:
        getURL in interface DatabaseMetaData
        Returns:
        The URL string for this database, or null if it is not known.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getUserName

        public java.lang.String getUserName()
                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the database username for this connection.
        Specified by:
        getUserName in interface DatabaseMetaData
        Returns:
        The database username.
        Throws:
        java.sql.SQLException - If an error occurs.
      • isReadOnly

        public boolean isReadOnly()
                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database is in read only mode.
        Specified by:
        isReadOnly in interface DatabaseMetaData
        Returns:
        true if the database is in read only mode, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • nullsAreSortedHigh

        public boolean nullsAreSortedHigh()
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not NULL's sort as high values.
        Specified by:
        nullsAreSortedHigh in interface DatabaseMetaData
        Returns:
        true if NULL's sort as high values, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • nullsAreSortedLow

        public boolean nullsAreSortedLow()
                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not NULL's sort as low values.
        Specified by:
        nullsAreSortedLow in interface DatabaseMetaData
        Returns:
        true if NULL's sort as low values, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • nullsAreSortedAtStart

        public boolean nullsAreSortedAtStart()
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not NULL's sort as high values.
        Specified by:
        nullsAreSortedAtStart in interface DatabaseMetaData
        Returns:
        true if NULL's sort as high values, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • nullsAreSortedAtEnd

        public boolean nullsAreSortedAtEnd()
                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method test whether or not NULL's are sorted to the end of the list regardless of ascending or descending sort order.
        Specified by:
        nullsAreSortedAtEnd in interface DatabaseMetaData
        Returns:
        true if NULL's always sort to the end, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getDatabaseProductName

        public java.lang.String getDatabaseProductName()
                                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the name of the database product.
        Specified by:
        getDatabaseProductName in interface DatabaseMetaData
        Returns:
        The database product.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getDatabaseProductVersion

        public java.lang.String getDatabaseProductVersion()
                                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the version of the database product.
        Specified by:
        getDatabaseProductVersion in interface DatabaseMetaData
        Returns:
        The version of the database product.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getDriverName

        public java.lang.String getDriverName()
                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the name of the JDBC driver.
        Specified by:
        getDriverName in interface DatabaseMetaData
        Returns:
        The name of the JDBC driver.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getDriverVersion

        public java.lang.String getDriverVersion()
                                          throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the version of the JDBC driver.
        Specified by:
        getDriverVersion in interface DatabaseMetaData
        Returns:
        The version of the JDBC driver.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getDriverMajorVersion

        public int getDriverMajorVersion()
        Description copied from interface: DatabaseMetaData
        This method returns the major version number of the JDBC driver.
        Specified by:
        getDriverMajorVersion in interface DatabaseMetaData
        Returns:
        The major version number of the JDBC driver.
      • getDriverMinorVersion

        public int getDriverMinorVersion()
        Description copied from interface: DatabaseMetaData
        This method returns the minor version number of the JDBC driver.
        Specified by:
        getDriverMinorVersion in interface DatabaseMetaData
        Returns:
        The minor version number of the JDBC driver.
      • usesLocalFiles

        public boolean usesLocalFiles()
                               throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database uses local files to store tables.
        Specified by:
        usesLocalFiles in interface DatabaseMetaData
        Returns:
        true if the database uses local files, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • usesLocalFilePerTable

        public boolean usesLocalFilePerTable()
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database uses a separate file for each table.
        Specified by:
        usesLocalFilePerTable in interface DatabaseMetaData
        Returns:
        true if the database uses a separate file for each table false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsMixedCaseIdentifiers

        public boolean supportsMixedCaseIdentifiers()
                                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports identifiers with mixed case.
        Specified by:
        supportsMixedCaseIdentifiers in interface DatabaseMetaData
        Returns:
        true if the database supports mixed case identifiers, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • storesUpperCaseIdentifiers

        public boolean storesUpperCaseIdentifiers()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database treats mixed case identifiers as all upper case.
        Specified by:
        storesUpperCaseIdentifiers in interface DatabaseMetaData
        Returns:
        true if the database treats all identifiers as upper case, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • storesLowerCaseIdentifiers

        public boolean storesLowerCaseIdentifiers()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database treats mixed case identifiers as all lower case.
        Specified by:
        storesLowerCaseIdentifiers in interface DatabaseMetaData
        Returns:
        true if the database treats all identifiers as lower case, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • storesMixedCaseIdentifiers

        public boolean storesMixedCaseIdentifiers()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database stores mixed case identifers even if it treats them as case insensitive.
        Specified by:
        storesMixedCaseIdentifiers in interface DatabaseMetaData
        Returns:
        true if the database stores mixed case identifiers, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsMixedCaseQuotedIdentifiers

        public boolean supportsMixedCaseQuotedIdentifiers()
                                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports quoted identifiers with mixed case.
        Specified by:
        supportsMixedCaseQuotedIdentifiers in interface DatabaseMetaData
        Returns:
        true if the database supports mixed case quoted identifiers, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • storesUpperCaseQuotedIdentifiers

        public boolean storesUpperCaseQuotedIdentifiers()
                                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database treats mixed case quoted identifiers as all upper case.
        Specified by:
        storesUpperCaseQuotedIdentifiers in interface DatabaseMetaData
        Returns:
        true if the database treats all quoted identifiers as upper case, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • storesLowerCaseQuotedIdentifiers

        public boolean storesLowerCaseQuotedIdentifiers()
                                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database treats mixed case quoted identifiers as all lower case.
        Specified by:
        storesLowerCaseQuotedIdentifiers in interface DatabaseMetaData
        Returns:
        true if the database treats all quoted identifiers as lower case, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • storesMixedCaseQuotedIdentifiers

        public boolean storesMixedCaseQuotedIdentifiers()
                                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database stores mixed case quoted identifers even if it treats them as case insensitive.
        Specified by:
        storesMixedCaseQuotedIdentifiers in interface DatabaseMetaData
        Returns:
        true if the database stores mixed case quoted identifiers, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getIdentifierQuoteString

        public java.lang.String getIdentifierQuoteString()
                                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This metohd returns the quote string for SQL identifiers.
        Specified by:
        getIdentifierQuoteString in interface DatabaseMetaData
        Returns:
        The quote string for SQL identifers, or a space if quoting is not supported.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getSQLKeywords

        public java.lang.String getSQLKeywords()
                                        throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a comma separated list of all the SQL keywords in the database that are not in SQL92.
        Specified by:
        getSQLKeywords in interface DatabaseMetaData
        Returns:
        The list of SQL keywords not in SQL92.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getNumericFunctions

        public java.lang.String getNumericFunctions()
                                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a comma separated list of math functions.
        Specified by:
        getNumericFunctions in interface DatabaseMetaData
        Returns:
        The list of math functions.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getStringFunctions

        public java.lang.String getStringFunctions()
                                            throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a comma separated list of string functions.
        Specified by:
        getStringFunctions in interface DatabaseMetaData
        Returns:
        The list of string functions.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getSystemFunctions

        public java.lang.String getSystemFunctions()
                                            throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a comma separated list of of system functions.
        Specified by:
        getSystemFunctions in interface DatabaseMetaData
        Returns:
        A comma separated list of system functions.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getTimeDateFunctions

        public java.lang.String getTimeDateFunctions()
                                              throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns comma separated list of time/date functions.
        Specified by:
        getTimeDateFunctions in interface DatabaseMetaData
        Returns:
        The list of time/date functions.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getSearchStringEscape

        public java.lang.String getSearchStringEscape()
                                               throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the string used to escape wildcards in search strings.
        Specified by:
        getSearchStringEscape in interface DatabaseMetaData
        Returns:
        The string used to escape wildcards in search strings.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getExtraNameCharacters

        public java.lang.String getExtraNameCharacters()
                                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This methods returns non-standard characters that can appear in unquoted identifiers.
        Specified by:
        getExtraNameCharacters in interface DatabaseMetaData
        Returns:
        Non-standard characters that can appear in unquoted identifiers.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsAlterTableWithAddColumn

        public boolean supportsAlterTableWithAddColumn()
                                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports "ALTER TABLE ADD COLUMN"
        Specified by:
        supportsAlterTableWithAddColumn in interface DatabaseMetaData
        Returns:
        true if column add supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsAlterTableWithDropColumn

        public boolean supportsAlterTableWithDropColumn()
                                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports "ALTER TABLE DROP COLUMN"
        Specified by:
        supportsAlterTableWithDropColumn in interface DatabaseMetaData
        Returns:
        true if column drop supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsColumnAliasing

        public boolean supportsColumnAliasing()
                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not column aliasing is supported.
        Specified by:
        supportsColumnAliasing in interface DatabaseMetaData
        Returns:
        true if column aliasing is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • nullPlusNonNullIsNull

        public boolean nullPlusNonNullIsNull()
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether the concatenation of a NULL and non-NULL value results in a NULL. This will always be true in fully JDBC compliant drivers.
        Specified by:
        nullPlusNonNullIsNull in interface DatabaseMetaData
        Returns:
        true if concatenating NULL and a non-NULL value returns a NULL, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsConvert

        public boolean supportsConvert()
                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        Tests whether or not CONVERT is supported.
        Specified by:
        supportsConvert in interface DatabaseMetaData
        Returns:
        true if CONVERT is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsConvert

        public boolean supportsConvert​(int fromType,
                                       int toType)
                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not CONVERT can be performed between the specified types. The types are contants from Types.
        Specified by:
        supportsConvert in interface DatabaseMetaData
        Parameters:
        fromType - The SQL type to convert from.
        toType - The SQL type to convert to.
        Returns:
        true if the conversion can be performed, false otherwise.
        Throws:
        java.sql.SQLException
        See Also:
        Types
      • supportsTableCorrelationNames

        public boolean supportsTableCorrelationNames()
                                              throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not table correlation names are supported. This will be always be true in a fully JDBC compliant driver.
        Specified by:
        supportsTableCorrelationNames in interface DatabaseMetaData
        Returns:
        true if table correlation names are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsDifferentTableCorrelationNames

        public boolean supportsDifferentTableCorrelationNames()
                                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether correlation names must be different from the name of the table.
        Specified by:
        supportsDifferentTableCorrelationNames in interface DatabaseMetaData
        Returns:
        true if the correlation name must be different from the table name, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsExpressionsInOrderBy

        public boolean supportsExpressionsInOrderBy()
                                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not expressions are allowed in an ORDER BY lists.
        Specified by:
        supportsExpressionsInOrderBy in interface DatabaseMetaData
        Returns:
        true if expressions are allowed in ORDER BY lists, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsOrderByUnrelated

        public boolean supportsOrderByUnrelated()
                                         throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or ORDER BY on a non-selected column is allowed.
        Specified by:
        supportsOrderByUnrelated in interface DatabaseMetaData
        Returns:
        true if a non-selected column can be used in an ORDER BY, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsGroupBy

        public boolean supportsGroupBy()
                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not GROUP BY is supported.
        Specified by:
        supportsGroupBy in interface DatabaseMetaData
        Returns:
        true if GROUP BY is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsGroupByUnrelated

        public boolean supportsGroupByUnrelated()
                                         throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether GROUP BY on a non-selected column is allowed.
        Specified by:
        supportsGroupByUnrelated in interface DatabaseMetaData
        Returns:
        true if a non-selected column can be used in a GROUP BY, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsGroupByBeyondSelect

        public boolean supportsGroupByBeyondSelect()
                                            throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not a GROUP BY can add columns not in the select if it includes all the columns in the select.
        Specified by:
        supportsGroupByBeyondSelect in interface DatabaseMetaData
        Returns:
        true if GROUP BY an add columns provided it includes all columns in the select, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsLikeEscapeClause

        public boolean supportsLikeEscapeClause()
                                         throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the escape character is supported in LIKE expressions. A fully JDBC compliant driver will always return true.
        Specified by:
        supportsLikeEscapeClause in interface DatabaseMetaData
        Returns:
        true if escapes are supported in LIKE expressions, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsMultipleResultSets

        public boolean supportsMultipleResultSets()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether multiple result sets for a single statement are supported.
        Specified by:
        supportsMultipleResultSets in interface DatabaseMetaData
        Returns:
        true if multiple result sets are supported for a single statement, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsMultipleTransactions

        public boolean supportsMultipleTransactions()
                                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method test whether or not multiple transactions may be open at once, as long as they are on different connections.
        Specified by:
        supportsMultipleTransactions in interface DatabaseMetaData
        Returns:
        true if multiple transactions on different connections are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsNonNullableColumns

        public boolean supportsNonNullableColumns()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not columns can be defined as NOT NULL. A fully JDBC compliant driver always returns true.
        Specified by:
        supportsNonNullableColumns in interface DatabaseMetaData
        Returns:
        true if NOT NULL columns are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsMinimumSQLGrammar

        public boolean supportsMinimumSQLGrammar()
                                          throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the minimum grammer for ODBC is supported. A fully JDBC compliant driver will always return true.
        Specified by:
        supportsMinimumSQLGrammar in interface DatabaseMetaData
        Returns:
        true if the ODBC minimum grammar is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsCoreSQLGrammar

        public boolean supportsCoreSQLGrammar()
                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the core grammer for ODBC is supported.
        Specified by:
        supportsCoreSQLGrammar in interface DatabaseMetaData
        Returns:
        true if the ODBC core grammar is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsExtendedSQLGrammar

        public boolean supportsExtendedSQLGrammar()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the extended grammer for ODBC is supported.
        Specified by:
        supportsExtendedSQLGrammar in interface DatabaseMetaData
        Returns:
        true if the ODBC extended grammar is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsANSI92EntryLevelSQL

        public boolean supportsANSI92EntryLevelSQL()
                                            throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the ANSI92 entry level SQL grammar is supported. A fully JDBC compliant drivers must return true.
        Specified by:
        supportsANSI92EntryLevelSQL in interface DatabaseMetaData
        Returns:
        true if the ANSI92 entry level SQL grammar is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsANSI92IntermediateSQL

        public boolean supportsANSI92IntermediateSQL()
                                              throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the ANSI92 intermediate SQL grammar is supported.
        Specified by:
        supportsANSI92IntermediateSQL in interface DatabaseMetaData
        Returns:
        true if the ANSI92 intermediate SQL grammar is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsANSI92FullSQL

        public boolean supportsANSI92FullSQL()
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the ANSI92 full SQL grammar is supported.
        Specified by:
        supportsANSI92FullSQL in interface DatabaseMetaData
        Returns:
        true if the ANSI92 full SQL grammar is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsIntegrityEnhancementFacility

        public boolean supportsIntegrityEnhancementFacility()
                                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the SQL integrity enhancement facility is supported.
        Specified by:
        supportsIntegrityEnhancementFacility in interface DatabaseMetaData
        Returns:
        true if the integrity enhancement facility is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsOuterJoins

        public boolean supportsOuterJoins()
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports outer joins.
        Specified by:
        supportsOuterJoins in interface DatabaseMetaData
        Returns:
        true if outer joins are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsFullOuterJoins

        public boolean supportsFullOuterJoins()
                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports full outer joins.
        Specified by:
        supportsFullOuterJoins in interface DatabaseMetaData
        Returns:
        true if full outer joins are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsLimitedOuterJoins

        public boolean supportsLimitedOuterJoins()
                                          throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports limited outer joins.
        Specified by:
        supportsLimitedOuterJoins in interface DatabaseMetaData
        Returns:
        true if limited outer joins are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getSchemaTerm

        public java.lang.String getSchemaTerm()
                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the vendor's term for "schema".
        Specified by:
        getSchemaTerm in interface DatabaseMetaData
        Returns:
        The vendor's term for schema.
        Throws:
        java.sql.SQLException - if an error occurs.
      • getProcedureTerm

        public java.lang.String getProcedureTerm()
                                          throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the vendor's term for "procedure".
        Specified by:
        getProcedureTerm in interface DatabaseMetaData
        Returns:
        The vendor's term for procedure.
        Throws:
        java.sql.SQLException - if an error occurs.
      • getCatalogTerm

        public java.lang.String getCatalogTerm()
                                        throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the vendor's term for "catalog".
        Specified by:
        getCatalogTerm in interface DatabaseMetaData
        Returns:
        The vendor's term for catalog.
        Throws:
        java.sql.SQLException - if an error occurs.
      • isCatalogAtStart

        public boolean isCatalogAtStart()
                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name appears at the beginning of a fully qualified table name.
        Specified by:
        isCatalogAtStart in interface DatabaseMetaData
        Returns:
        true if the catalog name appears at the beginning, false if it appears at the end.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getCatalogSeparator

        public java.lang.String getCatalogSeparator()
                                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the separator between the catalog name and the table name.
        Specified by:
        getCatalogSeparator in interface DatabaseMetaData
        Returns:
        The separator between the catalog name and the table name.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSchemasInDataManipulation

        public boolean supportsSchemasInDataManipulation()
                                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in a data manipulation statement.
        Specified by:
        supportsSchemasInDataManipulation in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in a data manipulation statement, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSchemasInProcedureCalls

        public boolean supportsSchemasInProcedureCalls()
                                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in a procedure call
        Specified by:
        supportsSchemasInProcedureCalls in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in a procedure call, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSchemasInTableDefinitions

        public boolean supportsSchemasInTableDefinitions()
                                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in a table definition.
        Specified by:
        supportsSchemasInTableDefinitions in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in a table definition, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSchemasInIndexDefinitions

        public boolean supportsSchemasInIndexDefinitions()
                                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in an index definition.
        Specified by:
        supportsSchemasInIndexDefinitions in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in an index definition, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSchemasInPrivilegeDefinitions

        public boolean supportsSchemasInPrivilegeDefinitions()
                                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in privilege definitions.
        Specified by:
        supportsSchemasInPrivilegeDefinitions in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in privilege definition, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsCatalogsInDataManipulation

        public boolean supportsCatalogsInDataManipulation()
                                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in a data manipulation statement.
        Specified by:
        supportsCatalogsInDataManipulation in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in a data manipulation statement, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsCatalogsInProcedureCalls

        public boolean supportsCatalogsInProcedureCalls()
                                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in a procedure call
        Specified by:
        supportsCatalogsInProcedureCalls in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in a procedure call, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsCatalogsInTableDefinitions

        public boolean supportsCatalogsInTableDefinitions()
                                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in a table definition.
        Specified by:
        supportsCatalogsInTableDefinitions in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in a table definition, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsCatalogsInIndexDefinitions

        public boolean supportsCatalogsInIndexDefinitions()
                                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in an index definition.
        Specified by:
        supportsCatalogsInIndexDefinitions in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in an index definition, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsCatalogsInPrivilegeDefinitions

        public boolean supportsCatalogsInPrivilegeDefinitions()
                                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether a catalog name can appear in privilege definitions.
        Specified by:
        supportsCatalogsInPrivilegeDefinitions in interface DatabaseMetaData
        Returns:
        true if a catalog name can appear in privilege definition, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsPositionedDelete

        public boolean supportsPositionedDelete()
                                         throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not that database supports positioned deletes.
        Specified by:
        supportsPositionedDelete in interface DatabaseMetaData
        Returns:
        true if positioned deletes are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsPositionedUpdate

        public boolean supportsPositionedUpdate()
                                         throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not that database supports positioned updates.
        Specified by:
        supportsPositionedUpdate in interface DatabaseMetaData
        Returns:
        true if positioned updates are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSelectForUpdate

        public boolean supportsSelectForUpdate()
                                        throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not SELECT FOR UPDATE is supported by the database.
        Specified by:
        supportsSelectForUpdate in interface DatabaseMetaData
        Returns:
        true if SELECT FOR UPDATE is supported false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsStoredProcedures

        public boolean supportsStoredProcedures()
                                         throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not stored procedures are supported on this database.
        Specified by:
        supportsStoredProcedures in interface DatabaseMetaData
        Returns:
        true if stored procedures are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSubqueriesInComparisons

        public boolean supportsSubqueriesInComparisons()
                                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not subqueries are allowed in comparisons. A fully JDBC compliant driver will always return true.
        Specified by:
        supportsSubqueriesInComparisons in interface DatabaseMetaData
        Returns:
        true if subqueries are allowed in comparisons, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSubqueriesInExists

        public boolean supportsSubqueriesInExists()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not subqueries are allowed in exists expressions. A fully JDBC compliant driver will always return true.
        Specified by:
        supportsSubqueriesInExists in interface DatabaseMetaData
        Returns:
        true if subqueries are allowed in exists expressions, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSubqueriesInIns

        public boolean supportsSubqueriesInIns()
                                        throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether subqueries are allowed in IN statements. A fully JDBC compliant driver will always return true.
        Specified by:
        supportsSubqueriesInIns in interface DatabaseMetaData
        Returns:
        true if the driver supports subqueries in IN statements, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSubqueriesInQuantifieds

        public boolean supportsSubqueriesInQuantifieds()
                                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not subqueries are allowed in quantified expressions. A fully JDBC compliant driver will always return true.
        Specified by:
        supportsSubqueriesInQuantifieds in interface DatabaseMetaData
        Returns:
        true if subqueries are allowed in quantified expressions, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsCorrelatedSubqueries

        public boolean supportsCorrelatedSubqueries()
                                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method test whether or not correlated subqueries are allowed. A fully JDBC compliant driver will always return true.
        Specified by:
        supportsCorrelatedSubqueries in interface DatabaseMetaData
        Returns:
        true if correlated subqueries are allowed, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsUnion

        public boolean supportsUnion()
                              throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the UNION statement is supported.
        Specified by:
        supportsUnion in interface DatabaseMetaData
        Returns:
        true if UNION is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsUnionAll

        public boolean supportsUnionAll()
                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the UNION ALL statement is supported.
        Specified by:
        supportsUnionAll in interface DatabaseMetaData
        Returns:
        true if UNION ALL is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsOpenCursorsAcrossCommit

        public boolean supportsOpenCursorsAcrossCommit()
                                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports cursors remaining open across commits.
        Specified by:
        supportsOpenCursorsAcrossCommit in interface DatabaseMetaData
        Returns:
        true if cursors can remain open across commits, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsOpenCursorsAcrossRollback

        public boolean supportsOpenCursorsAcrossRollback()
                                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports cursors remaining open across rollbacks.
        Specified by:
        supportsOpenCursorsAcrossRollback in interface DatabaseMetaData
        Returns:
        true if cursors can remain open across rollbacks, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsOpenStatementsAcrossCommit

        public boolean supportsOpenStatementsAcrossCommit()
                                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports statements remaining open across commits.
        Specified by:
        supportsOpenStatementsAcrossCommit in interface DatabaseMetaData
        Returns:
        true if statements can remain open across commits, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsOpenStatementsAcrossRollback

        public boolean supportsOpenStatementsAcrossRollback()
                                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports statements remaining open across rollbacks.
        Specified by:
        supportsOpenStatementsAcrossRollback in interface DatabaseMetaData
        Returns:
        true if statements can remain open across rollbacks, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxBinaryLiteralLength

        public int getMaxBinaryLiteralLength()
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the number of hex characters allowed in an inline binary literal.
        Specified by:
        getMaxBinaryLiteralLength in interface DatabaseMetaData
        Returns:
        The number of hex characters allowed in a binary literal, 0 meaning either an unknown or unlimited number.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxCharLiteralLength

        public int getMaxCharLiteralLength()
                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of a character literal.
        Specified by:
        getMaxCharLiteralLength in interface DatabaseMetaData
        Returns:
        The maximum length of a character literal.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxColumnNameLength

        public int getMaxColumnNameLength()
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of a column name.
        Specified by:
        getMaxColumnNameLength in interface DatabaseMetaData
        Returns:
        The maximum length of a column name.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxColumnsInGroupBy

        public int getMaxColumnsInGroupBy()
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum number of columns in a GROUP BY statement.
        Specified by:
        getMaxColumnsInGroupBy in interface DatabaseMetaData
        Returns:
        The maximum number of columns in a GROUP BY statement.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxColumnsInIndex

        public int getMaxColumnsInIndex()
                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum number of columns in an index.
        Specified by:
        getMaxColumnsInIndex in interface DatabaseMetaData
        Returns:
        The maximum number of columns in an index.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxColumnsInOrderBy

        public int getMaxColumnsInOrderBy()
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum number of columns in an ORDER BY statement.
        Specified by:
        getMaxColumnsInOrderBy in interface DatabaseMetaData
        Returns:
        The maximum number of columns in an ORDER BY statement.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxColumnsInSelect

        public int getMaxColumnsInSelect()
                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum number of columns in a SELECT statement.
        Specified by:
        getMaxColumnsInSelect in interface DatabaseMetaData
        Returns:
        The maximum number of columns in a SELECT statement.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxColumnsInTable

        public int getMaxColumnsInTable()
                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum number of columns in a table.
        Specified by:
        getMaxColumnsInTable in interface DatabaseMetaData
        Returns:
        The maximum number of columns in a table.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxConnections

        public int getMaxConnections()
                              throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum number of connections this client can have to the database.
        Specified by:
        getMaxConnections in interface DatabaseMetaData
        Returns:
        The maximum number of database connections.
        Throws:
        java.sql.SQLException
      • getMaxCursorNameLength

        public int getMaxCursorNameLength()
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of a cursor name.
        Specified by:
        getMaxCursorNameLength in interface DatabaseMetaData
        Returns:
        The maximum length of a cursor name.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxIndexLength

        public int getMaxIndexLength()
                              throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of an index.
        Specified by:
        getMaxIndexLength in interface DatabaseMetaData
        Returns:
        The maximum length of an index.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxSchemaNameLength

        public int getMaxSchemaNameLength()
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of a schema name.
        Specified by:
        getMaxSchemaNameLength in interface DatabaseMetaData
        Returns:
        The maximum length of a schema name.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxProcedureNameLength

        public int getMaxProcedureNameLength()
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of a procedure name.
        Specified by:
        getMaxProcedureNameLength in interface DatabaseMetaData
        Returns:
        The maximum length of a procedure name.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxCatalogNameLength

        public int getMaxCatalogNameLength()
                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of a catalog name.
        Specified by:
        getMaxCatalogNameLength in interface DatabaseMetaData
        Returns:
        The maximum length of a catalog name.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxRowSize

        public int getMaxRowSize()
                          throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum size of a row in bytes.
        Specified by:
        getMaxRowSize in interface DatabaseMetaData
        Returns:
        The maximum size of a row.
        Throws:
        java.sql.SQLException - If an error occurs.
      • doesMaxRowSizeIncludeBlobs

        public boolean doesMaxRowSizeIncludeBlobs()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the maximum row size includes BLOB's
        Specified by:
        doesMaxRowSizeIncludeBlobs in interface DatabaseMetaData
        Returns:
        true if the maximum row size includes BLOB's, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxStatementLength

        public int getMaxStatementLength()
                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method includes the maximum length of a SQL statement.
        Specified by:
        getMaxStatementLength in interface DatabaseMetaData
        Returns:
        The maximum length of a SQL statement.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxStatements

        public int getMaxStatements()
                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum number of statements that can be active at any time.
        Specified by:
        getMaxStatements in interface DatabaseMetaData
        Returns:
        The maximum number of statements that can be active at any time.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxTableNameLength

        public int getMaxTableNameLength()
                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of a table name.
        Specified by:
        getMaxTableNameLength in interface DatabaseMetaData
        Returns:
        The maximum length of a table name.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxTablesInSelect

        public int getMaxTablesInSelect()
                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum number of tables that may be referenced in a SELECT statement.
        Specified by:
        getMaxTablesInSelect in interface DatabaseMetaData
        Returns:
        The maximum number of tables allowed in a SELECT statement.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getMaxUserNameLength

        public int getMaxUserNameLength()
                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the maximum length of a user name.
        Specified by:
        getMaxUserNameLength in interface DatabaseMetaData
        Returns:
        The maximum length of a user name.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getDefaultTransactionIsolation

        public int getDefaultTransactionIsolation()
                                           throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the default transaction isolation level of the database.
        Specified by:
        getDefaultTransactionIsolation in interface DatabaseMetaData
        Returns:
        The default transaction isolation level of the database.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        Connection
      • supportsTransactions

        public boolean supportsTransactions()
                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports transactions.
        Specified by:
        supportsTransactions in interface DatabaseMetaData
        Returns:
        true if the database supports transactions, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsTransactionIsolationLevel

        public boolean supportsTransactionIsolationLevel​(int level)
                                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports the specified transaction isolation level.
        Specified by:
        supportsTransactionIsolationLevel in interface DatabaseMetaData
        Parameters:
        level - The transaction isolation level.
        Returns:
        true if the specified transaction isolation level is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsDataDefinitionAndDataManipulationTransactions

        public boolean supportsDataDefinitionAndDataManipulationTransactions()
                                                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not DDL and DML statements allowed within the same transaction.
        Specified by:
        supportsDataDefinitionAndDataManipulationTransactions in interface DatabaseMetaData
        Returns:
        true if DDL and DML statements are allowed in the same transaction, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsDataManipulationTransactionsOnly

        public boolean supportsDataManipulationTransactionsOnly()
                                                         throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not only DML statement are allowed inside a transaction.
        Specified by:
        supportsDataManipulationTransactionsOnly in interface DatabaseMetaData
        Returns:
        true if only DML statements are allowed in transactions, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • dataDefinitionCausesTransactionCommit

        public boolean dataDefinitionCausesTransactionCommit()
                                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not a DDL statement will cause the current transaction to be automatically committed.
        Specified by:
        dataDefinitionCausesTransactionCommit in interface DatabaseMetaData
        Returns:
        true if DDL causes an immediate transaction commit, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • dataDefinitionIgnoredInTransactions

        public boolean dataDefinitionIgnoredInTransactions()
                                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not DDL statements are ignored in transactions.
        Specified by:
        dataDefinitionIgnoredInTransactions in interface DatabaseMetaData
        Returns:
        true if DDL statements are ignored in transactions, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getProcedures

        public ResultSet getProcedures​(java.lang.String catalog,
                                       java.lang.String schemaPattern,
                                       java.lang.String procedurePattern)
                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog. This is returned a ResultSet with the following columns:

        1. PROCEDURE_CAT - The catalog the procedure is in, which may be null.
        2. PROCEDURE_SCHEM - The schema the procedures is in, which may be null.
        3. PROCEDURE_NAME - The name of the procedure.
        4. Unused
        5. Unused
        6. Unused
        7. REMARKS - A description of the procedure
        8. PROCEDURE_TYPE - Indicates the return type of the procedure, which is one of the contstants defined in this class (procedureResultUnknown, procedureNoResult, or procedureReturnsResult).
        Specified by:
        getProcedures in interface DatabaseMetaData
        Parameters:
        catalog - The name of the catalog to return stored procedured from, or "" to return procedures from all catalogs.
        schemaPattern - A schema pattern for the schemas to return stored procedures from, or "" to return procedures from all schemas.
        procedurePattern - The pattern of procedure names to return.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getProcedureColumns

        public ResultSet getProcedureColumns​(java.lang.String catalog,
                                             java.lang.String schemaPattern,
                                             java.lang.String procedurePattern,
                                             java.lang.String columnPattern)
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a list of the parameter and result columns for the requested stored procedures. This is returned in the form of a ResultSet with the following columns:

        1. PROCEDURE_CAT - The catalog the procedure is in, which may be null.
        2. PROCEDURE_SCHEM - The schema the procedures is in, which may be null.
        3. PROCEDURE_NAME - The name of the procedure.
        4. COLUMN_NAME - The name of the column
        5. COLUMN_TYPE - The type of the column, which will be one of the contants defined in this class (procedureColumnUnknown, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnReturn, or procedureColumnResult).
        6. DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
        7. TYPE_NAME - The string name of the data type for this column.
        8. PRECISION - The precision of the column.
        9. LENGTH - The length of the column in bytes
        10. SCALE - The scale of the column.
        11. RADIX - The radix of the column.
        12. NULLABLE - Whether or not the column is NULLABLE. This is one of the constants defined in this class (procedureNoNulls, procedureNullable, or procedureNullableUnknown)
        13. REMARKS - A description of the column.
        Specified by:
        getProcedureColumns in interface DatabaseMetaData
        Parameters:
        catalog - The name of the catalog to return stored procedured from, or "" to return procedures from all catalogs.
        schemaPattern - A schema pattern for the schemas to return stored procedures from, or "" to return procedures from all schemas.
        procedurePattern - The pattern of procedures names to return.
        columnPattern - The pattern of column names to return.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getTables

        public ResultSet getTables​(java.lang.String catalog,
                                   java.lang.String schemaPattern,
                                   java.lang.String tablePattern,
                                   java.lang.String[] types)
                            throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a list of the requested table as a ResultSet with the following columns:
        1. TABLE_CAT - The catalog the table is in, which may be null.
        2. TABLE_SCHEM - The schema the table is in, which may be null.
        3. TABLE_NAME - The name of the table.
        4. TABLE_TYPE - A string describing the table type. This will be one of the values returned by the getTableTypes() method.
        5. REMARKS - Comments about the table.
        Specified by:
        getTables in interface DatabaseMetaData
        Parameters:
        catalog - The name of the catalog to return tables from, or "" to return tables from all catalogs.
        schemaPattern - A schema pattern for the schemas to return tables from, or "" to return tables from all schemas.
        tablePattern - The pattern of table names to return.
        types - The list of table types to include; null returns all types.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getSchemas

        public ResultSet getSchemas()
                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the list of database schemas as a ResultSet, with one column - TABLE_SCHEM - that is the name of the schema.
        Specified by:
        getSchemas in interface DatabaseMetaData
        Returns:
        A ResultSet with all the requested schemas.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getCatalogs

        public ResultSet getCatalogs()
                              throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the list of database catalogs as a ResultSet with one column - TABLE_CAT - that is the name of the catalog.
        Specified by:
        getCatalogs in interface DatabaseMetaData
        Returns:
        A ResultSet with all the requested catalogs.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getTableTypes

        public ResultSet getTableTypes()
                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the list of database table types as a ResultSet with one column - TABLE_TYPE - that is the name of the table type.
        Specified by:
        getTableTypes in interface DatabaseMetaData
        Returns:
        A ResultSet with all the requested table types.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getColumns

        public ResultSet getColumns​(java.lang.String catalog,
                                    java.lang.String schemaPattern,
                                    java.lang.String tablePattern,
                                    java.lang.String columnPattern)
                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a list of the tables columns for the requested tables. This is returned in the form of a ResultSet with the following columns:

        1. TABLE_CAT - The catalog the table is in, which may be null.
        2. TABLE_SCHEM - The schema the tables is in, which may be null.
        3. TABLE_NAME - The name of the table.
        4. COLUMN_NAME - The name of the column
        5. DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
        6. TYPE_NAME - The string name of the data type for this column.
        7. COLUMN_SIZE - The size of the column.
        8. Unused
        9. NUM_PREC_RADIX - The radix of the column.
        10. NULLABLE - Whether or not the column is NULLABLE. This is one of the constants defined in this class (tableNoNulls, tableNullable, or tableNullableUnknown)
        11. REMARKS - A description of the column.
        12. COLUMN_DEF - The default value for the column, may be null.
        13. SQL_DATA_TYPE - Unused
        14. SQL_DATETIME_SUB - Unused
        15. CHAR_OCTET_LENGTH - For character columns, the maximum number of bytes in the column.
        16. ORDINAL_POSITION - The index of the column in the table.
        17. IS_NULLABLE - "NO" means no, "YES" means maybe, and an empty string means unknown.
        Specified by:
        getColumns in interface DatabaseMetaData
        Parameters:
        catalog - The name of the catalog to return table from, or "" to return tables from all catalogs.
        schemaPattern - A schema pattern for the schemas to return tables from, or "" to return tables from all schemas.
        tablePattern - The pattern of table names to return.
        columnPattern - The pattern of column names to return.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getColumnPrivileges

        public ResultSet getColumnPrivileges​(java.lang.String catalog,
                                             java.lang.String schema,
                                             java.lang.String tableName,
                                             java.lang.String columnPattern)
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the access rights that have been granted to the requested columns. This information is returned as a ResultSet with the following columns:
        1. TABLE_CAT - The catalog the table is in, which may be null.
        2. TABLE_SCHEM - The schema the tables is in, which may be null.
        3. TABLE_NAME - The name of the table.
        4. COLUMN_NAME - The name of the column.
        5. GRANTOR - The entity that granted the access.
        6. GRANTEE - The entity granted the access.
        7. PRIVILEGE - The name of the privilege granted.
        8. IS_GRANTABLE - "YES" if the grantee can grant the privilege to others, "NO" if not, and null if unknown.
        Specified by:
        getColumnPrivileges in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        tableName - The table name to return information for.
        columnPattern - A pattern of column names to return information for.
        Returns:
        A ResultSet with all the requested privileges.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getTablePrivileges

        public ResultSet getTablePrivileges​(java.lang.String catalog,
                                            java.lang.String schemaPattern,
                                            java.lang.String tablePattern)
                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the access rights that have been granted to the requested tables. This information is returned as a ResultSet with the following columns:
        1. TABLE_CAT - The catalog the table is in, which may be null.
        2. TABLE_SCHEM - The schema the tables is in, which may be null.
        3. TABLE_NAME - The name of the table.
        4. GRANTOR - The entity that granted the access.
        5. GRANTEE - The entity granted the access.
        6. PRIVILEGE - The name of the privilege granted.
        7. IS_GRANTABLE - "YES" if the grantee can grant the privilege to others, "NO" if not, and null if unknown.
        Specified by:
        getTablePrivileges in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schemaPattern - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        tablePattern - The table name pattern of tables to return information for.
        Returns:
        A ResultSet with all the requested privileges.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getBestRowIdentifier

        public ResultSet getBestRowIdentifier​(java.lang.String catalog,
                                              java.lang.String schema,
                                              java.lang.String tableName,
                                              int scope,
                                              boolean nullable)
                                       throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the best set of columns for uniquely identifying a row. It returns this information as a ResultSet with the following columns:
        1. SCOPE - The scope of the results returned. This is one of the constants defined in this class (bestRowTemporary, bestRowTransaction, or bestRowSession).
        2. COLUMN_NAME - The name of the column.
        3. DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
        4. TYPE_NAME - The string name of the data type for this column.
        5. COLUMN_SIZE - The precision of the columns
        6. BUFFER_LENGTH - Unused
        7. DECIMAL_DIGITS - The scale of the column.
        8. PSEUDO_COLUMN - Whether or not the best row identifier is a pseudo_column. This is one of the constants defined in this class (bestRowUnknown, bestRowNotPseudo, or bestRowPseudo).
        Specified by:
        getBestRowIdentifier in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        tableName - The table name to return information for.
        scope - One of the best row id scope constants from this class.
        nullable - true to include columns that are nullable, false otherwise.
        Returns:
        A ResultSet with the best row identifier.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getVersionColumns

        public ResultSet getVersionColumns​(java.lang.String catalog,
                                           java.lang.String schema,
                                           java.lang.String tableName)
                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the set of columns that are automatically updated when the row is update. It returns this information as a ResultSet with the following columns:
        1. SCOPE - Unused
        2. COLUMN_NAME - The name of the column.
        3. DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
        4. TYPE_NAME - The string name of the data type for this column.
        5. COLUMN_SIZE - The precision of the columns
        6. BUFFER_LENGTH - Unused
        7. DECIMAL_DIGITS - The scale of the column.
        8. PSEUDO_COLUMN - Whether or not the best row identifier is a pseudo_column. This is one of the constants defined in this class (versionRowUnknown, versionRowNotPseudo, or versionRowPseudo).
        Specified by:
        getVersionColumns in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        tableName - The table name to return information for
        Returns:
        A ResultSet with the version columns.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getPrimaryKeys

        public ResultSet getPrimaryKeys​(java.lang.String catalog,
                                        java.lang.String schema,
                                        java.lang.String tableName)
                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a list of a table's primary key columns. These are returned as a ResultSet with the following columns.
        1. TABLE_CAT - The catalog of the table, which may be null.
        2. TABLE_SCHEM - The schema of the table, which may be null.
        3. TABLE_NAME - The name of the table.
        4. COLUMN_NAME - The name of the column.
        5. KEY_SEQ - The sequence number of the column within the primary key.
        6. PK_NAME - The name of the primary key, which may be null.
        Specified by:
        getPrimaryKeys in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        tableName - The table name to return information for.
        Returns:
        A ResultSet with the primary key columns.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getImportedKeys

        public ResultSet getImportedKeys​(java.lang.String catalog,
                                         java.lang.String schema,
                                         java.lang.String tableName)
                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a list of the table's foreign keys. These are returned as a ResultSet with the following columns:
        1. PKTABLE_CAT - The catalog of the table the key was imported from.
        2. PKTABLE_SCHEM - The schema of the table the key was imported from.
        3. PKTABLE_NAME - The name of the table the key was imported from.
        4. PKCOLUMN_NAME - The name of the column that was imported.
        5. FKTABLE_CAT - The foreign key catalog name.
        6. FKTABLE_SCHEM - The foreign key schema name.
        7. FKTABLE_NAME - The foreign key table name.
        8. FKCOLUMN_NAME - The foreign key column name.
        9. KEY_SEQ - The sequence number of the column within the foreign key.
        10. UPDATE_RULE - How the foreign key behaves when the primary key is updated. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, importedKeySetDefault, or importedKeyRestrict).
        11. DELETE_RULE - How the foreign key behaves when the primary key is deleted. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, or importedKeySetDefault)
        12. FK_NAME - The name of the foreign key.
        13. PK_NAME - The name of the primary key.
        14. DEFERRABILITY - The deferrability value. This is one of the constants defined in this table (importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, or importedKeyNotDeferrable).
        Specified by:
        getImportedKeys in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        tableName - The table name to return information for.
        Returns:
        A ResultSet with the foreign key columns.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getExportedKeys

        public ResultSet getExportedKeys​(java.lang.String catalog,
                                         java.lang.String schema,
                                         java.lang.String tableName)
                                  throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a list of the table's which use this table's primary key as a foreign key. The information is returned as a ResultSet with the following columns:
        1. PKTABLE_CAT - The catalog of the table the key was imported from.
        2. PKTABLE_SCHEM - The schema of the table the key was imported from.
        3. PKTABLE_NAME - The name of the table the key was imported from.
        4. PKCOLUMN_NAME - The name of the column that was imported.
        5. FKTABLE_CAT - The foreign key catalog name.
        6. FKTABLE_SCHEM - The foreign key schema name.
        7. FKTABLE_NAME - The foreign key table name.
        8. FKCOLUMN_NAME - The foreign key column name.
        9. KEY_SEQ - The sequence number of the column within the foreign key.
        10. UPDATE_RULE - How the foreign key behaves when the primary key is updated. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, importedKeySetDefault, or importedKeyRestrict).
        11. DELETE_RULE - How the foreign key behaves when the primary key is deleted. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, or importedKeySetDefault)
        12. FK_NAME - The name of the foreign key.
        13. PK_NAME - The name of the primary key.
        14. DEFERRABILITY - The deferrability value. This is one of the constants defined in this table (importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, or importedKeyNotDeferrable).
        Specified by:
        getExportedKeys in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        tableName - The table name to return information for.
        Returns:
        A ResultSet with the requested information
        Throws:
        java.sql.SQLException - If an error occurs.
      • getCrossReference

        public ResultSet getCrossReference​(java.lang.String primaryCatalog,
                                           java.lang.String primarySchema,
                                           java.lang.String primaryTableName,
                                           java.lang.String foreignCatalog,
                                           java.lang.String foreignSchema,
                                           java.lang.String foreignTableName)
                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a description of how one table imports another table's primary key as a foreign key. The information is returned as a ResultSet with the following columns:
        1. PKTABLE_CAT - The catalog of the table the key was imported from.
        2. PKTABLE_SCHEM - The schema of the table the key was imported from.
        3. PKTABLE_NAME - The name of the table the key was imported from.
        4. PKCOLUMN_NAME - The name of the column that was imported.
        5. FKTABLE_CAT - The foreign key catalog name.
        6. FKTABLE_SCHEM - The foreign key schema name.
        7. FKTABLE_NAME - The foreign key table name.
        8. FKCOLUMN_NAME - The foreign key column name.
        9. KEY_SEQ - The sequence number of the column within the foreign key.
        10. UPDATE_RULE - How the foreign key behaves when the primary key is updated. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, importedKeySetDefault, or importedKeyRestrict).
        11. DELETE_RULE - How the foreign key behaves when the primary key is deleted. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, or importedKeySetDefault)
        12. FK_NAME - The name of the foreign key.
        13. PK_NAME - The name of the primary key.
        14. DEFERRABILITY - The deferrability value. This is one of the constants defined in this table (importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, or importedKeyNotDeferrable).
        Specified by:
        getCrossReference in interface DatabaseMetaData
        Parameters:
        primaryCatalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs, on the exporting side.
        primarySchema - The schema to retrieve information from, or the empty string to return entities not associated with a schema, on the exporting side.
        primaryTableName - The table name to return information for, on the exporting side.
        foreignCatalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs, on the importing side.
        foreignSchema - The schema to retrieve information from, or the empty string to return entities not associated with a schema on the importing side.
        foreignTableName - The table name to return information for on the importing side.
        Returns:
        A ResultSet with the requested information
        Throws:
        java.sql.SQLException - If an error occurs.
      • getTypeInfo

        public ResultSet getTypeInfo()
                              throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns a list of the SQL types supported by this database. The information is returned as a ResultSet with the following columns:
        1. TYPE_NAME - The name of the data type.
        2. DATA_TYPE - A data type constant from Types for this type.
        3. PRECISION - The maximum precision of this type.
        4. LITERAL_PREFIX - Prefix value used to quote a literal, which may be null.
        5. LITERAL_SUFFIX - Suffix value used to quote a literal, which may be null.
        6. CREATE_PARAMS - The parameters used to create the type, which may be null.
        7. NULLABLE - Whether or not this type supports NULL values. This will be one of the constants defined in this interface (typeNoNulls, typeNullable, or typeNullableUnknown).
        8. CASE_SENSITIVE - Whether or not the value is case sensitive.
        9. SEARCHABLE - Whether or not "LIKE" expressions are supported in WHERE clauses for this type. This will be one of the constants defined in this interface (typePredNone, typePredChar, typePredBasic, or typeSearchable).
        10. UNSIGNED_ATTRIBUTE - Is the value of this type unsigned.
        11. FIXED_PREC_SCALE - Whether or not this type can be used for money.
        12. AUTO_INCREMENT - Whether or not this type supports auto-incrementing.
        13. LOCAL_TYPE_NAME - A localized name for this data type.
        14. MINIMUM_SCALE - The minimum scale supported by this type.
        15. MAXIMUM_SCALE - The maximum scale supported by this type.
        16. SQL_DATA_TYPE - Unused.
        17. SQL_DATETIME_SUB - Unused.
        18. NUM_PREC_RADIX - The radix of this data type.
        Specified by:
        getTypeInfo in interface DatabaseMetaData
        Returns:
        A ResultSet with the list of available data types.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getIndexInfo

        public ResultSet getIndexInfo​(java.lang.String catalog,
                                      java.lang.String schema,
                                      java.lang.String tableName,
                                      boolean unique,
                                      boolean approximate)
                               throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns information about a tables indices and statistics. It is returned as a ResultSet with the following columns:
        1. TABLE_CAT - The catalog of the table, which may be null.
        2. TABLE_SCHEM - The schema of the table, which may be null.
        3. TABLE_NAME - The name of the table.
        4. NON_UNIQUE - Are index values non-unique?
        5. INDEX_QUALIFIER The index catalog, which may be null
        6. INDEX_NAME - The name of the index.
        7. TYPE - The type of index, which will be one of the constants defined in this interface (tableIndexStatistic, tableIndexClustered, tableIndexHashed, or tableIndexOther).
        8. ORDINAL_POSITION - The sequence number of this column in the index. This will be 0 when the index type is tableIndexStatistic.
        9. COLUMN_NAME - The name of this column in the index.
        10. ASC_OR_DESC - "A" for an ascending sort sequence, "D" for a descending sort sequence or null if a sort sequence is not supported.
        11. CARDINALITY - The number of unique rows in the index, or the number of rows in the table if the index type is tableIndexStatistic.
        12. PAGES - The number of pages used for the index, or the number of pages in the table if the index type is tableIndexStatistic.
        13. FILTER_CONDITION - The filter condition for this index, which may be null.
        Specified by:
        getIndexInfo in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        tableName - The table name to return information for.
        unique - true to return only unique indexes, false otherwise.
        approximate - true if data values can be approximations, false otherwise.
        Returns:
        A ResultSet with the requested index information
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsResultSetType

        public boolean supportsResultSetType​(int type)
                                      throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the datbase supports the specified result type.
        Specified by:
        supportsResultSetType in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • supportsResultSetConcurrency

        public boolean supportsResultSetConcurrency​(int type,
                                                    int concurrency)
                                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether the specified result set type and result set concurrency type are supported by the database.
        Specified by:
        supportsResultSetConcurrency in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        concurrency - The desired concurrency type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type is supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • ownUpdatesAreVisible

        public boolean ownUpdatesAreVisible​(int type)
                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type sees its own updates.
        Specified by:
        ownUpdatesAreVisible in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type sees its own updates, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • ownDeletesAreVisible

        public boolean ownDeletesAreVisible​(int type)
                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type sees its own deletes.
        Specified by:
        ownDeletesAreVisible in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type sees its own deletes, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • ownInsertsAreVisible

        public boolean ownInsertsAreVisible​(int type)
                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type sees its own inserts.
        Specified by:
        ownInsertsAreVisible in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type sees its own inserts, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • othersUpdatesAreVisible

        public boolean othersUpdatesAreVisible​(int type)
                                        throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type sees updates committed by others.
        Specified by:
        othersUpdatesAreVisible in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type sees other updates, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • othersDeletesAreVisible

        public boolean othersDeletesAreVisible​(int type)
                                        throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type sees deletes committed by others.
        Specified by:
        othersDeletesAreVisible in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type sees other deletes, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • othersInsertsAreVisible

        public boolean othersInsertsAreVisible​(int type)
                                        throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type sees inserts committed by others.
        Specified by:
        othersInsertsAreVisible in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type sees other inserts, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • updatesAreDetected

        public boolean updatesAreDetected​(int type)
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type can detect a visible update by calling the rowUpdated method.
        Specified by:
        updatesAreDetected in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type can detect visible updates using rowUpdated, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • deletesAreDetected

        public boolean deletesAreDetected​(int type)
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type can detect a visible delete by calling the rowUpdated method.
        Specified by:
        deletesAreDetected in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type can detect visible deletes using rowUpdated, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • insertsAreDetected

        public boolean insertsAreDetected​(int type)
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the specified result set type can detect a visible insert by calling the rowUpdated method.
        Specified by:
        insertsAreDetected in interface DatabaseMetaData
        Parameters:
        type - The desired result type, which is one of the constants defined in ResultSet.
        Returns:
        true if the result set type can detect visible inserts using rowUpdated, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • supportsBatchUpdates

        public boolean supportsBatchUpdates()
                                     throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether or not the database supports batch updates.
        Specified by:
        supportsBatchUpdates in interface DatabaseMetaData
        Returns:
        true if batch updates are supported, false otherwise.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getUDTs

        public ResultSet getUDTs​(java.lang.String catalog,
                                 java.lang.String schemaPattern,
                                 java.lang.String typePattern,
                                 int[] types)
                          throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the list of user defined data types in use. These are returned as a ResultSet with the following columns:
        1. TYPE_CAT - The catalog name, which may be null.
        2. TYPE_SCEHM - The schema name, which may be null.
        3. TYPE_NAME - The user defined data type name.
        4. CLASS_NAME - The Java class name this type maps to.
        5. DATA_TYPE - A type identifier from Types for this type. This will be one of JAVA_OBJECT, STRUCT, or DISTINCT.
        6. REMARKS - Comments about this data type.
        Specified by:
        getUDTs in interface DatabaseMetaData
        Parameters:
        catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
        schemaPattern - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
        typePattern - The type name pattern to match.
        types - The type identifier patterns (from Types) to match.
        Returns:
        A ResultSet with the requested type information
        Throws:
        java.sql.SQLException - If an error occurs.
      • getConnection

        public Connection getConnection()
                                 throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the Connection object that was used to generate the metadata in this object.
        Specified by:
        getConnection in interface DatabaseMetaData
        Returns:
        The connection for this object.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsSavepoints

        public boolean supportsSavepoints()
                                   throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether the databse supports savepoints.
        Specified by:
        supportsSavepoints in interface DatabaseMetaData
        Returns:
        true if the database supports savepoints, false if it does not.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsNamedParameters

        public boolean supportsNamedParameters()
                                        throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether the database supports named parameters.
        Specified by:
        supportsNamedParameters in interface DatabaseMetaData
        Returns:
        true if the database supports named parameters, false if it does not.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsMultipleOpenResults

        public boolean supportsMultipleOpenResults()
                                            throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests whether the database supports returning multiple ResultSetS from a CallableStatement at once.
        Specified by:
        supportsMultipleOpenResults in interface DatabaseMetaData
        Returns:
        true if the database supports returnig multiple results at once, false if it does not.
        Throws:
        java.sql.SQLException - If an error occurs.
      • supportsGetGeneratedKeys

        public boolean supportsGetGeneratedKeys()
                                         throws java.sql.SQLException
        Specified by:
        supportsGetGeneratedKeys in interface DatabaseMetaData
        Throws:
        java.sql.SQLException
      • getSuperTypes

        public ResultSet getSuperTypes​(java.lang.String catalog,
                                       java.lang.String schemaPattern,
                                       java.lang.String typePattern)
                                throws java.sql.SQLException
        Specified by:
        getSuperTypes in interface DatabaseMetaData
        Throws:
        java.sql.SQLException
      • getSuperTables

        public ResultSet getSuperTables​(java.lang.String catalog,
                                        java.lang.String schemaPattern,
                                        java.lang.String tablePattern)
                                 throws java.sql.SQLException
        Specified by:
        getSuperTables in interface DatabaseMetaData
        Throws:
        java.sql.SQLException
      • getAttributes

        public ResultSet getAttributes​(java.lang.String catalog,
                                       java.lang.String schemaPattern,
                                       java.lang.String typePattern,
                                       java.lang.String attributePattern)
                                throws java.sql.SQLException
        Specified by:
        getAttributes in interface DatabaseMetaData
        Throws:
        java.sql.SQLException
      • supportsResultSetHoldability

        public boolean supportsResultSetHoldability​(int holdability)
                                             throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method tests if the database supports the specified holdability type. Valid values for this parameter are specified in the ResultSet class.
        Specified by:
        supportsResultSetHoldability in interface DatabaseMetaData
        Parameters:
        holdability - The holdability type to test.
        Returns:
        true if the database supports the holdability type, false if it does not.
        Throws:
        java.sql.SQLException - If an error occurs.
        See Also:
        ResultSet
      • getResultSetHoldability

        public int getResultSetHoldability()
                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the default holdability type of ResultSetS retrieved from this database. The possible values are specified in the ResultSet class.
        Specified by:
        getResultSetHoldability in interface DatabaseMetaData
        Returns:
        The default holdability type.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getDatabaseMajorVersion

        public int getDatabaseMajorVersion()
                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the major version number of the database.
        Specified by:
        getDatabaseMajorVersion in interface DatabaseMetaData
        Returns:
        The major version number of the database.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getDatabaseMinorVersion

        public int getDatabaseMinorVersion()
                                    throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the minor version number of the database.
        Specified by:
        getDatabaseMinorVersion in interface DatabaseMetaData
        Returns:
        The minor version number of the database.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getJDBCMajorVersion

        public int getJDBCMajorVersion()
                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the major version number of the JDBC driver.
        Specified by:
        getJDBCMajorVersion in interface DatabaseMetaData
        Returns:
        The major version number of the JDBC driver.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getJDBCMinorVersion

        public int getJDBCMinorVersion()
                                throws java.sql.SQLException
        Description copied from interface: DatabaseMetaData
        This method returns the minor version number of the JDBC driver.
        Specified by:
        getJDBCMinorVersion in interface DatabaseMetaData
        Returns:
        The minor version number of the database.
        Throws:
        java.sql.SQLException - If an error occurs.
      • getSQLStateType

        public int getSQLStateType()
                            throws java.sql.SQLException
        Specified by:
        getSQLStateType in interface DatabaseMetaData
        Throws:
        java.sql.SQLException
      • locatorsUpdateCopy

        public boolean locatorsUpdateCopy()
                                   throws java.sql.SQLException
        Specified by:
        locatorsUpdateCopy in interface DatabaseMetaData
        Throws:
        java.sql.SQLException
      • supportsStatementPooling

        public boolean supportsStatementPooling()
                                         throws java.sql.SQLException
        Specified by:
        supportsStatementPooling in interface DatabaseMetaData
        Throws:
        java.sql.SQLException