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
-
Nested Class Summary
Nested ClassesModifier and TypeClassDescription(package private) class
private static class
Class-wrapper around the logger object to avoid build-time initialization of the logging framework in native-image(package private) class
Parses the sqlite_schema table for a table's primary key -
Field Summary
FieldsModifier and TypeFieldDescriptionprivate static String
private static String
protected 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
private StringBuilder
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
private String
unquoteIdentifier
(String name) Follow rules in SQLite Keywordsboolean
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
-
driverName
-
driverVersion
-
TYPE_INTEGER
-
TYPE_VARCHAR
-
TYPE_FLOAT
-
RULE_MAP
-
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()- See Also:
-
getMaxBinaryLiteralLength
public int getMaxBinaryLiteralLength()- See Also:
-
getMaxCatalogNameLength
public int getMaxCatalogNameLength()- See Also:
-
getMaxCharLiteralLength
public int getMaxCharLiteralLength()- See Also:
-
getMaxColumnNameLength
public int getMaxColumnNameLength()- See Also:
-
getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy()- See Also:
-
getMaxColumnsInIndex
public int getMaxColumnsInIndex()- See Also:
-
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy()- See Also:
-
getMaxColumnsInSelect
public int getMaxColumnsInSelect()- See Also:
-
getMaxColumnsInTable
public int getMaxColumnsInTable()- See Also:
-
getMaxConnections
public int getMaxConnections()- See Also:
-
getMaxCursorNameLength
public int getMaxCursorNameLength()- See Also:
-
getMaxIndexLength
public int getMaxIndexLength()- See Also:
-
getMaxProcedureNameLength
public int getMaxProcedureNameLength()- See Also:
-
getMaxRowSize
public int getMaxRowSize()- See Also:
-
getMaxSchemaNameLength
public int getMaxSchemaNameLength()- See Also:
-
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()- See Also:
-
getSQLStateType
public int getSQLStateType()- See Also:
-
getDatabaseProductName
- See Also:
-
getDatabaseProductVersion
- Throws:
SQLException
- See Also:
-
getDriverName
- See Also:
-
getDriverVersion
- See Also:
-
getExtraNameCharacters
- See Also:
-
getCatalogSeparator
- See Also:
-
getCatalogTerm
- See Also:
-
getSchemaTerm
- See Also:
-
getProcedureTerm
- See Also:
-
getSearchStringEscape
- See Also:
-
getIdentifierQuoteString
- See Also:
-
getSQLKeywords
- See Also:
-
getNumericFunctions
- See Also:
-
getStringFunctions
- See Also:
-
getSystemFunctions
- See Also:
-
getTimeDateFunctions
- See Also:
-
getURL
- See Also:
-
getUserName
- See Also:
-
allProceduresAreCallable
public boolean allProceduresAreCallable()- See Also:
-
allTablesAreSelectable
public boolean allTablesAreSelectable()- See Also:
-
dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit()- See Also:
-
dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions()- See Also:
-
doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs()- See Also:
-
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) - See Also:
-
othersInsertsAreVisible
public boolean othersInsertsAreVisible(int type) - See Also:
-
othersUpdatesAreVisible
public boolean othersUpdatesAreVisible(int type) - See Also:
-
ownDeletesAreVisible
public boolean ownDeletesAreVisible(int type) - See Also:
-
ownInsertsAreVisible
public boolean ownInsertsAreVisible(int type) - See Also:
-
ownUpdatesAreVisible
public boolean ownUpdatesAreVisible(int type) - See Also:
-
storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers()- See Also:
-
storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers()- See Also:
-
storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers()- See Also:
-
storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers()- See Also:
-
storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers()- See Also:
-
storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers()- See Also:
-
supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn()- See Also:
-
supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn()- See Also:
-
supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL()- See Also:
-
supportsANSI92FullSQL
public boolean supportsANSI92FullSQL()- See Also:
-
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL()- See Also:
-
supportsBatchUpdates
public boolean supportsBatchUpdates()- See Also:
-
supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation()- See Also:
-
supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions()- See Also:
-
supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions()- See Also:
-
supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls()- See Also:
-
supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions()- See Also:
-
supportsColumnAliasing
public boolean supportsColumnAliasing()- See Also:
-
supportsConvert
public boolean supportsConvert()- See Also:
-
supportsConvert
public boolean supportsConvert(int fromType, int toType) - See Also:
-
supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions()- See Also:
-
supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly()- See Also:
-
supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames()- See Also:
-
supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy()- See Also:
-
supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar()- See Also:
-
supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar()- See Also:
-
supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar()- See Also:
-
supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins()- See Also:
-
supportsFullOuterJoins
- Throws:
SQLException
- See Also:
-
supportsGetGeneratedKeys
public boolean supportsGetGeneratedKeys()- See Also:
-
supportsGroupBy
public boolean supportsGroupBy()- See Also:
-
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect()- See Also:
-
supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility()- See Also:
-
supportsLikeEscapeClause
public boolean supportsLikeEscapeClause()- See Also:
-
supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers()- See Also:
-
supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers()- See Also:
-
supportsMultipleOpenResults
public boolean supportsMultipleOpenResults()- See Also:
-
supportsMultipleResultSets
public boolean supportsMultipleResultSets()- See Also:
-
supportsMultipleTransactions
public boolean supportsMultipleTransactions()- See Also:
-
supportsNamedParameters
public boolean supportsNamedParameters()- See Also:
-
supportsNonNullableColumns
public boolean supportsNonNullableColumns()- See Also:
-
supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit()- See Also:
-
supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback()- See Also:
-
supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit()- See Also:
-
supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback()- See Also:
-
supportsOuterJoins
public boolean supportsOuterJoins()- See Also:
-
supportsPositionedDelete
public boolean supportsPositionedDelete()- See Also:
-
supportsPositionedUpdate
public boolean supportsPositionedUpdate()- See Also:
-
supportsResultSetConcurrency
public boolean supportsResultSetConcurrency(int t, int c) - See Also:
-
supportsResultSetHoldability
public boolean supportsResultSetHoldability(int h) - See Also:
-
supportsResultSetType
public boolean supportsResultSetType(int t) - See Also:
-
supportsSavepoints
public boolean supportsSavepoints()- See Also:
-
supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation()- See Also:
-
supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions()- See Also:
-
supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions()- See Also:
-
supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls()- See Also:
-
supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions()- See Also:
-
supportsSelectForUpdate
public boolean supportsSelectForUpdate()- See Also:
-
supportsStatementPooling
public boolean supportsStatementPooling()- See Also:
-
supportsStoredProcedures
public boolean supportsStoredProcedures()- See Also:
-
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons()- See Also:
-
supportsSubqueriesInExists
public boolean supportsSubqueriesInExists()- See Also:
-
supportsSubqueriesInIns
public boolean supportsSubqueriesInIns()- See Also:
-
supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds()- See Also:
-
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames()- See Also:
-
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int level) - See Also:
-
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
- Throws:
SQLException
- See Also:
-
getBestRowIdentifier
public ResultSet getBestRowIdentifier(String c, String s, String t, int scope, boolean n) throws SQLException - Throws:
SQLException
- See Also:
-
getColumnPrivileges
public ResultSet getColumnPrivileges(String c, String s, String t, String colPat) throws SQLException - Throws:
SQLException
- See Also:
-
getColumns
public ResultSet getColumns(String c, String s, String tblNamePattern, String colNamePattern) throws SQLException - Throws:
SQLException
- See Also:
-
getCrossReference
public ResultSet getCrossReference(String pc, String ps, String pt, String fc, String fs, String ft) throws SQLException - Throws:
SQLException
- See Also:
-
getSchemas
- Throws:
SQLException
- See Also:
-
getCatalogs
- Throws:
SQLException
- See Also:
-
getPrimaryKeys
- Throws:
SQLException
- See Also:
-
getExportedKeys
- Throws:
SQLException
- See Also:
-
appendDummyForeignKeyList
-
getImportedKeys
- Throws:
SQLException
- See Also:
-
getIndexInfo
public ResultSet getIndexInfo(String c, String s, String table, boolean u, boolean approximate) throws SQLException - Throws:
SQLException
- See Also:
-
getProcedureColumns
public ResultSet getProcedureColumns(String c, String s, String p, String colPat) throws SQLException - Throws:
SQLException
- See Also:
-
getProcedures
- Throws:
SQLException
- See Also:
-
getSuperTables
- Throws:
SQLException
- See Also:
-
getSuperTypes
- Throws:
SQLException
- See Also:
-
getTablePrivileges
- Throws:
SQLException
- See Also:
-
getTables
public ResultSet getTables(String c, String s, String tblNamePattern, String[] types) throws SQLException - Throws:
SQLException
- See Also:
-
getTableTypes
- Throws:
SQLException
- See Also:
-
getTypeInfo
- Throws:
SQLException
- See Also:
-
getUDTs
- Throws:
SQLException
- See Also:
-
getVersionColumns
- Throws:
SQLException
- See Also:
-
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:
-
unquoteIdentifier
Follow rules in SQLite Keywords- Parameters:
name
- Identifier name- Returns:
- Unquoted identifier
-