Package org.sqlite.core

Class CoreDatabaseMetaData

  • All Implemented Interfaces:
    java.sql.DatabaseMetaData, java.sql.Wrapper
    Direct Known Subclasses:
    JDBC3DatabaseMetaData
    public abstract class CoreDatabaseMetaData
extends java.lang.Object
implements java.sql.DatabaseMetaData

    • Field Summary

      Fields 
      Modifier and Type Field Description
      protected SQLiteConnection conn  
      protected java.sql.PreparedStatement getAttributes  
      protected java.sql.PreparedStatement getBestRowIdentifier  
      protected java.sql.PreparedStatement getCatalogs  
      protected java.sql.PreparedStatement getColumnPrivileges  
      protected java.sql.PreparedStatement getColumnsTblName  
      protected java.sql.PreparedStatement getGeneratedKeys
      Used to save generating a new statement every call.
      protected java.sql.PreparedStatement getIndexInfo  
      protected java.sql.PreparedStatement getProcedureColumns  
      protected java.sql.PreparedStatement getProcedures  
      protected java.sql.PreparedStatement getSchemas  
      protected java.sql.PreparedStatement getSuperTables  
      protected java.sql.PreparedStatement getSuperTypes  
      protected java.sql.PreparedStatement getTablePrivileges  
      protected java.sql.PreparedStatement getTables  
      protected java.sql.PreparedStatement getTableTypes  
      protected java.sql.PreparedStatement getTypeInfo  
      protected java.sql.PreparedStatement getUDTs  
      protected java.sql.PreparedStatement getVersionColumns  
      protected static java.util.regex.Pattern PK_NAMED_PATTERN
      Pattern used to extract a named primary key.
      protected static java.util.regex.Pattern PK_UNNAMED_PATTERN
      Pattern used to extract column order for an unnamed primary key.

      • Fields inherited from interface java.sql.DatabaseMetaData

        attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, functionColumnIn, functionColumnInOut, functionColumnOut, functionColumnResult, functionColumnUnknown, functionNoNulls, functionNoTable, functionNullable, functionNullableUnknown, functionResultUnknown, functionReturn, functionReturnsTable, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown

    • Method Summary

      Modifier and Type Method Description
      protected void checkOpen()  
      void close()  
      protected java.lang.String escape​(java.lang.String val)
      Applies SQL escapes for special characters in a given string.
      protected void finalize()  
      abstract java.sql.ResultSet getGeneratedKeys()  
      protected static java.lang.String quote​(java.lang.String tableName)
      Adds SQL string quotes to the given string.

      • Methods inherited from class java.lang.Object

        clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

      • Methods inherited from interface java.sql.DatabaseMetaData

        allProceduresAreCallable, allTablesAreSelectable, autoCommitFailureClosesAllResultSets, dataDefinitionCausesTransactionCommit, dataDefinitionIgnoredInTransactions, deletesAreDetected, doesMaxRowSizeIncludeBlobs, generatedKeyAlwaysReturned, getAttributes, getBestRowIdentifier, getCatalogs, getCatalogSeparator, getCatalogTerm, getClientInfoProperties, getColumnPrivileges, getColumns, getConnection, getCrossReference, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDefaultTransactionIsolation, getDriverMajorVersion, getDriverMinorVersion, getDriverName, getDriverVersion, getExportedKeys, getExtraNameCharacters, getFunctionColumns, getFunctions, getIdentifierQuoteString, getImportedKeys, getIndexInfo, getJDBCMajorVersion, getJDBCMinorVersion, getMaxBinaryLiteralLength, getMaxCatalogNameLength, getMaxCharLiteralLength, getMaxColumnNameLength, getMaxColumnsInGroupBy, getMaxColumnsInIndex, getMaxColumnsInOrderBy, getMaxColumnsInSelect, getMaxColumnsInTable, getMaxConnections, getMaxCursorNameLength, getMaxIndexLength, getMaxLogicalLobSize, getMaxProcedureNameLength, getMaxRowSize, getMaxSchemaNameLength, getMaxStatementLength, getMaxStatements, getMaxTableNameLength, getMaxTablesInSelect, getMaxUserNameLength, getNumericFunctions, getPrimaryKeys, getProcedureColumns, getProcedures, getProcedureTerm, getPseudoColumns, getResultSetHoldability, getRowIdLifetime, getSchemas, getSchemas, getSchemaTerm, getSearchStringEscape, getSQLKeywords, getSQLStateType, getStringFunctions, getSuperTables, getSuperTypes, getSystemFunctions, getTablePrivileges, getTables, getTableTypes, getTimeDateFunctions, getTypeInfo, getUDTs, getURL, getUserName, getVersionColumns, insertsAreDetected, isCatalogAtStart, isReadOnly, locatorsUpdateCopy, nullPlusNonNullIsNull, nullsAreSortedAtEnd, nullsAreSortedAtStart, nullsAreSortedHigh, nullsAreSortedLow, othersDeletesAreVisible, othersInsertsAreVisible, othersUpdatesAreVisible, ownDeletesAreVisible, ownInsertsAreVisible, ownUpdatesAreVisible, storesLowerCaseIdentifiers, storesLowerCaseQuotedIdentifiers, storesMixedCaseIdentifiers, storesMixedCaseQuotedIdentifiers, storesUpperCaseIdentifiers, storesUpperCaseQuotedIdentifiers, supportsAlterTableWithAddColumn, supportsAlterTableWithDropColumn, supportsANSI92EntryLevelSQL, supportsANSI92FullSQL, supportsANSI92IntermediateSQL, supportsBatchUpdates, supportsCatalogsInDataManipulation, supportsCatalogsInIndexDefinitions, supportsCatalogsInPrivilegeDefinitions, supportsCatalogsInProcedureCalls, supportsCatalogsInTableDefinitions, supportsColumnAliasing, supportsConvert, supportsConvert, supportsCoreSQLGrammar, supportsCorrelatedSubqueries, supportsDataDefinitionAndDataManipulationTransactions, supportsDataManipulationTransactionsOnly, supportsDifferentTableCorrelationNames, supportsExpressionsInOrderBy, supportsExtendedSQLGrammar, supportsFullOuterJoins, supportsGetGeneratedKeys, supportsGroupBy, supportsGroupByBeyondSelect, supportsGroupByUnrelated, supportsIntegrityEnhancementFacility, supportsLikeEscapeClause, supportsLimitedOuterJoins, supportsMinimumSQLGrammar, supportsMixedCaseIdentifiers, supportsMixedCaseQuotedIdentifiers, supportsMultipleOpenResults, supportsMultipleResultSets, supportsMultipleTransactions, supportsNamedParameters, supportsNonNullableColumns, supportsOpenCursorsAcrossCommit, supportsOpenCursorsAcrossRollback, supportsOpenStatementsAcrossCommit, supportsOpenStatementsAcrossRollback, supportsOrderByUnrelated, supportsOuterJoins, supportsPositionedDelete, supportsPositionedUpdate, supportsRefCursors, supportsResultSetConcurrency, supportsResultSetHoldability, supportsResultSetType, supportsSavepoints, supportsSchemasInDataManipulation, supportsSchemasInIndexDefinitions, supportsSchemasInPrivilegeDefinitions, supportsSchemasInProcedureCalls, supportsSchemasInTableDefinitions, supportsSelectForUpdate, supportsSharding, supportsStatementPooling, supportsStoredFunctionsUsingCallSyntax, supportsStoredProcedures, supportsSubqueriesInComparisons, supportsSubqueriesInExists, supportsSubqueriesInIns, supportsSubqueriesInQuantifieds, supportsTableCorrelationNames, supportsTransactionIsolationLevel, supportsTransactions, supportsUnion, supportsUnionAll, updatesAreDetected, usesLocalFilePerTable, usesLocalFiles

      • Methods inherited from interface java.sql.Wrapper

        isWrapperFor, unwrap

    • Field Detail

      • getTables

        protected java.sql.PreparedStatement getTables

      • getTableTypes

        protected java.sql.PreparedStatement getTableTypes

      • getTypeInfo

        protected java.sql.PreparedStatement getTypeInfo

      • getCatalogs

        protected java.sql.PreparedStatement getCatalogs

      • getSchemas

        protected java.sql.PreparedStatement getSchemas

      • getUDTs

        protected java.sql.PreparedStatement getUDTs

      • getColumnsTblName

        protected java.sql.PreparedStatement getColumnsTblName

      • getSuperTypes

        protected java.sql.PreparedStatement getSuperTypes

      • getSuperTables

        protected java.sql.PreparedStatement getSuperTables

      • getTablePrivileges

        protected java.sql.PreparedStatement getTablePrivileges

      • getIndexInfo

        protected java.sql.PreparedStatement getIndexInfo

      • getProcedures

        protected java.sql.PreparedStatement getProcedures

      • getProcedureColumns

        protected java.sql.PreparedStatement getProcedureColumns

      • getAttributes

        protected java.sql.PreparedStatement getAttributes

      • getBestRowIdentifier

        protected java.sql.PreparedStatement getBestRowIdentifier

      • getVersionColumns

        protected java.sql.PreparedStatement getVersionColumns

      • getColumnPrivileges

        protected java.sql.PreparedStatement getColumnPrivileges

      • getGeneratedKeys

        protected java.sql.PreparedStatement getGeneratedKeys
        Used to save generating a new statement every call.

      • PK_UNNAMED_PATTERN

        protected static final java.util.regex.Pattern PK_UNNAMED_PATTERN
        Pattern used to extract column order for an unnamed primary key.

      • PK_NAMED_PATTERN

        protected static final java.util.regex.Pattern PK_NAMED_PATTERN
        Pattern used to extract a named primary key.

    • Constructor Detail

      • CoreDatabaseMetaData

        protected CoreDatabaseMetaData​(SQLiteConnection conn)
        Constructor that applies the Connection object.
        Parameters:
        conn - Connection object.

    • Method Detail

      • getGeneratedKeys

        public abstract java.sql.ResultSet getGeneratedKeys()
                                             throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • checkOpen

        protected void checkOpen()
                  throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • close

        public void close()
           throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • quote

        protected static java.lang.String quote​(java.lang.String tableName)
        Adds SQL string quotes to the given string.
        Parameters:
        tableName - The string to quote.
        Returns:
        The quoted string.

      • escape

        protected java.lang.String escape​(java.lang.String val)
        Applies SQL escapes for special characters in a given string.
        Parameters:
        val - The string to escape.
        Returns:
        The SQL escaped string.

      • finalize

        protected void finalize()
                 throws java.lang.Throwable
        Overrides:
        finalize in class java.lang.Object
        Throws:
        java.lang.Throwable
        See Also:
        Object.finalize()