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
public abstract class JDBC3DatabaseMetaData extends CoreDatabaseMetaData
-
-
Field Summary
Fields Modifier and Type Field Description protected static Pattern
PK_NAMED_PATTERN
Pattern used to extract a named primary key.protected static Pattern
PK_UNNAMED_PATTERN
Pattern used to extract column order for an unnamed primary key.protected static Pattern
TYPE_FLOAT
protected static Pattern
TYPE_INTEGER
protected static Pattern
TYPE_VARCHAR
-
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 Modifier Constructor Description protected
JDBC3DatabaseMetaData(SQLiteConnection conn)
-
Method Summary
-
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 Detail
-
TYPE_INTEGER
protected static final Pattern TYPE_INTEGER
-
TYPE_VARCHAR
protected static final Pattern TYPE_VARCHAR
-
TYPE_FLOAT
protected static final Pattern TYPE_FLOAT
-
PK_UNNAMED_PATTERN
protected static final Pattern PK_UNNAMED_PATTERN
Pattern used to extract column order for an unnamed primary key.
-
PK_NAMED_PATTERN
protected static final Pattern PK_NAMED_PATTERN
Pattern used to extract a named primary key.
-
-
Constructor Detail
-
JDBC3DatabaseMetaData
protected JDBC3DatabaseMetaData(SQLiteConnection conn)
-
-
Method Detail
-
getConnection
public Connection getConnection()
- See Also:
DatabaseMetaData.getConnection()
-
getDatabaseMajorVersion
public int getDatabaseMajorVersion() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.getDatabaseMajorVersion()
-
getDatabaseMinorVersion
public int getDatabaseMinorVersion() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.getDatabaseMinorVersion()
-
getDriverMajorVersion
public int getDriverMajorVersion()
- See Also:
DatabaseMetaData.getDriverMajorVersion()
-
getDriverMinorVersion
public int getDriverMinorVersion()
- See Also:
DatabaseMetaData.getDriverMinorVersion()
-
getJDBCMajorVersion
public int getJDBCMajorVersion()
- See Also:
DatabaseMetaData.getJDBCMajorVersion()
-
getJDBCMinorVersion
public int getJDBCMinorVersion()
- See Also:
DatabaseMetaData.getJDBCMinorVersion()
-
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:
DatabaseMetaData.getMaxColumnsInIndex()
-
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy()
-
getMaxColumnsInSelect
public int getMaxColumnsInSelect()
- See Also:
DatabaseMetaData.getMaxColumnsInSelect()
-
getMaxColumnsInTable
public int getMaxColumnsInTable()
- See Also:
DatabaseMetaData.getMaxColumnsInTable()
-
getMaxConnections
public int getMaxConnections()
- See Also:
DatabaseMetaData.getMaxConnections()
-
getMaxCursorNameLength
public int getMaxCursorNameLength()
-
getMaxIndexLength
public int getMaxIndexLength()
- See Also:
DatabaseMetaData.getMaxIndexLength()
-
getMaxProcedureNameLength
public int getMaxProcedureNameLength()
-
getMaxRowSize
public int getMaxRowSize()
- See Also:
DatabaseMetaData.getMaxRowSize()
-
getMaxSchemaNameLength
public int getMaxSchemaNameLength()
-
getMaxStatementLength
public int getMaxStatementLength()
- See Also:
DatabaseMetaData.getMaxStatementLength()
-
getMaxStatements
public int getMaxStatements()
- See Also:
DatabaseMetaData.getMaxStatements()
-
getMaxTableNameLength
public int getMaxTableNameLength()
- See Also:
DatabaseMetaData.getMaxTableNameLength()
-
getMaxTablesInSelect
public int getMaxTablesInSelect()
- See Also:
DatabaseMetaData.getMaxTablesInSelect()
-
getMaxUserNameLength
public int getMaxUserNameLength()
- See Also:
DatabaseMetaData.getMaxUserNameLength()
-
getResultSetHoldability
public int getResultSetHoldability()
-
getSQLStateType
public int getSQLStateType()
- See Also:
DatabaseMetaData.getSQLStateType()
-
getDatabaseProductName
public String getDatabaseProductName()
-
getDatabaseProductVersion
public String getDatabaseProductVersion() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.getDatabaseProductVersion()
-
getDriverName
public String getDriverName()
- See Also:
DatabaseMetaData.getDriverName()
-
getDriverVersion
public String getDriverVersion()
- See Also:
DatabaseMetaData.getDriverVersion()
-
getExtraNameCharacters
public String getExtraNameCharacters()
-
getCatalogSeparator
public String getCatalogSeparator()
- See Also:
DatabaseMetaData.getCatalogSeparator()
-
getCatalogTerm
public String getCatalogTerm()
- See Also:
DatabaseMetaData.getCatalogTerm()
-
getSchemaTerm
public String getSchemaTerm()
- See Also:
DatabaseMetaData.getSchemaTerm()
-
getProcedureTerm
public String getProcedureTerm()
- See Also:
DatabaseMetaData.getProcedureTerm()
-
getSearchStringEscape
public String getSearchStringEscape()
- See Also:
DatabaseMetaData.getSearchStringEscape()
-
getIdentifierQuoteString
public String getIdentifierQuoteString()
-
getSQLKeywords
public String getSQLKeywords()
- See Also:
DatabaseMetaData.getSQLKeywords()
, SQLite Keywords
-
getNumericFunctions
public String getNumericFunctions()
- See Also:
DatabaseMetaData.getNumericFunctions()
-
getStringFunctions
public String getStringFunctions()
- See Also:
DatabaseMetaData.getStringFunctions()
-
getSystemFunctions
public String getSystemFunctions()
- See Also:
DatabaseMetaData.getSystemFunctions()
-
getTimeDateFunctions
public String getTimeDateFunctions()
- See Also:
DatabaseMetaData.getTimeDateFunctions()
-
getURL
public String getURL()
- See Also:
DatabaseMetaData.getURL()
-
getUserName
public String getUserName()
- See Also:
DatabaseMetaData.getUserName()
-
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:
DatabaseMetaData.deletesAreDetected(int)
-
insertsAreDetected
public boolean insertsAreDetected(int type)
- See Also:
DatabaseMetaData.insertsAreDetected(int)
-
isCatalogAtStart
public boolean isCatalogAtStart()
- See Also:
DatabaseMetaData.isCatalogAtStart()
-
locatorsUpdateCopy
public boolean locatorsUpdateCopy()
- See Also:
DatabaseMetaData.locatorsUpdateCopy()
-
nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull()
- See Also:
DatabaseMetaData.nullPlusNonNullIsNull()
-
nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd()
- See Also:
DatabaseMetaData.nullsAreSortedAtEnd()
-
nullsAreSortedAtStart
public boolean nullsAreSortedAtStart()
- See Also:
DatabaseMetaData.nullsAreSortedAtStart()
-
nullsAreSortedHigh
public boolean nullsAreSortedHigh()
- See Also:
DatabaseMetaData.nullsAreSortedHigh()
-
nullsAreSortedLow
public boolean nullsAreSortedLow()
- See Also:
DatabaseMetaData.nullsAreSortedLow()
-
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:
DatabaseMetaData.supportsANSI92FullSQL()
-
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL()
-
supportsBatchUpdates
public boolean supportsBatchUpdates()
- See Also:
DatabaseMetaData.supportsBatchUpdates()
-
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:
DatabaseMetaData.supportsConvert()
-
supportsConvert
public boolean supportsConvert(int fromType, int toType)
-
supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries()
-
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
public boolean supportsFullOuterJoins() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.supportsFullOuterJoins()
-
supportsGetGeneratedKeys
public boolean supportsGetGeneratedKeys()
-
supportsGroupBy
public boolean supportsGroupBy()
- See Also:
DatabaseMetaData.supportsGroupBy()
-
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect()
-
supportsGroupByUnrelated
public boolean supportsGroupByUnrelated()
-
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()
-
supportsOrderByUnrelated
public boolean supportsOrderByUnrelated()
-
supportsOuterJoins
public boolean supportsOuterJoins()
- See Also:
DatabaseMetaData.supportsOuterJoins()
-
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:
DatabaseMetaData.supportsSavepoints()
-
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:
DatabaseMetaData.supportsTransactions()
-
supportsUnion
public boolean supportsUnion()
- See Also:
DatabaseMetaData.supportsUnion()
-
supportsUnionAll
public boolean supportsUnionAll()
- See Also:
DatabaseMetaData.supportsUnionAll()
-
updatesAreDetected
public boolean updatesAreDetected(int type)
- See Also:
DatabaseMetaData.updatesAreDetected(int)
-
usesLocalFilePerTable
public boolean usesLocalFilePerTable()
- See Also:
DatabaseMetaData.usesLocalFilePerTable()
-
usesLocalFiles
public boolean usesLocalFiles()
- See Also:
DatabaseMetaData.usesLocalFiles()
-
isReadOnly
public boolean isReadOnly() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.isReadOnly()
-
getAttributes
public ResultSet getAttributes(String c, String s, String t, String a) throws SQLException
-
getBestRowIdentifier
public ResultSet getBestRowIdentifier(String c, String s, String t, int scope, boolean n) throws SQLException
-
getColumnPrivileges
public ResultSet getColumnPrivileges(String c, String s, String t, String colPat) throws SQLException
-
getColumns
public ResultSet getColumns(String c, String s, String tblNamePattern, String colNamePattern) throws SQLException
-
getCrossReference
public ResultSet getCrossReference(String pc, String ps, String pt, String fc, String fs, String ft) throws SQLException
-
getSchemas
public ResultSet getSchemas() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.getSchemas()
-
getCatalogs
public ResultSet getCatalogs() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.getCatalogs()
-
getPrimaryKeys
public ResultSet getPrimaryKeys(String c, String s, String table) throws SQLException
-
getExportedKeys
public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException
-
getImportedKeys
public ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException
-
getIndexInfo
public ResultSet getIndexInfo(String c, String s, String table, boolean u, boolean approximate) throws SQLException
-
getProcedureColumns
public ResultSet getProcedureColumns(String c, String s, String p, String colPat) throws SQLException
-
getProcedures
public ResultSet getProcedures(String c, String s, String p) throws SQLException
-
getSuperTables
public ResultSet getSuperTables(String c, String s, String t) throws SQLException
-
getSuperTypes
public ResultSet getSuperTypes(String c, String s, String t) throws SQLException
-
getTablePrivileges
public ResultSet getTablePrivileges(String c, String s, String t) throws SQLException
-
getTables
public ResultSet getTables(String c, String s, String tblNamePattern, String[] types) throws SQLException
-
getTableTypes
public ResultSet getTableTypes() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.getTableTypes()
-
getTypeInfo
public ResultSet getTypeInfo() throws SQLException
- Throws:
SQLException
- See Also:
DatabaseMetaData.getTypeInfo()
-
getUDTs
public ResultSet getUDTs(String c, String s, String t, int[] types) throws SQLException
-
getVersionColumns
public ResultSet getVersionColumns(String c, String s, String t) throws SQLException
-
getGeneratedKeys
@Deprecated public ResultSet getGeneratedKeys() throws SQLException
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
public Struct createStruct(String t, Object[] attr) throws SQLException
Not implemented yet.- Throws:
SQLException
-
getFunctionColumns
public ResultSet getFunctionColumns(String a, String b, String c, String d) throws SQLException
Not implemented yet.- Throws:
SQLException
-
finalize
protected void finalize() throws Throwable
- Overrides:
finalize
in classCoreDatabaseMetaData
- Throws:
Throwable
- See Also:
Object.finalize()
-
-