Package org.sqlite.jdbc3
Class JDBC3DatabaseMetaData
java.lang.Object
org.sqlite.core.CoreDatabaseMetaData
org.sqlite.jdbc3.JDBC3DatabaseMetaData
- All Implemented Interfaces:
DatabaseMetaData
,Wrapper
- Direct Known Subclasses:
JDBC4DatabaseMetaData
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected static final Pattern
Pattern used to extract a named primary key.protected static final Pattern
Pattern used to extract column order for an unnamed primary key.protected static final Pattern
protected static final Pattern
protected static final Pattern
Fields inherited from class org.sqlite.core.CoreDatabaseMetaData
conn, getAttributes, getBestRowIdentifier, getCatalogs, getColumnPrivileges, getColumnsTblName, getIndexInfo, getProcedureColumns, getProcedures, getSchemas, getSuperTables, getSuperTypes, getTablePrivileges, getTables, getTableTypes, getTypeInfo, getUDTs, getVersionColumns
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
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionboolean
boolean
createStruct
(String t, Object[] attr) Not implemented yet.boolean
boolean
boolean
deletesAreDetected
(int type) boolean
protected void
finalize()
getAttributes
(String c, String s, String t, String a) getBestRowIdentifier
(String c, String s, String t, int scope, boolean n) getColumnPrivileges
(String c, String s, String t, String colPat) getColumns
(String c, String s, String tblNamePattern, String colNamePattern) int
int
int
int
int
getExportedKeys
(String catalog, String schema, String table) getFunctionColumns
(String a, String b, String c, String d) Not implemented yet.Deprecated.Not exactly sure what this function does, as it is not implementing any interface, and is not used anywhere in the code.getImportedKeys
(String catalog, String schema, String table) getIndexInfo
(String c, String s, String table, boolean u, boolean approximate) int
int
int
int
int
int
int
int
int
int
int
int
int
int
int
int
int
int
int
int
int
int
getPrimaryKeys
(String c, String s, String table) getProcedureColumns
(String c, String s, String p, String colPat) getProcedures
(String c, String s, String p) int
int
getSuperTables
(String c, String s, String t) getSuperTypes
(String c, String s, String t) getTablePrivileges
(String c, String s, String t) getURL()
getVersionColumns
(String c, String s, String t) boolean
insertsAreDetected
(int type) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
othersDeletesAreVisible
(int type) boolean
othersInsertsAreVisible
(int type) boolean
othersUpdatesAreVisible
(int type) boolean
ownDeletesAreVisible
(int type) boolean
ownInsertsAreVisible
(int type) boolean
ownUpdatesAreVisible
(int type) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsConvert
(int fromType, int toType) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsResultSetConcurrency
(int t, int c) boolean
supportsResultSetHoldability
(int h) boolean
supportsResultSetType
(int t) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsTransactionIsolationLevel
(int level) boolean
boolean
boolean
boolean
updatesAreDetected
(int type) boolean
boolean
Methods inherited from class org.sqlite.core.CoreDatabaseMetaData
checkOpen, close, escape, quote
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface java.sql.DatabaseMetaData
autoCommitFailureClosesAllResultSets, generatedKeyAlwaysReturned, getClientInfoProperties, getFunctions, getMaxLogicalLobSize, getPseudoColumns, getRowIdLifetime, getSchemas, supportsRefCursors, supportsSharding, supportsStoredFunctionsUsingCallSyntax
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
-
Field Details
-
TYPE_INTEGER
-
TYPE_VARCHAR
-
TYPE_FLOAT
-
PK_UNNAMED_PATTERN
Pattern used to extract column order for an unnamed primary key. -
PK_NAMED_PATTERN
Pattern used to extract a named primary key.
-
-
Constructor Details
-
JDBC3DatabaseMetaData
-
-
Method Details
-
getConnection
- See Also:
-
getDatabaseMajorVersion
- Throws:
SQLException
- See Also:
-
getDatabaseMinorVersion
- Throws:
SQLException
- See Also:
-
getDriverMajorVersion
public int getDriverMajorVersion()- See Also:
-
getDriverMinorVersion
public int getDriverMinorVersion()- See Also:
-
getJDBCMajorVersion
public int getJDBCMajorVersion()- See Also:
-
getJDBCMinorVersion
public int getJDBCMinorVersion()- See Also:
-
getDefaultTransactionIsolation
public int getDefaultTransactionIsolation() -
getMaxBinaryLiteralLength
public int getMaxBinaryLiteralLength() -
getMaxCatalogNameLength
public int getMaxCatalogNameLength() -
getMaxCharLiteralLength
public int getMaxCharLiteralLength() -
getMaxColumnNameLength
public int getMaxColumnNameLength() -
getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy() -
getMaxColumnsInIndex
public int getMaxColumnsInIndex()- See Also:
-
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy() -
getMaxColumnsInSelect
public int getMaxColumnsInSelect()- See Also:
-
getMaxColumnsInTable
public int getMaxColumnsInTable()- See Also:
-
getMaxConnections
public int getMaxConnections()- See Also:
-
getMaxCursorNameLength
public int getMaxCursorNameLength() -
getMaxIndexLength
public int getMaxIndexLength()- See Also:
-
getMaxProcedureNameLength
public int getMaxProcedureNameLength() -
getMaxRowSize
public int getMaxRowSize()- See Also:
-
getMaxSchemaNameLength
public int getMaxSchemaNameLength() -
getMaxStatementLength
public int getMaxStatementLength()- See Also:
-
getMaxStatements
public int getMaxStatements()- See Also:
-
getMaxTableNameLength
public int getMaxTableNameLength()- See Also:
-
getMaxTablesInSelect
public int getMaxTablesInSelect()- See Also:
-
getMaxUserNameLength
public int getMaxUserNameLength()- See Also:
-
getResultSetHoldability
public int getResultSetHoldability() -
getSQLStateType
public int getSQLStateType()- See Also:
-
getDatabaseProductName
-
getDatabaseProductVersion
- Throws:
SQLException
- See Also:
-
getDriverName
- See Also:
-
getDriverVersion
- See Also:
-
getExtraNameCharacters
-
getCatalogSeparator
- See Also:
-
getCatalogTerm
- See Also:
-
getSchemaTerm
- See Also:
-
getProcedureTerm
- See Also:
-
getSearchStringEscape
- See Also:
-
getIdentifierQuoteString
-
getSQLKeywords
-
getNumericFunctions
- See Also:
-
getStringFunctions
- See Also:
-
getSystemFunctions
- See Also:
-
getTimeDateFunctions
- See Also:
-
getURL
- See Also:
-
getUserName
- See Also:
-
allProceduresAreCallable
public boolean allProceduresAreCallable() -
allTablesAreSelectable
public boolean allTablesAreSelectable() -
dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit() -
dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions() -
doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs() -
deletesAreDetected
public boolean deletesAreDetected(int type) - See Also:
-
insertsAreDetected
public boolean insertsAreDetected(int type) - See Also:
-
isCatalogAtStart
public boolean isCatalogAtStart()- See Also:
-
locatorsUpdateCopy
public boolean locatorsUpdateCopy()- See Also:
-
nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull()- See Also:
-
nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd()- See Also:
-
nullsAreSortedAtStart
public boolean nullsAreSortedAtStart()- See Also:
-
nullsAreSortedHigh
public boolean nullsAreSortedHigh()- See Also:
-
nullsAreSortedLow
public boolean nullsAreSortedLow()- See Also:
-
othersDeletesAreVisible
public boolean othersDeletesAreVisible(int type) -
othersInsertsAreVisible
public boolean othersInsertsAreVisible(int type) -
othersUpdatesAreVisible
public boolean othersUpdatesAreVisible(int type) -
ownDeletesAreVisible
public boolean ownDeletesAreVisible(int type) -
ownInsertsAreVisible
public boolean ownInsertsAreVisible(int type) -
ownUpdatesAreVisible
public boolean ownUpdatesAreVisible(int type) -
storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers() -
storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers() -
storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers() -
storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers() -
storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers() -
storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers() -
supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn() -
supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn() -
supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL() -
supportsANSI92FullSQL
public boolean supportsANSI92FullSQL()- See Also:
-
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL() -
supportsBatchUpdates
public boolean supportsBatchUpdates()- See Also:
-
supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation() -
supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions() -
supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions() -
supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls() -
supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions() -
supportsColumnAliasing
public boolean supportsColumnAliasing() -
supportsConvert
public boolean supportsConvert()- See Also:
-
supportsConvert
public boolean supportsConvert(int fromType, int toType) -
supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions() -
supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly() -
supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames() -
supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy() -
supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar() -
supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar() -
supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar() -
supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins() -
supportsFullOuterJoins
- Throws:
SQLException
- See Also:
-
supportsGetGeneratedKeys
public boolean supportsGetGeneratedKeys() -
supportsGroupBy
public boolean supportsGroupBy()- See Also:
-
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect() -
supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility() -
supportsLikeEscapeClause
public boolean supportsLikeEscapeClause() -
supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers() -
supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers() -
supportsMultipleOpenResults
public boolean supportsMultipleOpenResults() -
supportsMultipleResultSets
public boolean supportsMultipleResultSets() -
supportsMultipleTransactions
public boolean supportsMultipleTransactions() -
supportsNamedParameters
public boolean supportsNamedParameters() -
supportsNonNullableColumns
public boolean supportsNonNullableColumns() -
supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit() -
supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback() -
supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit() -
supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback() -
supportsOuterJoins
public boolean supportsOuterJoins()- See Also:
-
supportsPositionedDelete
public boolean supportsPositionedDelete() -
supportsPositionedUpdate
public boolean supportsPositionedUpdate() -
supportsResultSetConcurrency
public boolean supportsResultSetConcurrency(int t, int c) -
supportsResultSetHoldability
public boolean supportsResultSetHoldability(int h) -
supportsResultSetType
public boolean supportsResultSetType(int t) -
supportsSavepoints
public boolean supportsSavepoints()- See Also:
-
supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation() -
supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions() -
supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions() -
supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls() -
supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions() -
supportsSelectForUpdate
public boolean supportsSelectForUpdate() -
supportsStatementPooling
public boolean supportsStatementPooling() -
supportsStoredProcedures
public boolean supportsStoredProcedures() -
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons() -
supportsSubqueriesInExists
public boolean supportsSubqueriesInExists() -
supportsSubqueriesInIns
public boolean supportsSubqueriesInIns() -
supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds() -
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames() -
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int level) -
supportsTransactions
public boolean supportsTransactions()- See Also:
-
supportsUnion
public boolean supportsUnion()- See Also:
-
supportsUnionAll
public boolean supportsUnionAll()- See Also:
-
updatesAreDetected
public boolean updatesAreDetected(int type) - See Also:
-
usesLocalFilePerTable
public boolean usesLocalFilePerTable()- See Also:
-
usesLocalFiles
public boolean usesLocalFiles()- See Also:
-
isReadOnly
- Throws:
SQLException
- See Also:
-
getAttributes
-
getBestRowIdentifier
public ResultSet getBestRowIdentifier(String c, String s, String t, int scope, boolean n) throws SQLException -
getColumnPrivileges
-
getColumns
-
getCrossReference
-
getSchemas
- Throws:
SQLException
- See Also:
-
getCatalogs
- Throws:
SQLException
- See Also:
-
getPrimaryKeys
-
getExportedKeys
-
getImportedKeys
-
getIndexInfo
public ResultSet getIndexInfo(String c, String s, String table, boolean u, boolean approximate) throws SQLException -
getProcedureColumns
-
getProcedures
-
getSuperTables
-
getSuperTypes
-
getTablePrivileges
-
getTables
-
getTableTypes
- Throws:
SQLException
- See Also:
-
getTypeInfo
- Throws:
SQLException
- See Also:
-
getUDTs
-
getVersionColumns
-
getGeneratedKeys
Deprecated.Not exactly sure what this function does, as it is not implementing any interface, and is not used anywhere in the code. Deprecated since 3.43.0.0.- Specified by:
getGeneratedKeys
in classCoreDatabaseMetaData
- Throws:
SQLException
-
createStruct
Not implemented yet.- Throws:
SQLException
-
getFunctionColumns
Not implemented yet.- Throws:
SQLException
-
finalize
- Overrides:
finalize
in classCoreDatabaseMetaData
- Throws:
Throwable
- See Also:
-