Package com.microsoft.sqlserver.jdbc
Class SQLServerDatabaseMetaData
java.lang.Object
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData
- All Implemented Interfaces:
java.io.Serializable
,java.sql.DatabaseMetaData
,java.sql.Wrapper
public final class SQLServerDatabaseMetaData
extends java.lang.Object
implements java.sql.DatabaseMetaData, java.io.Serializable
Provides the JDBC database meta data.
The API javadoc for JDBC API methods that this class implements are not repeated here. Please see Sun's JDBC API
interfaces javadoc for those details.
- See Also:
- Serialized Form
-
Field Summary
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 Constructor Description SQLServerDatabaseMetaData(SQLServerConnection con)
Constructs a SQLServerDatabaseMetaData database meta data -
Method Summary
Modifier and Type Method Description boolean
allProceduresAreCallable()
boolean
allTablesAreSelectable()
boolean
autoCommitFailureClosesAllResultSets()
boolean
dataDefinitionCausesTransactionCommit()
boolean
dataDefinitionIgnoredInTransactions()
boolean
deletesAreDetected(int type)
boolean
doesMaxRowSizeIncludeBlobs()
boolean
generatedKeyAlwaysReturned()
java.sql.ResultSet
getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern)
java.sql.ResultSet
getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)
java.sql.ResultSet
getCatalogs()
java.lang.String
getCatalogSeparator()
java.lang.String
getCatalogTerm()
java.sql.ResultSet
getClientInfoProperties()
java.sql.ResultSet
getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String col)
java.sql.ResultSet
getColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String col)
java.sql.Connection
getConnection()
java.sql.ResultSet
getCrossReference(java.lang.String cat1, java.lang.String schem1, java.lang.String tab1, java.lang.String cat2, java.lang.String schem2, java.lang.String tab2)
int
getDatabaseMajorVersion()
int
getDatabaseMinorVersion()
java.lang.String
getDatabaseProductName()
java.lang.String
getDatabaseProductVersion()
int
getDefaultTransactionIsolation()
int
getDriverMajorVersion()
int
getDriverMinorVersion()
java.lang.String
getDriverName()
java.lang.String
getDriverVersion()
java.sql.ResultSet
getExportedKeys(java.lang.String cat, java.lang.String schema, java.lang.String table)
java.lang.String
getExtraNameCharacters()
java.sql.ResultSet
getFunctionColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String columnNamePattern)
java.sql.ResultSet
getFunctions(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern)
java.lang.String
getIdentifierQuoteString()
java.sql.ResultSet
getImportedKeys(java.lang.String cat, java.lang.String schema, java.lang.String table)
java.sql.ResultSet
getIndexInfo(java.lang.String cat, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)
int
getJDBCMajorVersion()
int
getJDBCMinorVersion()
int
getMaxBinaryLiteralLength()
int
getMaxCatalogNameLength()
int
getMaxCharLiteralLength()
int
getMaxColumnNameLength()
int
getMaxColumnsInGroupBy()
int
getMaxColumnsInIndex()
int
getMaxColumnsInOrderBy()
int
getMaxColumnsInSelect()
int
getMaxColumnsInTable()
int
getMaxConnections()
int
getMaxCursorNameLength()
int
getMaxIndexLength()
long
getMaxLogicalLobSize()
int
getMaxProcedureNameLength()
int
getMaxRowSize()
int
getMaxSchemaNameLength()
int
getMaxStatementLength()
int
getMaxStatements()
int
getMaxTableNameLength()
int
getMaxTablesInSelect()
int
getMaxUserNameLength()
java.lang.String
getNumericFunctions()
java.sql.ResultSet
getPrimaryKeys(java.lang.String cat, java.lang.String schema, java.lang.String table)
java.sql.ResultSet
getProcedureColumns(java.lang.String catalog, java.lang.String schema, java.lang.String proc, java.lang.String col)
java.sql.ResultSet
getProcedures(java.lang.String catalog, java.lang.String schema, java.lang.String proc)
java.lang.String
getProcedureTerm()
java.sql.ResultSet
getPseudoColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)
int
getResultSetHoldability()
java.sql.RowIdLifetime
getRowIdLifetime()
java.sql.ResultSet
getSchemas()
java.sql.ResultSet
getSchemas(java.lang.String catalog, java.lang.String schemaPattern)
java.lang.String
getSchemaTerm()
java.lang.String
getSearchStringEscape()
java.lang.String
getSQLKeywords()
int
getSQLStateType()
java.lang.String
getStringFunctions()
java.sql.ResultSet
getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)
java.sql.ResultSet
getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern)
java.lang.String
getSystemFunctions()
java.sql.ResultSet
getTablePrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table)
java.sql.ResultSet
getTables(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String[] types)
java.sql.ResultSet
getTableTypes()
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)
java.lang.String
getURL()
java.lang.String
getUserName()
java.sql.ResultSet
getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table)
boolean
insertsAreDetected(int type)
boolean
isCatalogAtStart()
boolean
isReadOnly()
boolean
isWrapperFor(java.lang.Class<?> iface)
boolean
locatorsUpdateCopy()
boolean
nullPlusNonNullIsNull()
boolean
nullsAreSortedAtEnd()
boolean
nullsAreSortedAtStart()
boolean
nullsAreSortedHigh()
boolean
nullsAreSortedLow()
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
storesLowerCaseIdentifiers()
boolean
storesLowerCaseQuotedIdentifiers()
boolean
storesMixedCaseIdentifiers()
boolean
storesMixedCaseQuotedIdentifiers()
boolean
storesUpperCaseIdentifiers()
boolean
storesUpperCaseQuotedIdentifiers()
boolean
supportsAlterTableWithAddColumn()
boolean
supportsAlterTableWithDropColumn()
boolean
supportsANSI92EntryLevelSQL()
boolean
supportsANSI92FullSQL()
boolean
supportsANSI92IntermediateSQL()
boolean
supportsBatchUpdates()
boolean
supportsCatalogsInDataManipulation()
boolean
supportsCatalogsInIndexDefinitions()
boolean
supportsCatalogsInPrivilegeDefinitions()
boolean
supportsCatalogsInProcedureCalls()
boolean
supportsCatalogsInTableDefinitions()
boolean
supportsColumnAliasing()
boolean
supportsConvert()
boolean
supportsConvert(int fromType, int toType)
boolean
supportsCoreSQLGrammar()
boolean
supportsCorrelatedSubqueries()
boolean
supportsDataDefinitionAndDataManipulationTransactions()
boolean
supportsDataManipulationTransactionsOnly()
boolean
supportsDifferentTableCorrelationNames()
boolean
supportsExpressionsInOrderBy()
boolean
supportsExtendedSQLGrammar()
boolean
supportsFullOuterJoins()
boolean
supportsGetGeneratedKeys()
boolean
supportsGroupBy()
boolean
supportsGroupByBeyondSelect()
boolean
supportsGroupByUnrelated()
boolean
supportsIntegrityEnhancementFacility()
boolean
supportsLikeEscapeClause()
boolean
supportsLimitedOuterJoins()
boolean
supportsMinimumSQLGrammar()
boolean
supportsMixedCaseIdentifiers()
boolean
supportsMixedCaseQuotedIdentifiers()
boolean
supportsMultipleOpenResults()
boolean
supportsMultipleResultSets()
boolean
supportsMultipleTransactions()
boolean
supportsNamedParameters()
boolean
supportsNonNullableColumns()
boolean
supportsOpenCursorsAcrossCommit()
boolean
supportsOpenCursorsAcrossRollback()
boolean
supportsOpenStatementsAcrossCommit()
boolean
supportsOpenStatementsAcrossRollback()
boolean
supportsOrderByUnrelated()
boolean
supportsOuterJoins()
boolean
supportsPositionedDelete()
boolean
supportsPositionedUpdate()
boolean
supportsRefCursors()
boolean
supportsResultSetConcurrency(int type, int concurrency)
boolean
supportsResultSetHoldability(int holdability)
boolean
supportsResultSetType(int type)
boolean
supportsSavepoints()
boolean
supportsSchemasInDataManipulation()
boolean
supportsSchemasInIndexDefinitions()
boolean
supportsSchemasInPrivilegeDefinitions()
boolean
supportsSchemasInProcedureCalls()
boolean
supportsSchemasInTableDefinitions()
boolean
supportsSelectForUpdate()
boolean
supportsSharding()
boolean
supportsStatementPooling()
boolean
supportsStoredFunctionsUsingCallSyntax()
boolean
supportsStoredProcedures()
boolean
supportsSubqueriesInComparisons()
boolean
supportsSubqueriesInExists()
boolean
supportsSubqueriesInIns()
boolean
supportsSubqueriesInQuantifieds()
boolean
supportsTableCorrelationNames()
boolean
supportsTransactionIsolationLevel(int level)
boolean
supportsTransactions()
boolean
supportsUnion()
boolean
supportsUnionAll()
java.lang.String
toString()
Provides a helper function to provide an ID string suitable for tracing.<T> T
unwrap(java.lang.Class<T> iface)
boolean
updatesAreDetected(int type)
boolean
usesLocalFilePerTable()
boolean
usesLocalFiles()
-
Constructor Details
-
SQLServerDatabaseMetaData
Constructs a SQLServerDatabaseMetaData database meta data- Parameters:
con
- the connection
-
-
Method Details
-
toString
public final java.lang.String toString()Provides a helper function to provide an ID string suitable for tracing.- Overrides:
toString
in classjava.lang.Object
- Returns:
- traceID string
-
isWrapperFor
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException- Specified by:
isWrapperFor
in interfacejava.sql.Wrapper
- Throws:
java.sql.SQLException
-
unwrap
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException- Specified by:
unwrap
in interfacejava.sql.Wrapper
- Throws:
java.sql.SQLException
-
allProceduresAreCallable
- Specified by:
allProceduresAreCallable
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
allTablesAreSelectable
- Specified by:
allTablesAreSelectable
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
autoCommitFailureClosesAllResultSets
public boolean autoCommitFailureClosesAllResultSets() throws java.sql.SQLException- Specified by:
autoCommitFailureClosesAllResultSets
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
dataDefinitionCausesTransactionCommit
- Specified by:
dataDefinitionCausesTransactionCommit
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
dataDefinitionIgnoredInTransactions
- Specified by:
dataDefinitionIgnoredInTransactions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
doesMaxRowSizeIncludeBlobs
- Specified by:
doesMaxRowSizeIncludeBlobs
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
generatedKeyAlwaysReturned
public boolean generatedKeyAlwaysReturned() throws java.sql.SQLException- Specified by:
generatedKeyAlwaysReturned
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
getMaxLogicalLobSize
public long getMaxLogicalLobSize() throws java.sql.SQLException- Specified by:
getMaxLogicalLobSize
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
supportsRefCursors
public boolean supportsRefCursors() throws java.sql.SQLException- Specified by:
supportsRefCursors
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
supportsSharding
public boolean supportsSharding() throws java.sql.SQLException- Specified by:
supportsSharding
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
getCatalogs
public java.sql.ResultSet getCatalogs() throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getCatalogs
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getCatalogSeparator
- Specified by:
getCatalogSeparator
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getCatalogTerm
- Specified by:
getCatalogTerm
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getColumnPrivileges
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String col) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getColumnPrivileges
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getTables
public java.sql.ResultSet getTables(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String[] types) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getTables
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getColumns
public java.sql.ResultSet getColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String col) throws java.sql.SQLException- Specified by:
getColumns
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
getFunctions
public java.sql.ResultSet getFunctions(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern) throws java.sql.SQLException- Specified by:
getFunctions
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
getFunctionColumns
public java.sql.ResultSet getFunctionColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException- Specified by:
getFunctionColumns
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
getClientInfoProperties
public java.sql.ResultSet getClientInfoProperties() throws java.sql.SQLException- Specified by:
getClientInfoProperties
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
getBestRowIdentifier
public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getBestRowIdentifier
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getCrossReference
public java.sql.ResultSet getCrossReference(java.lang.String cat1, java.lang.String schem1, java.lang.String tab1, java.lang.String cat2, java.lang.String schem2, java.lang.String tab2) throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getCrossReference
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getDatabaseProductName
- Specified by:
getDatabaseProductName
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseProductVersion
- Specified by:
getDatabaseProductVersion
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getDefaultTransactionIsolation
- Specified by:
getDefaultTransactionIsolation
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getDriverMajorVersion
public int getDriverMajorVersion()- Specified by:
getDriverMajorVersion
in interfacejava.sql.DatabaseMetaData
-
getDriverMinorVersion
public int getDriverMinorVersion()- Specified by:
getDriverMinorVersion
in interfacejava.sql.DatabaseMetaData
-
getDriverName
- Specified by:
getDriverName
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getDriverVersion
- Specified by:
getDriverVersion
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getExportedKeys
public java.sql.ResultSet getExportedKeys(java.lang.String cat, java.lang.String schema, java.lang.String table) throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getExportedKeys
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getExtraNameCharacters
- Specified by:
getExtraNameCharacters
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getIdentifierQuoteString
- Specified by:
getIdentifierQuoteString
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getImportedKeys
public java.sql.ResultSet getImportedKeys(java.lang.String cat, java.lang.String schema, java.lang.String table) throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getImportedKeys
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getIndexInfo
public java.sql.ResultSet getIndexInfo(java.lang.String cat, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getIndexInfo
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getMaxBinaryLiteralLength
- Specified by:
getMaxBinaryLiteralLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxCatalogNameLength
- Specified by:
getMaxCatalogNameLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxCharLiteralLength
- Specified by:
getMaxCharLiteralLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnNameLength
- Specified by:
getMaxColumnNameLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInGroupBy
- Specified by:
getMaxColumnsInGroupBy
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInIndex
- Specified by:
getMaxColumnsInIndex
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInOrderBy
- Specified by:
getMaxColumnsInOrderBy
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInSelect
- Specified by:
getMaxColumnsInSelect
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInTable
- Specified by:
getMaxColumnsInTable
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxConnections
public int getMaxConnections() throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getMaxConnections
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getMaxCursorNameLength
- Specified by:
getMaxCursorNameLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxIndexLength
- Specified by:
getMaxIndexLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxProcedureNameLength
- Specified by:
getMaxProcedureNameLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxRowSize
- Specified by:
getMaxRowSize
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxSchemaNameLength
- Specified by:
getMaxSchemaNameLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxStatementLength
- Specified by:
getMaxStatementLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxStatements
- Specified by:
getMaxStatements
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxTableNameLength
- Specified by:
getMaxTableNameLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxTablesInSelect
- Specified by:
getMaxTablesInSelect
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getMaxUserNameLength
- Specified by:
getMaxUserNameLength
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getNumericFunctions
- Specified by:
getNumericFunctions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getPrimaryKeys
public java.sql.ResultSet getPrimaryKeys(java.lang.String cat, java.lang.String schema, java.lang.String table) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getPrimaryKeys
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getProcedureColumns
public java.sql.ResultSet getProcedureColumns(java.lang.String catalog, java.lang.String schema, java.lang.String proc, java.lang.String col) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getProcedureColumns
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getProcedures
public java.sql.ResultSet getProcedures(java.lang.String catalog, java.lang.String schema, java.lang.String proc) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getProcedures
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getProcedureTerm
- Specified by:
getProcedureTerm
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getPseudoColumns
public java.sql.ResultSet getPseudoColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException- Specified by:
getPseudoColumns
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
getSchemas
public java.sql.ResultSet getSchemas() throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getSchemas
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getSchemas
public java.sql.ResultSet getSchemas(java.lang.String catalog, java.lang.String schemaPattern) throws java.sql.SQLException- Specified by:
getSchemas
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
getSchemaTerm
- Specified by:
getSchemaTerm
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getSearchStringEscape
- Specified by:
getSearchStringEscape
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getSQLKeywords
- Specified by:
getSQLKeywords
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getStringFunctions
- Specified by:
getStringFunctions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getSystemFunctions
- Specified by:
getSystemFunctions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getTablePrivileges
public java.sql.ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getTablePrivileges
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getTableTypes
public java.sql.ResultSet getTableTypes() throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getTableTypes
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getTimeDateFunctions
- Specified by:
getTimeDateFunctions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getTypeInfo
public java.sql.ResultSet getTypeInfo() throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getTypeInfo
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getURL
- Specified by:
getURL
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getUserName
- Specified by:
getUserName
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
getVersionColumns
public java.sql.ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SQLServerException, java.sql.SQLTimeoutException- Specified by:
getVersionColumns
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
java.sql.SQLTimeoutException
-
isCatalogAtStart
- Specified by:
isCatalogAtStart
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
isReadOnly
- Specified by:
isReadOnly
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
nullPlusNonNullIsNull
- Specified by:
nullPlusNonNullIsNull
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedAtEnd
- Specified by:
nullsAreSortedAtEnd
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedAtStart
- Specified by:
nullsAreSortedAtStart
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedHigh
- Specified by:
nullsAreSortedHigh
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedLow
- Specified by:
nullsAreSortedLow
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
storesLowerCaseIdentifiers
- Specified by:
storesLowerCaseIdentifiers
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
storesLowerCaseQuotedIdentifiers
- Specified by:
storesLowerCaseQuotedIdentifiers
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
storesMixedCaseIdentifiers
- Specified by:
storesMixedCaseIdentifiers
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
storesMixedCaseQuotedIdentifiers
- Specified by:
storesMixedCaseQuotedIdentifiers
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
storesUpperCaseIdentifiers
- Specified by:
storesUpperCaseIdentifiers
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
storesUpperCaseQuotedIdentifiers
- Specified by:
storesUpperCaseQuotedIdentifiers
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsAlterTableWithAddColumn
- Specified by:
supportsAlterTableWithAddColumn
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsAlterTableWithDropColumn
- Specified by:
supportsAlterTableWithDropColumn
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92EntryLevelSQL
- Specified by:
supportsANSI92EntryLevelSQL
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92FullSQL
- Specified by:
supportsANSI92FullSQL
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92IntermediateSQL
- Specified by:
supportsANSI92IntermediateSQL
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInDataManipulation
- Specified by:
supportsCatalogsInDataManipulation
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInIndexDefinitions
- Specified by:
supportsCatalogsInIndexDefinitions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInPrivilegeDefinitions
- Specified by:
supportsCatalogsInPrivilegeDefinitions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInProcedureCalls
- Specified by:
supportsCatalogsInProcedureCalls
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInTableDefinitions
- Specified by:
supportsCatalogsInTableDefinitions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsColumnAliasing
- Specified by:
supportsColumnAliasing
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsConvert
- Specified by:
supportsConvert
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsConvert
- Specified by:
supportsConvert
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsCoreSQLGrammar
- Specified by:
supportsCoreSQLGrammar
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsCorrelatedSubqueries
- Specified by:
supportsCorrelatedSubqueries
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsDataDefinitionAndDataManipulationTransactions
- Specified by:
supportsDataDefinitionAndDataManipulationTransactions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsDataManipulationTransactionsOnly
- Specified by:
supportsDataManipulationTransactionsOnly
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsDifferentTableCorrelationNames
- Specified by:
supportsDifferentTableCorrelationNames
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsExpressionsInOrderBy
- Specified by:
supportsExpressionsInOrderBy
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsExtendedSQLGrammar
- Specified by:
supportsExtendedSQLGrammar
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsFullOuterJoins
- Specified by:
supportsFullOuterJoins
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsGroupBy
- Specified by:
supportsGroupBy
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsGroupByBeyondSelect
- Specified by:
supportsGroupByBeyondSelect
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsGroupByUnrelated
- Specified by:
supportsGroupByUnrelated
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsIntegrityEnhancementFacility
- Specified by:
supportsIntegrityEnhancementFacility
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsLikeEscapeClause
- Specified by:
supportsLikeEscapeClause
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsLimitedOuterJoins
- Specified by:
supportsLimitedOuterJoins
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsMinimumSQLGrammar
- Specified by:
supportsMinimumSQLGrammar
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsMixedCaseIdentifiers
- Specified by:
supportsMixedCaseIdentifiers
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsMixedCaseQuotedIdentifiers
- Specified by:
supportsMixedCaseQuotedIdentifiers
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleResultSets
- Specified by:
supportsMultipleResultSets
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleTransactions
- Specified by:
supportsMultipleTransactions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsNonNullableColumns
- Specified by:
supportsNonNullableColumns
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenCursorsAcrossCommit
- Specified by:
supportsOpenCursorsAcrossCommit
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenCursorsAcrossRollback
- Specified by:
supportsOpenCursorsAcrossRollback
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenStatementsAcrossCommit
- Specified by:
supportsOpenStatementsAcrossCommit
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenStatementsAcrossRollback
- Specified by:
supportsOpenStatementsAcrossRollback
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsOrderByUnrelated
- Specified by:
supportsOrderByUnrelated
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsOuterJoins
- Specified by:
supportsOuterJoins
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsPositionedDelete
- Specified by:
supportsPositionedDelete
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsPositionedUpdate
- Specified by:
supportsPositionedUpdate
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInDataManipulation
- Specified by:
supportsSchemasInDataManipulation
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInIndexDefinitions
- Specified by:
supportsSchemasInIndexDefinitions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInPrivilegeDefinitions
- Specified by:
supportsSchemasInPrivilegeDefinitions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInProcedureCalls
- Specified by:
supportsSchemasInProcedureCalls
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInTableDefinitions
- Specified by:
supportsSchemasInTableDefinitions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSelectForUpdate
- Specified by:
supportsSelectForUpdate
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsStoredProcedures
- Specified by:
supportsStoredProcedures
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInComparisons
- Specified by:
supportsSubqueriesInComparisons
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInExists
- Specified by:
supportsSubqueriesInExists
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInIns
- Specified by:
supportsSubqueriesInIns
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInQuantifieds
- Specified by:
supportsSubqueriesInQuantifieds
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsTableCorrelationNames
- Specified by:
supportsTableCorrelationNames
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsTransactionIsolationLevel
- Specified by:
supportsTransactionIsolationLevel
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsTransactions
- Specified by:
supportsTransactions
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsUnion
- Specified by:
supportsUnion
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsUnionAll
- Specified by:
supportsUnionAll
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
usesLocalFilePerTable
- Specified by:
usesLocalFilePerTable
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
usesLocalFiles
- Specified by:
usesLocalFiles
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsResultSetType
- Specified by:
supportsResultSetType
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsResultSetConcurrency
- Specified by:
supportsResultSetConcurrency
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
ownUpdatesAreVisible
- Specified by:
ownUpdatesAreVisible
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
ownDeletesAreVisible
- Specified by:
ownDeletesAreVisible
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
ownInsertsAreVisible
- Specified by:
ownInsertsAreVisible
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
othersUpdatesAreVisible
- Specified by:
othersUpdatesAreVisible
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
othersDeletesAreVisible
- Specified by:
othersDeletesAreVisible
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
othersInsertsAreVisible
- Specified by:
othersInsertsAreVisible
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
updatesAreDetected
- Specified by:
updatesAreDetected
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
deletesAreDetected
- Specified by:
deletesAreDetected
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
insertsAreDetected
- Specified by:
insertsAreDetected
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsBatchUpdates
- Specified by:
supportsBatchUpdates
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getUDTs
public java.sql.ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getUDTs
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getConnection
- Specified by:
getConnection
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getSQLStateType
- Specified by:
getSQLStateType
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseMajorVersion
- Specified by:
getDatabaseMajorVersion
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseMinorVersion
- Specified by:
getDatabaseMinorVersion
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getJDBCMajorVersion
- Specified by:
getJDBCMajorVersion
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getJDBCMinorVersion
- Specified by:
getJDBCMinorVersion
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getResultSetHoldability
- Specified by:
getResultSetHoldability
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getRowIdLifetime
public java.sql.RowIdLifetime getRowIdLifetime() throws java.sql.SQLException- Specified by:
getRowIdLifetime
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
supportsResultSetHoldability
- Specified by:
supportsResultSetHoldability
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
getAttributes
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, java.sql.SQLTimeoutException- Specified by:
getAttributes
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getSuperTables
public java.sql.ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getSuperTables
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
getSuperTypes
public java.sql.ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern) throws java.sql.SQLException, java.sql.SQLTimeoutException- Specified by:
getSuperTypes
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
java.sql.SQLTimeoutException
-
supportsGetGeneratedKeys
- Specified by:
supportsGetGeneratedKeys
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleOpenResults
- Specified by:
supportsMultipleOpenResults
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsNamedParameters
- Specified by:
supportsNamedParameters
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsSavepoints
- Specified by:
supportsSavepoints
in interfacejava.sql.DatabaseMetaData
- Throws:
SQLServerException
-
supportsStatementPooling
public boolean supportsStatementPooling() throws java.sql.SQLException- Specified by:
supportsStatementPooling
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
supportsStoredFunctionsUsingCallSyntax
public boolean supportsStoredFunctionsUsingCallSyntax() throws java.sql.SQLException- Specified by:
supportsStoredFunctionsUsingCallSyntax
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-
locatorsUpdateCopy
public boolean locatorsUpdateCopy() throws java.sql.SQLException- Specified by:
locatorsUpdateCopy
in interfacejava.sql.DatabaseMetaData
- Throws:
java.sql.SQLException
-