allProceduresAreCallable() | Boolean | Yes |
allTablesAreSelectable() | Boolean | Yes |
autoCommitFailureClosesAllResultSets() | Boolean | Yes |
dataDefinitionCausesTransactionCommit() | Boolean | Yes |
dataDefinitionIgnoredInTransactions() | Boolean | Yes |
deletesAreDetected(int type) | Boolean | Yes |
doesMaxRowSizeIncludeBlobs() | Boolean | Yes |
generatedKeyAlwaysReturned() | Boolean | Yes |
getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) | ResultSet | Yes |
getCatalogs() | ResultSet | Yes |
getCatalogSeparator() | String | Yes |
getCatalogTerm() | String | Yes |
getClientInfoProperties() | ResultSet | Yes |
getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) | ResultSet | Yes |
getConnection() | Connection | Yes |
getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) | ResultSet | Yes |
getDefaultTransactionIsolation() | int | Yes |
getExportedKeys(String catalog, String schema, String table) | ResultSet | Yes |
getExtraNameCharacters() | String | Yes |
getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) | ResultSet | Yes |
getFunctions(String catalog, String schemaPattern, String functionNamePattern) | ResultSet | Yes |
getIdentifierQuoteString() | String | Yes |
getImportedKeys(String catalog, String schema, String table) | ResultSet | Yes |
getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) | ResultSet | Yes |
getMaxBinaryLiteralLength() | int | Yes |
getMaxCatalogNameLength() | int | Yes |
getMaxCharLiteralLength() | int | Yes |
getMaxColumnNameLength() | int | Yes |
getMaxColumnsInGroupBy() | int | Yes |
getMaxColumnsInIndex() | int | Yes |
getMaxColumnsInOrderBy() | int | Yes |
getMaxColumnsInSelect() | int | Yes |
getMaxColumnsInTable() | int | Yes |
getMaxConnections() | int | Yes |
getMaxCursorNameLength() | int | Yes |
getMaxIndexLength() | int | Yes |
getMaxLogicalLobSize() | default long | Yes |
getMaxProcedureNameLength() | int | Yes |
getMaxRowSize() | int | Yes |
getMaxSchemaNameLength() | int | Yes |
getMaxStatementLength() | int | Yes |
getMaxStatements() | int | Yes |
getMaxTableNameLength() | int | Yes |
getMaxTablesInSelect() | int | Yes |
getMaxUserNameLength() | int | Yes |
getNumericFunctions() | String | Yes |
getPrimaryKeys(String catalog, String schema, String table) | ResultSet | Yes |
getPartitionTablePrimaryKeys(String catalog, String schema, String table) | ResultSet | Yes |
getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) | ResultSet | Yes |
getProcedures(String catalog, String schemaPattern, String procedureNamePattern) | ResultSet | Yes |
getProcedureTerm() | String | Yes |
getSchemas() | ResultSet | Yes |
getSchemas(String catalog, String schemaPattern) | ResultSet | Yes |
getSchemaTerm() | String | Yes |
getSearchStringEscape() | String | Yes |
getSQLKeywords() | String | Yes |
getSQLStateType() | int | Yes |
getStringFunctions() | String | Yes |
getSystemFunctions() | String | Yes |
getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) | ResultSet | Yes |
getTimeDateFunctions() | String | Yes |
getTypeInfo() | ResultSet | Yes |
getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) | ResultSet | Yes |
getURL() | String | Yes |
getVersionColumns(String catalog, String schema, String table) | ResultSet | Yes |
insertsAreDetected(int type) | Boolean | Yes |
locatorsUpdateCopy() | Boolean | Yes |
othersDeletesAreVisible(int type) | Boolean | Yes |
othersInsertsAreVisible(int type) | Boolean | Yes |
othersUpdatesAreVisible(int type) | Boolean | Yes |
ownDeletesAreVisible(int type) | Boolean | Yes |
ownInsertsAreVisible(int type) | Boolean | Yes |
ownUpdatesAreVisible(int type) | Boolean | Yes |
storesLowerCaseIdentifiers() | Boolean | Yes |
storesMixedCaseIdentifiers() | Boolean | Yes |
storesUpperCaseIdentifiers() | Boolean | Yes |
supportsBatchUpdates() | Boolean | Yes |
supportsCatalogsInDataManipulation() | Boolean | Yes |
supportsCatalogsInIndexDefinitions() | Boolean | Yes |
supportsCatalogsInPrivilegeDefinitions() | Boolean | Yes |
supportsCatalogsInProcedureCalls() | Boolean | Yes |
supportsCatalogsInTableDefinitions() | Boolean | Yes |
supportsCorrelatedSubqueries() | Boolean | Yes |
supportsDataDefinitionAndDataManipulationTransactions() | Boolean | Yes |
supportsDataManipulationTransactionsOnly() | Boolean | Yes |
supportsGetGeneratedKeys() | Boolean | Yes |
supportsMixedCaseIdentifiers() | Boolean | Yes |
supportsMultipleOpenResults() | Boolean | Yes |
supportsNamedParameters() | Boolean | Yes |
supportsOpenCursorsAcrossCommit() | Boolean | Yes |
supportsOpenCursorsAcrossRollback() | Boolean | Yes |
supportsOpenStatementsAcrossCommit() | Boolean | Yes |
supportsOpenStatementsAcrossRollback() | Boolean | Yes |
supportsPositionedDelete() | Boolean | Yes |
supportsPositionedUpdate() | Boolean | Yes |
supportsRefCursors() | Boolean | Yes |
supportsResultSetConcurrency(int type, int concurrency) | Boolean | Yes |
supportsResultSetType(int type) | Boolean | Yes |
supportsSchemasInIndexDefinitions() | Boolean | Yes |
supportsSchemasInPrivilegeDefinitions() | Boolean | Yes |
supportsSchemasInProcedureCalls() | Boolean | Yes |
supportsSchemasInTableDefinitions() | Boolean | Yes |
supportsSelectForUpdate() | Boolean | Yes |
supportsStatementPooling() | Boolean | Yes |
supportsStoredFunctionsUsingCallSyntax() | Boolean | Yes |
supportsStoredProcedures() | Boolean | Yes |
supportsSubqueriesInComparisons() | Boolean | Yes |
supportsSubqueriesInExists() | Boolean | Yes |
supportsSubqueriesInIns() | Boolean | Yes |
supportsSubqueriesInQuantifieds() | Boolean | Yes |
supportsTransactionIsolationLevel(int level) | Boolean | Yes |
supportsTransactions() | Boolean | Yes |
supportsUnion() | Boolean | Yes |
supportsUnionAll() | Boolean | Yes |
updatesAreDetected(int type) | Boolean | Yes |
getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) | ResultSet | Yes |
getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | ResultSet | Yes |
getTableTypes() | ResultSet | Yes |
getUserName() | String | Yes |
isReadOnly() | Boolean | Yes |
nullsAreSortedHigh() | Boolean | Yes |
nullsAreSortedLow() | Boolean | Yes |
nullsAreSortedAtStart() | Boolean | Yes |
nullsAreSortedAtEnd() | Boolean | Yes |
getDatabaseProductName() | String | Yes |
getDatabaseProductVersion() | String | Yes |
getDriverName() | String | Yes |
getDriverVersion() | String | Yes |
getDriverMajorVersion() | int | Yes |
getDriverMinorVersion() | int | Yes |
usesLocalFiles() | Boolean | Yes |
usesLocalFilePerTable() | Boolean | Yes |
supportsMixedCaseIdentifiers() | Boolean | Yes |
storesUpperCaseIdentifiers() | Boolean | Yes |
storesLowerCaseIdentifiers() | Boolean | Yes |
supportsMixedCaseQuotedIdentifiers() | Boolean | Yes |
storesUpperCaseQuotedIdentifiers() | Boolean | Yes |
storesLowerCaseQuotedIdentifiers() | Boolean | Yes |
storesMixedCaseQuotedIdentifiers() | Boolean | Yes |
supportsAlterTableWithAddColumn() | Boolean | Yes |
supportsAlterTableWithDropColumn() | Boolean | Yes |
supportsColumnAliasing() | Boolean | Yes |
nullPlusNonNullIsNull() | Boolean | Yes |
supportsConvert() | Boolean | Yes |
supportsConvert(int fromType, int toType) | Boolean | Yes |
supportsTableCorrelationNames() | Boolean | Yes |
supportsDifferentTableCorrelationNames() | Boolean | Yes |
supportsExpressionsInOrderBy() | Boolean | Yes |
supportsOrderByUnrelated() | Boolean | Yes |
supportsGroupBy() | Boolean | Yes |
supportsGroupByUnrelated() | Boolean | Yes |
supportsGroupByBeyondSelect() | Boolean | Yes |
supportsLikeEscapeClause() | Boolean | Yes |
supportsMultipleResultSets() | Boolean | Yes |
supportsMultipleTransactions() | Boolean | Yes |
supportsNonNullableColumns() | Boolean | Yes |
supportsMinimumSQLGrammar() | Boolean | Yes |
supportsCoreSQLGrammar() | Boolean | Yes |
supportsExtendedSQLGrammar() | Boolean | Yes |
supportsANSI92EntryLevelSQL() | Boolean | Yes |
supportsANSI92IntermediateSQL() | Boolean | Yes |
supportsANSI92FullSQL() | Boolean | Yes |
supportsIntegrityEnhancementFacility() | Boolean | Yes |
supportsOuterJoins() | Boolean | Yes |
supportsFullOuterJoins() | Boolean | Yes |
supportsLimitedOuterJoins() | Boolean | Yes |
isCatalogAtStart() | Boolean | Yes |
supportsSchemasInDataManipulation() | Boolean | Yes |
supportsSavepoints() | Boolean | Yes |
supportsResultSetHoldability(int holdability) | Boolean | Yes |
getResultSetHoldability() | int | Yes |
getDatabaseMajorVersion() | int | Yes |
getDatabaseMinorVersion() | int | Yes |
getJDBCMajorVersion() | int | Yes |
getJDBCMinorVersion() | int | Yes |
NOTE: If the value of uppercaseAttributeName is true, the following APIs convert the query result to uppercase letters. The conversion range is the same as that of the toUpperCase method in Java.
CAUTION: The getPartitionTablePrimaryKeys(String catalog, String schema, String table) API is used to obtain the primary key column of a partitioned table that contains global indexes. The following is an example: