DatabaseMetaData Object
- Last Updated: May 12, 2026
- 5 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
| DatabaseMetaData Method | Version Introduced | Supported | Comments |
| boolean autoCommitFailureClosesAllResultSets() | 4.0 | Yes | |
| boolean allProceduresAreCallable () | 1.0 | Yes | |
| boolean allTablesAreSelectable () | 1.0 | Yes | |
| boolean dataDefinitionCausesTransaction Commit () |
1.0 | Yes | |
| boolean dataDefinitionIgnoredInTransactions () | 1.0 | Yes | |
| boolean deletesAreDetected (int) | 2.0 Core | Yes | |
| boolean doesMaxRowSizeIncludeBlobs () | 1.0 | Yes | |
| ResultSet getAttributes (String, String) | 3.0 | No | Always returns empty result set. |
| ResultSet getBestRowIdentifier (String, String, String, int, boolean) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| ResultSet getCatalogs () | 1.0 | Yes | This method is supported if the OpenAccess SDK Server supports it. |
| String getCatalogSeparator () | 1.0 | Yes | |
| String getCatalogTerm () | 1.0 | Yes | |
| String getClientInfoProperties() | 4.0 | Yes | |
| ResultSet getColumnPrivileges (String, String, String, String) | 1.0 | No | Not supported |
| ResultSet getColumns (String, String, String, String) | 1.0 | Yes | |
| ResultSet getColumns (String, String, String, String) | 3.0 Extension | Yes | The extended resultset columns will all contain null as values. |
| Connection getConnection () | 2.0 Core | Yes | |
| ResultSet getCrossReference (String, String, String, String, String, String) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| ResultSet getFunctions() | 4.0 | No | Not supported |
| ResultSet getFunctionColumns() | 4.0 | No | Not supported |
| int getDatabaseMajorVersion () | 3.0 | Yes | |
| int getDatabaseMinorVersion () | 3.0 | Yes | |
| String getDatabaseProductName () | 1.0 | Yes | |
| String getDatabaseProductVersion () | 1.0 | Yes | |
| int getDefaultTransactionIsolation () | 1.0 | Yes | |
| int getDriverMajorVersion () | 1.0 | Yes | |
| int getDriverMinorVersion () | 1.0 | Yes | |
| String getDriverName () | 1.0 | Yes | |
| String getDriverVersion () | 1.0 | Yes | |
| ResultSet getExportedKeys (String, String, String) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| String getExtraNameCharacters () | 1.0 | Yes | |
| String getIdentifierQuoteString () | 1.0 | Yes | |
| ResultSet getImportedKeys (String, String, String) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| ResultSet getIndexInfo (String, String, String, boolean, boolean) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| int getJDBCMajorVersion () | 3.0 | Yes | |
| int getJDBCMinorVersion () | 3.0 | Yes | |
| int getMaxBinaryLiteralLength () | 1.0 | Yes | |
| int getMaxCatalogNameLength () | 1.0 | Yes | |
| int getMaxCharLiteralLength () | 1.0 | Yes | |
| int getMaxColumnNameLength () | 1.0 | Yes | |
| int getMaxColumnsInGroupBy () | 1.0 | Yes | |
| int getMaxColumnsInIndex () | 1.0 | Yes | |
| int getMaxColumnsInOrderBy () | 1.0 | Yes | |
| int getMaxColumnsInSelect () | 1.0 | Yes | |
| int getMaxColumnsInTable () | 1.0 | Yes | |
| int getMaxConnections () | 1.0 | Yes | |
| int getMaxCursorNameLength () | 1.0 | Yes | |
| int getMaxIndexLength () | 1.0 | Yes | |
| int getMaxProcedureNameLength () | 1.0 | Yes | |
| int getMaxRowSize () | 1.0 | Yes | |
| int getMaxSchemaNameLength () | 1.0 | Yes | |
| int getMaxStatementLength () | 1.0 | Yes | |
| int getMaxStatements () | 1.0 | Yes | |
| int getMaxTableNameLength () | 1.0 | Yes | |
| int getMaxTablesInSelect () | 1.0 | Yes | |
| int getMaxUserNameLength () | 1.0 | Yes | |
| String getNumericFunctions () | 1.0 | Yes | |
| ResultSet getPrimaryKeys (String, String, String) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| ResultSet getProcedureColumns (String, String, String, String) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| String getProcedureTerm () | 1.0 | Yes | |
| ResultSet getProcedures (String, String, String) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| int getResultSetHoldability () | 3.0 | Yes | |
| ResultSet getSchemas () | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| ResultSet getSchemas (catalog, schema) | 4.0 | Yes | |
| String getSchemaTerm () | 1.0 | Yes | |
| String getSearchStringEscape () | 1.0 | Yes | |
| String getStringFunctions () | 1.0 | Yes | |
| String getSQLKeywords () | 1.0 | Yes | |
| int getSQLStateType () | 3.0 | Yes | |
| String getSystemFunctions () | 1.0 | Yes | |
| ResultSet getSuperTables (String, String, String) | 3.0 | No | Always returns empty ResultSet. |
| ResultSet getSuperTypes (String, String, String) | 3.0 | No | Always returns empty ResultSet. |
| ResultSet getTablePrivileges (String, String, String) | 1.0 | No | Not supported. |
| ResultSet getTableTypes () | 1.0 | Yes | |
| ResultSet getTables (String, String, String, String []) | 1.0 | Yes | |
| ResultSet getTables (String, String, String, String []) | 3.0 Extension | Yes | The extended resultset columns will all contain null as values. |
| String getTimeDateFunctions () | 1.0 | Yes | |
| ResultSet getTypeInfo () | 1.0 | Yes | |
| ResultSet getUDTs (String, String, String, int []) |
2.0 Core | No | OpenAccess SDK does not support the Advanced Data Type functionality and always returns an empty result set. |
| ResultSet getUDTs (String, String, String, int []) |
3.0 Extension | No | OpenAccess SDK does not support the Advanced Data Type functionality and always returns an empty result set. |
| String getURL () | 1.0 | Yes | |
| String getUserName () | 1.0 | Yes | |
| ResultSet getVersionColumns (String, String, String) | 1.0 | Yes | The JDBC Client supports this method if the data store supports it. |
| boolean insertsAreDetected (int) | 2.0 Core | Yes | |
| boolean isCatalogAtStart () | 1.0 | Yes | |
| boolean isReadOnly () | 1.0 | Yes | |
| boolean isWrapperFor(Class<?> iface) | 4.0 | Yes | |
| boolean locatorsUpdateCopy () | 3.0 | Yes | |
| boolean nullPlusNonNullIsNull () | 1.0 | Yes | |
| boolean nullsAreSortedAtEnd () | 1.0 | Yes | |
| boolean nullsAreSortedAtStart () | 1.0 | Yes | |
| boolean nullsAreSortedHigh () | 1.0 | Yes | |
| boolean nullsAreSortedLow () | 1.0 | Yes | |
| boolean othersDeletesAreVisible (int) | 2.0 Core | Yes | |
| boolean othersInsertsAreVisible (int) | 2.0 Core | Yes | |
| boolean othersUpdatesAreVisible (int) | 2.0 Core | Yes | |
| boolean ownDeletesAreVisible (int) | 2.0 Core | Yes | |
| boolean ownInsertsAreVisible (int) | 2.0 Core | Yes | |
| boolean ownUpdatesAreVisible (int) | 2.0 Core | Yes | |
| boolean storesLowerCaseIdentifiers () | 1.0 | Yes | |
| boolean storesLowerCaseQuoted Identifiers () |
1.0 | Yes | |
| boolean storesMixedCaseIdentifiers () | 1.0 | Yes | |
| boolean storesMixedCaseQuoted Identifiers () |
1.0 | Yes | |
| boolean storesUpperCaseIdentifiers () | 1.0 | Yes | |
| boolean supportsResultSetHoldability (int) | 3.0 | Yes | |
| boolean supportsAlterTableWith AddColumn () |
1.0 | Yes | |
| boolean supportsAlterTableWith DropColumn () |
1.0 | Yes | |
| boolean supportsANSI92EntryLevelSQL () | 1.0 | Yes | |
| boolean supportsANSI92FullSQL () | 1.0 | Yes | |
| boolean supportsANSI92Intermediate SQL () |
1.0 | Yes | |
| boolean supportsBatchUpdates () | 2.0 Core | Yes | |
| boolean supportsCatalogsInData Manipulation () |
1.0 | Yes | |
| boolean supportsCatalogsInIndex () | 1.0 | Yes | |
| boolean supportsCatalogsInPrivilege Definitions () |
1.0 | Yes | |
| boolean supportsCatalogsInProcedure Calls () |
1.0 | Yes | |
| boolean supportsCatalogsInTable Definitions () |
1.0 | Yes | |
| boolean supportsColumnAliasing () | 1.0 | Yes | |
| boolean supportsConvert () | 1.0 | Yes | |
| boolean supportsConvert (int, int) | 1.0 | Yes | |
| boolean supportsCoreSQLGrammar () | 1.0 | Yes | |
| boolean supportsCorrelatedSubqueries () | 1.0 | Yes | |
| boolean supportsDataDefinitionAndData ManipulationTransactions () |
1.0 | Yes | |
| boolean supportsDataManipulation TransactionsOnly () |
1.0 | Yes | |
| boolean supportsDifferentTableCorrelation Names () |
1.0 | Yes | |
| boolean supportsExpressionsIn OrderBy () |
1.0 | Yes | |
| boolean supportsExtendedSQLGrammar () | 1.0 | Yes | |
| boolean supportsFullOuterJoins () | 1.0 | Yes | |
| boolean supportsGetGeneratedKeys () | 3.0 | Yes | |
| boolean supportsGroupBy () | 1.0 | Yes | |
| boolean supportsGroupByBeyondSelect () | 1.0 | Yes | |
| boolean supportsGroupByUnrelated () | 1.0 | Yes | |
| boolean supportsIntegrityEnhancement Facility () |
1.0 | Yes | |
| boolean supportsLikeEscapeClause () | 1.0 | Yes | |
| boolean supportsLimitedOuterJoins () | 1.0 | Yes | |
| boolean supportsMinimumSQLGrammar () | 1.0 | Yes | |
| boolean supportsMixedCaseIdentifiers () | 1.0 | Yes | |
| boolean supportsMixedCaseQuoted Identifiers () |
1.0 | Yes | |
| boolean supportsMultipleOpenResultSets () | 3.0 | Yes | |
| boolean supportsMultipleResultSets () | 1.0 | Yes | NOTE: Use of this method with large result sets incurs a performance and scalability penalty. |
| boolean supportsMultipleTransactions () | 1.0 | Yes | |
| boolean supportsNamedParameters () | 3.0 | Yes | |
| boolean supportsNonNullableColumns () | 1.0 | Yes | |
| boolean supportsOpenCursorsAcross Commit () |
1.0 | Yes | |
| boolean supportsOpenCursorsAcross Rollback () |
1.0 | Yes | |
| boolean supportsOpenStatementsAcross Commit () |
1.0 | Yes | |
| boolean supportsOpenStatementsAcross Rollback () |
1.0 | Yes | |
| boolean supportsOrderByUnrelated () | 1.0 | Yes | |
| boolean supportsOuterJoins () | 1.0 | Yes | |
| boolean supportsPositionedDelete () | 1.0 | Yes | The JDBC Client returns hard coded false. |
| boolean supportsPositionedUpdate () | 1.0 | Yes | The JDBC Client returns hard coded false. |
| boolean supportsResultSetConcurrency (int, int) | 2.0 Core | Yes | |
| boolean supportsResultSetType (int) | 2.0 Core | Yes | |
| boolean supportsSavePoints () | 3.0 | Yes | |
| boolean supportsSchemasInData Manipulation () |
1.0 | Yes | |
| boolean supportsSchemasInIndex Definitions () |
1.0 | Yes | |
| boolean supportsSchemasIn PrivilegeDefinitions () |
1.0 | Yes | |
| boolean supportsSchemasInProcedure Calls () |
1.0 | Yes | |
| boolean supportsSchemasInTable Definitions () |
1.0 | Yes | |
| boolean supportsSelectForUpdate () | 1.0 | Yes | OpenAccess SDK supports SELECT FOR UPDATE statements against certain DBMSs. OpenAccess SDK returns false, as it does not support UPDATE WHERE CURRENT OF statements. |
| boolean supportsStoredFunctionsUsingCallSyntax() | 4.0 | Yes | |
| boolean supportsStoredProcedures () | 1.0 | Yes | |
| boolean supportsSubqueriesIn Comparisons () |
1.0 | Yes | |
| boolean supportsSubqueriesInExists () | 1.0 | Yes | |
| boolean supportsSubqueriesInIns () | 1.0 | Yes | |
| boolean supportsSubqueriesIn Quantifieds () |
1.0 | Yes | |
| boolean supportsTableCorrelationNames () | 1.0 | Yes | |
| boolean supportsTransactionIsolationLevel (int) | 1.0 | Yes | |
| boolean supportsTransactions () | 1.0 | Yes | |
| boolean supportsUnion () | 1.0 | Yes | |
| boolean supportsUnionAll () | 1.0 | Yes | |
| <T> T unwrap(Class<T> iface) | 4.0 | Yes | |
| boolean updatesAreDetected (int) | 2.0 Core | Yes | |
| boolean usesLocalFilePerTable () | 1.0 | Yes | |
| boolean usesLocalFiles () | 1.0 | Yes |