|
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
|
|