|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.sqlite.jdbc.JdbcDatabaseMetaData
public class JdbcDatabaseMetaData
| Field Summary |
|---|
| Fields inherited from interface java.sql.DatabaseMetaData |
|---|
attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown |
| Method Summary | |
|---|---|
boolean |
allProceduresAreCallable()
It always returns false. |
boolean |
allTablesAreSelectable()
It always returns true. |
boolean |
dataDefinitionCausesTransactionCommit()
It always returns false. |
boolean |
dataDefinitionIgnoredInTransactions()
It always returns false. |
boolean |
deletesAreDetected(int type)
It always returns false. |
boolean |
doesMaxRowSizeIncludeBlobs()
It always returns true. |
java.sql.ResultSet |
getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern)
Not suppoted yet. |
java.sql.ResultSet |
getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable)
|
java.sql.ResultSet |
getCatalogs()
Catalog is not suppoted yet. |
java.lang.String |
getCatalogSeparator()
Catalog is not supported yet. |
java.lang.String |
getCatalogTerm()
Catalog is not supported yet. |
static java.lang.String |
getColumnClassName(int columnType)
|
static int |
getColumnDisplaySize(int columnType)
|
java.sql.ResultSet |
getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern)
Not suppoted yet. |
java.sql.ResultSet |
getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
|
static int |
getColumnType(int columnType)
|
java.sql.Connection |
getConnection()
|
java.sql.ResultSet |
getCrossReference(java.lang.String parentCatalog,
java.lang.String parentSchema,
java.lang.String parentTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTable)
|
java.util.List<DatabaseList> |
getDatabaseList()
execute 'PRAGMA database_list' query. |
int |
getDatabaseMajorVersion()
invoke sqlite3_libversion_number() function. |
int |
getDatabaseMinorVersion()
invoke sqlite3_libversion_number() function. |
java.lang.String |
getDatabaseProductName()
invoke org.sqlite.Database#getProductName() function. |
java.lang.String |
getDatabaseProductVersion()
invoke sqlite3_libversion() function. |
int |
getDefaultTransactionIsolation()
It always returns TRANSACTION_SERIALIZABLE. |
int |
getDriverMajorVersion()
invoke org.sqlite.Driver#getDriverMajorVersion() function. |
int |
getDriverMinorVersion()
invoke org.sqlite.Driver#getDriverMinorVersion() function. |
java.lang.String |
getDriverName()
invoke org.sqlite.Driver#getDriverName() function. |
java.lang.String |
getDriverVersion()
invoke org.sqlite.Driver#getDriverVersion() function. |
java.sql.ResultSet |
getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
|
java.lang.String |
getExtraNameCharacters()
It always returns empty string. |
java.util.List<ForeignKeyList> |
getForeignKeyList(java.lang.String tableName)
execute 'PRAGMA foreign_key_list(table-name)' query. |
java.lang.String |
getIdentifierQuoteString()
It always returns double quotes ("). |
java.sql.ResultSet |
getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
|
java.util.List<IndexInfo> |
getIndexInfo(java.lang.String indexName)
execute 'PRAGMA index_info(index-name)' query. |
java.sql.ResultSet |
getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
|
java.util.List<IndexList> |
getIndexList(java.lang.String tableName)
execute 'PRAGMA index_list(table-name)' query. |
int |
getJDBCMajorVersion()
It always returns 3. |
int |
getJDBCMinorVersion()
It always returns 0. |
int |
getMaxBinaryLiteralLength()
It always returns 0. |
int |
getMaxCatalogNameLength()
Catalog is not supported yet. |
int |
getMaxCharLiteralLength()
It always returns 0. |
int |
getMaxColumnNameLength()
It always returns 0. |
int |
getMaxColumnsInGroupBy()
It always returns 0. |
int |
getMaxColumnsInIndex()
It always returns 0. |
int |
getMaxColumnsInOrderBy()
It always returns 0. |
int |
getMaxColumnsInSelect()
It always returns 0. |
int |
getMaxColumnsInTable()
It always returns 0. |
int |
getMaxConnections()
It always returns 0. |
int |
getMaxCursorNameLength()
Cursor is not supported yet. |
int |
getMaxIndexLength()
It always returns 0. |
int |
getMaxProcedureNameLength()
Procedure is not supported yet. |
int |
getMaxRowSize()
It always returns 0. |
int |
getMaxSchemaNameLength()
Schema name is not supported yet. |
int |
getMaxStatementLength()
It always returns 0. |
int |
getMaxStatements()
It always returns 0. |
int |
getMaxTableNameLength()
It always returns 0. |
int |
getMaxTablesInSelect()
It always returns 64. |
int |
getMaxUserNameLength()
User name is not supported yet. |
java.lang.String |
getNumericFunctions()
It always returns empty string. |
static int |
getPrecision(int columnType)
|
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
|
java.sql.ResultSet |
getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
Procedure is not suppoted yet. |
java.sql.ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
Procedure is not suppoted yet. |
java.lang.String |
getProcedureTerm()
Procedure is not supported yet. |
static int |
getRadix(int columnType)
|
int |
getResultSetHoldability()
It always returns ResultSet.CLOSE_CURSORS_AT_COMMIT. |
static int |
getScale(int columnType)
|
java.sql.ResultSet |
getSchemas()
Retrieves th open database list. |
java.lang.String |
getSchemaTerm()
Schema is not supported yet. |
java.lang.String |
getSearchStringEscape()
Escape charactor is NOTHING. |
java.lang.String |
getSQLKeywords()
It always returns empty string. |
int |
getSQLStateType()
It always returns sqlStateSQL99. |
java.lang.String |
getStringFunctions()
It always returns empty string. |
java.sql.ResultSet |
getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
Not suppoted yet. |
java.sql.ResultSet |
getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern)
Not suppoted yet. |
java.lang.String |
getSystemFunctions()
It always returns empty string. |
java.util.List<TableInfo> |
getTableInfo(java.lang.String tableName)
execute 'PRAGMA table_info(table-name)' query. |
java.sql.ResultSet |
getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
Not suppoted yet. |
java.sql.ResultSet |
getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
|
java.sql.ResultSet |
getTableTypes()
It always returns "TABLE" and "VIEW". |
java.lang.String |
getTimeDateFunctions()
|
java.sql.ResultSet |
getTypeInfo()
|
java.sql.ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
UDT is not supported yet. |
java.lang.String |
getURL()
Retrieves the URL for this DBMS. |
java.lang.String |
getUserName()
It always returns null. |
java.sql.ResultSet |
getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Not suppoted yet. |
boolean |
insertsAreDetected(int type)
It always returns false. |
boolean |
isCatalogAtStart()
Catalog is not supported yet. |
boolean |
isReadOnly()
invoke JdbcConnection#isReadOnly() method. |
static boolean |
isSigned(int columnType)
|
boolean |
locatorsUpdateCopy()
It always returns false. |
boolean |
nullPlusNonNullIsNull()
It always returns true. |
boolean |
nullsAreSortedAtEnd()
It always returns false. |
boolean |
nullsAreSortedAtStart()
It always returns false. |
boolean |
nullsAreSortedHigh()
It always returns false. |
boolean |
nullsAreSortedLow()
It always returns true. |
boolean |
othersDeletesAreVisible(int type)
It always returns false. |
boolean |
othersInsertsAreVisible(int type)
It always returns false. |
boolean |
othersUpdatesAreVisible(int type)
It always returns false. |
boolean |
ownDeletesAreVisible(int type)
It always returns false. |
boolean |
ownInsertsAreVisible(int type)
It always returns false. |
boolean |
ownUpdatesAreVisible(int type)
It always returns false. |
boolean |
storesLowerCaseIdentifiers()
It always returns false. |
boolean |
storesLowerCaseQuotedIdentifiers()
It always returns false. |
boolean |
storesMixedCaseIdentifiers()
It always returns true. |
boolean |
storesMixedCaseQuotedIdentifiers()
It always returns true. |
boolean |
storesUpperCaseIdentifiers()
It always returns false. |
boolean |
storesUpperCaseQuotedIdentifiers()
It always returns false. |
boolean |
supportsAlterTableWithAddColumn()
Supported by SQLite 3.0.0 or later. |
boolean |
supportsAlterTableWithDropColumn()
It always returns false. |
boolean |
supportsANSI92EntryLevelSQL()
It always returns true. |
boolean |
supportsANSI92FullSQL()
It always returns false. |
boolean |
supportsANSI92IntermediateSQL()
It always returns false. |
boolean |
supportsBatchUpdates()
It always returns true. |
boolean |
supportsCatalogsInDataManipulation()
It always returns false. |
boolean |
supportsCatalogsInIndexDefinitions()
It always returns false. |
boolean |
supportsCatalogsInPrivilegeDefinitions()
It always returns false. |
boolean |
supportsCatalogsInProcedureCalls()
It always returns false. |
boolean |
supportsCatalogsInTableDefinitions()
It always returns false. |
boolean |
supportsColumnAliasing()
It always returns true. |
boolean |
supportsConvert()
It always returns false. |
boolean |
supportsConvert(int fromType,
int toType)
It always returns false. |
boolean |
supportsCoreSQLGrammar()
It always returns false. |
boolean |
supportsCorrelatedSubqueries()
It always returns true. |
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
It always returns true. |
boolean |
supportsDataManipulationTransactionsOnly()
It always returns false. |
boolean |
supportsDifferentTableCorrelationNames()
It always returns false. |
boolean |
supportsExpressionsInOrderBy()
It always returns true. |
boolean |
supportsExtendedSQLGrammar()
It always returns false. |
boolean |
supportsFullOuterJoins()
It always returns false. |
boolean |
supportsGetGeneratedKeys()
Supported by sqlite3_last_insert_rowid() function. |
boolean |
supportsGroupBy()
It always returns true. |
boolean |
supportsGroupByBeyondSelect()
It always returns true. |
boolean |
supportsGroupByUnrelated()
It always returns true. |
boolean |
supportsIntegrityEnhancementFacility()
It always returns false. |
boolean |
supportsLikeEscapeClause()
It always returns true. |
boolean |
supportsLimitedOuterJoins()
It always returns true. |
boolean |
supportsMinimumSQLGrammar()
It always returns false. |
boolean |
supportsMixedCaseIdentifiers()
It always returns false. |
boolean |
supportsMixedCaseQuotedIdentifiers()
It always returns false. |
boolean |
supportsMultipleOpenResults()
CallableStatement is not supported yet. |
boolean |
supportsMultipleResultSets()
It always returns true. |
boolean |
supportsMultipleTransactions()
It always returns true. |
boolean |
supportsNamedParameters()
It always returns true. |
boolean |
supportsNonNullableColumns()
It always returns true. |
boolean |
supportsOpenCursorsAcrossCommit()
It always returns false. |
boolean |
supportsOpenCursorsAcrossRollback()
It always returns false. |
boolean |
supportsOpenStatementsAcrossCommit()
It always returns false. |
boolean |
supportsOpenStatementsAcrossRollback()
It always returns false. |
boolean |
supportsOrderByUnrelated()
It always returns true. |
boolean |
supportsOuterJoins()
It always returns true. |
boolean |
supportsPositionedDelete()
It always returns false. |
boolean |
supportsPositionedUpdate()
It always returns false. |
boolean |
supportsResultSetConcurrency(int type,
int concurrency)
Supported type is ResultSet.TYPE_FORWARD_ONLY and concurrency is ResultSet.CONCUR_READ_ONLY only. |
boolean |
supportsResultSetHoldability(int holdability)
Supported type is ResultSet.CLOSE_CURSORS_AT_COMMIT only. |
boolean |
supportsResultSetType(int type)
Supported type is ResultSet.TYPE_FORWARD_ONLY only. |
boolean |
supportsSavepoints()
It always returns false. |
boolean |
supportsSchemasInDataManipulation()
It always returns false. |
boolean |
supportsSchemasInIndexDefinitions()
It always returns false. |
boolean |
supportsSchemasInPrivilegeDefinitions()
It always returns false. |
boolean |
supportsSchemasInProcedureCalls()
It always returns false. |
boolean |
supportsSchemasInTableDefinitions()
It always returns false. |
boolean |
supportsSelectForUpdate()
It always returns false. |
boolean |
supportsStatementPooling()
It always returns false. |
boolean |
supportsStoredProcedures()
It always returns false. |
boolean |
supportsSubqueriesInComparisons()
It always returns true. |
boolean |
supportsSubqueriesInExists()
It always returns true. |
boolean |
supportsSubqueriesInIns()
It always returns true. |
boolean |
supportsSubqueriesInQuantifieds()
It always returns false. |
boolean |
supportsTableCorrelationNames()
It always returns true. |
boolean |
supportsTransactionIsolationLevel(int level)
|
boolean |
supportsTransactions()
It always returns true. |
boolean |
supportsUnion()
It always returns true. |
boolean |
supportsUnionAll()
It always returns true. |
boolean |
updatesAreDetected(int type)
It always returns false. |
boolean |
usesLocalFilePerTable()
It always returns false. |
boolean |
usesLocalFiles()
false is returned for the in-memory database. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Method Detail |
|---|
public boolean allProceduresAreCallable()
allProceduresAreCallable in interface java.sql.DatabaseMetaDatapublic boolean allTablesAreSelectable()
allTablesAreSelectable in interface java.sql.DatabaseMetaDatapublic java.lang.String getURL()
getURL in interface java.sql.DatabaseMetaDatapublic java.lang.String getUserName()
getUserName in interface java.sql.DatabaseMetaData
public boolean isReadOnly()
throws java.sql.SQLException
isReadOnly in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionJdbcConnection.isReadOnly()public boolean nullsAreSortedHigh()
nullsAreSortedHigh in interface java.sql.DatabaseMetaDatapublic boolean nullsAreSortedLow()
nullsAreSortedLow in interface java.sql.DatabaseMetaDatapublic boolean nullsAreSortedAtStart()
nullsAreSortedAtStart in interface java.sql.DatabaseMetaDatapublic boolean nullsAreSortedAtEnd()
nullsAreSortedAtEnd in interface java.sql.DatabaseMetaDatapublic java.lang.String getDatabaseProductName()
getDatabaseProductName in interface java.sql.DatabaseMetaDataDatabase.getProductName()public java.lang.String getDatabaseProductVersion()
getDatabaseProductVersion in interface java.sql.DatabaseMetaDatapublic java.lang.String getDriverName()
getDriverName in interface java.sql.DatabaseMetaDataDriver.getDriverName()public java.lang.String getDriverVersion()
getDriverVersion in interface java.sql.DatabaseMetaDataDriver.getDriverVersion()public int getDriverMajorVersion()
getDriverMajorVersion in interface java.sql.DatabaseMetaDataDriver.getDriverMajorVersion()public int getDriverMinorVersion()
getDriverMinorVersion in interface java.sql.DatabaseMetaDataDriver.getDriverMinorVersion()public boolean usesLocalFiles()
usesLocalFiles in interface java.sql.DatabaseMetaDataDatabase.isInMemoryMode()public boolean usesLocalFilePerTable()
usesLocalFilePerTable in interface java.sql.DatabaseMetaDatapublic boolean supportsMixedCaseIdentifiers()
supportsMixedCaseIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesUpperCaseIdentifiers()
storesUpperCaseIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesLowerCaseIdentifiers()
storesLowerCaseIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesMixedCaseIdentifiers()
storesMixedCaseIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean supportsMixedCaseQuotedIdentifiers()
supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesUpperCaseQuotedIdentifiers()
storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesLowerCaseQuotedIdentifiers()
storesLowerCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesMixedCaseQuotedIdentifiers()
storesMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatapublic java.lang.String getIdentifierQuoteString()
getIdentifierQuoteString in interface java.sql.DatabaseMetaDatapublic java.lang.String getSQLKeywords()
getSQLKeywords in interface java.sql.DatabaseMetaDatapublic java.lang.String getNumericFunctions()
getNumericFunctions in interface java.sql.DatabaseMetaDatapublic java.lang.String getStringFunctions()
getStringFunctions in interface java.sql.DatabaseMetaDatapublic java.lang.String getSystemFunctions()
getSystemFunctions in interface java.sql.DatabaseMetaDatapublic java.lang.String getTimeDateFunctions()
getTimeDateFunctions in interface java.sql.DatabaseMetaDatapublic java.lang.String getSearchStringEscape()
getSearchStringEscape in interface java.sql.DatabaseMetaDatapublic java.lang.String getExtraNameCharacters()
getExtraNameCharacters in interface java.sql.DatabaseMetaDatapublic boolean supportsAlterTableWithAddColumn()
supportsAlterTableWithAddColumn in interface java.sql.DatabaseMetaDatapublic boolean supportsAlterTableWithDropColumn()
supportsAlterTableWithDropColumn in interface java.sql.DatabaseMetaDatapublic boolean supportsColumnAliasing()
supportsColumnAliasing in interface java.sql.DatabaseMetaDatapublic boolean nullPlusNonNullIsNull()
nullPlusNonNullIsNull in interface java.sql.DatabaseMetaDatapublic boolean supportsConvert()
supportsConvert in interface java.sql.DatabaseMetaData
public boolean supportsConvert(int fromType,
int toType)
supportsConvert in interface java.sql.DatabaseMetaDatafromType - ignoredtoType - ignored
public boolean supportsTableCorrelationNames()
supportsTableCorrelationNames in interface java.sql.DatabaseMetaDatapublic boolean supportsDifferentTableCorrelationNames()
supportsDifferentTableCorrelationNames in interface java.sql.DatabaseMetaDatapublic boolean supportsExpressionsInOrderBy()
supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaDatapublic boolean supportsOrderByUnrelated()
supportsOrderByUnrelated in interface java.sql.DatabaseMetaDatapublic boolean supportsGroupBy()
supportsGroupBy in interface java.sql.DatabaseMetaDatapublic boolean supportsGroupByUnrelated()
supportsGroupByUnrelated in interface java.sql.DatabaseMetaDatapublic boolean supportsGroupByBeyondSelect()
supportsGroupByBeyondSelect in interface java.sql.DatabaseMetaDatapublic boolean supportsLikeEscapeClause()
supportsLikeEscapeClause in interface java.sql.DatabaseMetaDatapublic boolean supportsMultipleResultSets()
supportsMultipleResultSets in interface java.sql.DatabaseMetaDataJdbcStatement.execute(String),
JdbcStatement.getMoreResults(),
JdbcStatement.getMoreResults(int)public boolean supportsMultipleTransactions()
supportsMultipleTransactions in interface java.sql.DatabaseMetaDatapublic boolean supportsNonNullableColumns()
supportsNonNullableColumns in interface java.sql.DatabaseMetaDatapublic boolean supportsMinimumSQLGrammar()
supportsMinimumSQLGrammar in interface java.sql.DatabaseMetaDatapublic boolean supportsCoreSQLGrammar()
supportsCoreSQLGrammar in interface java.sql.DatabaseMetaDatapublic boolean supportsExtendedSQLGrammar()
supportsExtendedSQLGrammar in interface java.sql.DatabaseMetaDatapublic boolean supportsANSI92EntryLevelSQL()
supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaDatapublic boolean supportsANSI92IntermediateSQL()
supportsANSI92IntermediateSQL in interface java.sql.DatabaseMetaDatapublic boolean supportsANSI92FullSQL()
supportsANSI92FullSQL in interface java.sql.DatabaseMetaDatapublic boolean supportsIntegrityEnhancementFacility()
supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaDatapublic boolean supportsOuterJoins()
supportsOuterJoins in interface java.sql.DatabaseMetaDatapublic boolean supportsFullOuterJoins()
supportsFullOuterJoins in interface java.sql.DatabaseMetaDatapublic boolean supportsLimitedOuterJoins()
supportsLimitedOuterJoins in interface java.sql.DatabaseMetaDatapublic java.lang.String getSchemaTerm()
getSchemaTerm in interface java.sql.DatabaseMetaDatapublic java.lang.String getProcedureTerm()
getProcedureTerm in interface java.sql.DatabaseMetaDatapublic java.lang.String getCatalogTerm()
getCatalogTerm in interface java.sql.DatabaseMetaDatapublic boolean isCatalogAtStart()
isCatalogAtStart in interface java.sql.DatabaseMetaDatapublic java.lang.String getCatalogSeparator()
getCatalogSeparator in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInDataManipulation()
supportsSchemasInDataManipulation in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInProcedureCalls()
supportsSchemasInProcedureCalls in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInTableDefinitions()
supportsSchemasInTableDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInIndexDefinitions()
supportsSchemasInIndexDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInPrivilegeDefinitions()
supportsSchemasInPrivilegeDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInDataManipulation()
supportsCatalogsInDataManipulation in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInProcedureCalls()
supportsCatalogsInProcedureCalls in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInTableDefinitions()
supportsCatalogsInTableDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInIndexDefinitions()
supportsCatalogsInIndexDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInPrivilegeDefinitions()
supportsCatalogsInPrivilegeDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsPositionedDelete()
supportsPositionedDelete in interface java.sql.DatabaseMetaDatapublic boolean supportsPositionedUpdate()
supportsPositionedUpdate in interface java.sql.DatabaseMetaDatapublic boolean supportsSelectForUpdate()
supportsSelectForUpdate in interface java.sql.DatabaseMetaDatapublic boolean supportsStoredProcedures()
supportsStoredProcedures in interface java.sql.DatabaseMetaDatapublic boolean supportsSubqueriesInComparisons()
supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaDatapublic boolean supportsSubqueriesInExists()
supportsSubqueriesInExists in interface java.sql.DatabaseMetaDatapublic boolean supportsSubqueriesInIns()
supportsSubqueriesInIns in interface java.sql.DatabaseMetaDatapublic boolean supportsSubqueriesInQuantifieds()
supportsSubqueriesInQuantifieds in interface java.sql.DatabaseMetaDatapublic boolean supportsCorrelatedSubqueries()
supportsCorrelatedSubqueries in interface java.sql.DatabaseMetaDatapublic boolean supportsUnion()
supportsUnion in interface java.sql.DatabaseMetaDatapublic boolean supportsUnionAll()
supportsUnionAll in interface java.sql.DatabaseMetaDatapublic boolean supportsOpenCursorsAcrossCommit()
supportsOpenCursorsAcrossCommit in interface java.sql.DatabaseMetaDatapublic boolean supportsOpenCursorsAcrossRollback()
supportsOpenCursorsAcrossRollback in interface java.sql.DatabaseMetaDatapublic boolean supportsOpenStatementsAcrossCommit()
supportsOpenStatementsAcrossCommit in interface java.sql.DatabaseMetaDatapublic boolean supportsOpenStatementsAcrossRollback()
supportsOpenStatementsAcrossRollback in interface java.sql.DatabaseMetaDatapublic int getMaxBinaryLiteralLength()
getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaDatapublic int getMaxCharLiteralLength()
getMaxCharLiteralLength in interface java.sql.DatabaseMetaDatapublic int getMaxColumnNameLength()
getMaxColumnNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInGroupBy()
getMaxColumnsInGroupBy in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInIndex()
getMaxColumnsInIndex in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInOrderBy()
getMaxColumnsInOrderBy in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInSelect()
getMaxColumnsInSelect in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInTable()
getMaxColumnsInTable in interface java.sql.DatabaseMetaDatapublic int getMaxConnections()
getMaxConnections in interface java.sql.DatabaseMetaDatapublic int getMaxCursorNameLength()
getMaxCursorNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxIndexLength()
getMaxIndexLength in interface java.sql.DatabaseMetaDatapublic int getMaxSchemaNameLength()
getMaxSchemaNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxProcedureNameLength()
getMaxProcedureNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxCatalogNameLength()
getMaxCatalogNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxRowSize()
getMaxRowSize in interface java.sql.DatabaseMetaDatapublic boolean doesMaxRowSizeIncludeBlobs()
doesMaxRowSizeIncludeBlobs in interface java.sql.DatabaseMetaDatapublic int getMaxStatementLength()
getMaxStatementLength in interface java.sql.DatabaseMetaDatapublic int getMaxStatements()
getMaxStatements in interface java.sql.DatabaseMetaDatapublic int getMaxTableNameLength()
getMaxTableNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxTablesInSelect()
getMaxTablesInSelect in interface java.sql.DatabaseMetaDatapublic int getMaxUserNameLength()
getMaxUserNameLength in interface java.sql.DatabaseMetaDatapublic int getDefaultTransactionIsolation()
getDefaultTransactionIsolation in interface java.sql.DatabaseMetaDatapublic boolean supportsTransactions()
supportsTransactions in interface java.sql.DatabaseMetaDatapublic boolean supportsTransactionIsolationLevel(int level)
supportsTransactionIsolationLevel in interface java.sql.DatabaseMetaDatalevel -
public boolean supportsDataDefinitionAndDataManipulationTransactions()
supportsDataDefinitionAndDataManipulationTransactions in interface java.sql.DatabaseMetaDatapublic boolean supportsDataManipulationTransactionsOnly()
supportsDataManipulationTransactionsOnly in interface java.sql.DatabaseMetaDatapublic boolean dataDefinitionCausesTransactionCommit()
dataDefinitionCausesTransactionCommit in interface java.sql.DatabaseMetaDatapublic boolean dataDefinitionIgnoredInTransactions()
dataDefinitionIgnoredInTransactions in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
throws java.sql.SQLException
getProcedures in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredprocedureNamePattern - ignored
java.sql.SQLException
public java.sql.ResultSet getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
getProcedureColumns in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredprocedureNamePattern - ignored
java.sql.SQLException
public java.sql.ResultSet getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
throws java.sql.SQLException
getTables in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredtableNamePattern - types -
java.sql.SQLException
public java.sql.ResultSet getSchemas()
throws java.sql.SQLException
getSchemas in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.sql.ResultSet getCatalogs()
throws java.sql.SQLException
getCatalogs in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.sql.ResultSet getTableTypes()
throws java.sql.SQLException
getTableTypes in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.sql.ResultSet getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
getColumns in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredtableNamePattern - columnNamePattern -
java.sql.SQLException
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern)
throws java.sql.SQLException
getColumnPrivileges in interface java.sql.DatabaseMetaDatacatalog - ignoredschema - ignoredtable - ignoredcolumnNamePattern - ignored
java.sql.SQLException
public java.sql.ResultSet getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
throws java.sql.SQLException
getTablePrivileges in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredtableNamePattern - ignored
java.sql.SQLException
public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable)
throws java.sql.SQLException
getBestRowIdentifier in interface java.sql.DatabaseMetaDatacatalog - ignoredschema - ignoredtable - scope - ignorednullable -
java.sql.SQLException
public java.sql.ResultSet getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
getVersionColumns in interface java.sql.DatabaseMetaDatacatalog - ignoredschema - ignoredtable - ignored
java.sql.SQLException
public java.sql.ResultSet getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
getPrimaryKeys in interface java.sql.DatabaseMetaDatacatalog - ignoredschema - ignoredtable -
java.sql.SQLException
public java.sql.ResultSet getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
getImportedKeys in interface java.sql.DatabaseMetaDatacatalog - ignoredschema - ignoredtable -
java.sql.SQLException
public java.sql.ResultSet getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
getExportedKeys in interface java.sql.DatabaseMetaDatacatalog - ignoredschema - ignoredtable -
java.sql.SQLException
public java.sql.ResultSet getCrossReference(java.lang.String parentCatalog,
java.lang.String parentSchema,
java.lang.String parentTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTable)
throws java.sql.SQLException
getCrossReference in interface java.sql.DatabaseMetaDataparentCatalog - ignoredparentSchema - ignoredparentTable - foreignCatalog - ignoredforeignSchema - ignoredforeignTable -
java.sql.SQLException
public java.sql.ResultSet getTypeInfo()
throws java.sql.SQLException
getTypeInfo in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.sql.ResultSet getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
throws java.sql.SQLException
getIndexInfo in interface java.sql.DatabaseMetaDatacatalog - ignoredschema - ignoredtable - unique - approximate - ignored
java.sql.SQLExceptionpublic boolean supportsResultSetType(int type)
supportsResultSetType in interface java.sql.DatabaseMetaDatatype -
public boolean supportsResultSetConcurrency(int type,
int concurrency)
supportsResultSetConcurrency in interface java.sql.DatabaseMetaDatatype - concurrency -
public boolean ownUpdatesAreVisible(int type)
ownUpdatesAreVisible in interface java.sql.DatabaseMetaDatatype - ignored
public boolean ownDeletesAreVisible(int type)
ownDeletesAreVisible in interface java.sql.DatabaseMetaDatatype - ignored
public boolean ownInsertsAreVisible(int type)
ownInsertsAreVisible in interface java.sql.DatabaseMetaDatatype - ignored
public boolean othersUpdatesAreVisible(int type)
othersUpdatesAreVisible in interface java.sql.DatabaseMetaDatatype - ignored
public boolean othersDeletesAreVisible(int type)
othersDeletesAreVisible in interface java.sql.DatabaseMetaDatatype - ignored
public boolean othersInsertsAreVisible(int type)
othersInsertsAreVisible in interface java.sql.DatabaseMetaDatatype - ignored
public boolean updatesAreDetected(int type)
updatesAreDetected in interface java.sql.DatabaseMetaDatatype - ignored
public boolean deletesAreDetected(int type)
deletesAreDetected in interface java.sql.DatabaseMetaDatatype - ignored
public boolean insertsAreDetected(int type)
insertsAreDetected in interface java.sql.DatabaseMetaDatatype - ignored
public boolean supportsBatchUpdates()
supportsBatchUpdates in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
throws java.sql.SQLException
getUDTs in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredtypeNamePattern - ignoredtypes - ignored
java.sql.SQLExceptionpublic java.sql.Connection getConnection()
getConnection in interface java.sql.DatabaseMetaDatapublic boolean supportsSavepoints()
supportsSavepoints in interface java.sql.DatabaseMetaDatapublic boolean supportsNamedParameters()
supportsNamedParameters in interface java.sql.DatabaseMetaDatapublic boolean supportsMultipleOpenResults()
supportsMultipleOpenResults in interface java.sql.DatabaseMetaDatapublic boolean supportsGetGeneratedKeys()
supportsGetGeneratedKeys in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern)
throws java.sql.SQLException
getSuperTypes in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredtypeNamePattern - ignored
java.sql.SQLException
public java.sql.ResultSet getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
throws java.sql.SQLException
getSuperTables in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredtableNamePattern - ignored
java.sql.SQLException
public java.sql.ResultSet getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern)
throws java.sql.SQLException
getAttributes in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredtypeNamePattern - ignoredattributeNamePattern - ignored
java.sql.SQLExceptionpublic boolean supportsResultSetHoldability(int holdability)
supportsResultSetHoldability in interface java.sql.DatabaseMetaDataholdability -
public int getResultSetHoldability()
getResultSetHoldability in interface java.sql.DatabaseMetaDataJdbcStatement.getResultSetHoldability()public int getDatabaseMajorVersion()
getDatabaseMajorVersion in interface java.sql.DatabaseMetaDatapublic int getDatabaseMinorVersion()
getDatabaseMinorVersion in interface java.sql.DatabaseMetaDatapublic int getJDBCMajorVersion()
getJDBCMajorVersion in interface java.sql.DatabaseMetaDatapublic int getJDBCMinorVersion()
getJDBCMinorVersion in interface java.sql.DatabaseMetaDatapublic int getSQLStateType()
getSQLStateType in interface java.sql.DatabaseMetaDatapublic boolean locatorsUpdateCopy()
locatorsUpdateCopy in interface java.sql.DatabaseMetaDatapublic boolean supportsStatementPooling()
supportsStatementPooling in interface java.sql.DatabaseMetaData
public java.util.List<DatabaseList> getDatabaseList()
throws java.sql.SQLException
java.sql.SQLException
public java.util.List<TableInfo> getTableInfo(java.lang.String tableName)
throws java.sql.SQLException
tableName -
java.sql.SQLException
public java.util.List<IndexList> getIndexList(java.lang.String tableName)
throws java.sql.SQLException
tableName -
java.sql.SQLException
public java.util.List<IndexInfo> getIndexInfo(java.lang.String indexName)
throws java.sql.SQLException
indexName -
java.sql.SQLException
public java.util.List<ForeignKeyList> getForeignKeyList(java.lang.String tableName)
throws java.sql.SQLException
tableName -
java.sql.SQLExceptionpublic static int getColumnType(int columnType)
public static java.lang.String getColumnClassName(int columnType)
public static int getPrecision(int columnType)
public static int getScale(int columnType)
public static int getColumnDisplaySize(int columnType)
public static boolean isSigned(int columnType)
public static int getRadix(int columnType)
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||