Method Name

Support in Open SQL

Comments

boolean allProceduresAreCallable()

r

boolean allTablesAreSelectable()

r

boolean dataDefinitionCausesTransactionCommit()

r

boolean dataDefinitionIgnoredInTransactions()

r

boolean deletesAreDetected(int)

r

boolean doesMaxRowSizeIncludeBlobs()

r

ResultSet getBestRowIdentifier(String, String, String, int, boolean)

r

String getCatalogSeparator()

r

String getCatalogTerm()

r

ResultSet getCatalogs()

r

ResultSet getColumnPrivileges(String, String, String, String)

r

ResultSet getColumns(String, String, String, String)

r

Connection getConnection()

a

ResultSet getCrossReference (String, String, String, String, String, String)

r

String getDatabaseProductName()

a

String getDatabaseProductVersion()

a

int getDefaultTransactionIsolation()

a

The default transaction isolation level for Open SQL is TRANSACTION_READ_UNCOMMITTED.

int getDriverMajorVersion()

a

Refers to Open SQL.

int getDriverMinorVersion()

a

Refers to Open SQL.

String getDriverName()

a

Refers to Open SQL.

String getDriverVersion()

a

Refers to Open SQL.

ResultSet getExportedKeys (String, String, String)

r

String getExtraNameCharacters()

r

String getIdentifierQuoteString()

a

Returns a double quotation mark (“).

ResultSet getImportedKeys (String, String, String)

r

ResultSet getIndexInfo (String, String, String, boolean, boolean)

r

int getMaxBinaryLiteralLength()

r

int getMaxCatalogNameLength()

r

int getMaxCharLiteralLength()

r

int getMaxColumnNameLength()

r

int getMaxColumnsInGroupBy()

r

int getMaxColumnsInIndex()

r

int getMaxColumnsInOrderBy()

r

int getMaxColumnsInSelect()

r

int getMaxColumnsInTable()

r

int getMaxConnections()

r

int getMaxCursorNameLength()

r

int getMaxIndexLength()

r

int getMaxProcedureNameLength()

r

int getMaxRowSize()

r

int getMaxSchemaNameLength()

r

int getMaxStatementLength()

r

int getMaxStatements()

r

int getMaxTableNameLength()

r

int getMaxTablesInSelect()

r

int getMaxUserNameLength()

r

String getNumericFunctions()

r

ResultSet getPrimaryKeys (String, String, String)

r

ResultSet getProcedureColumns (String, String, String, String)

r

String getProcedureTerm()

r

ResultSet getProcedures (String, String, String)

r

String getSQLKeywords()

r

String getSchemaTerm()

r

ResultSet getSchemas()

r

String getSearchStringEscape()

r

String getStringFunctions()

r

String getSystemFunctions()

r

ResultSet getTablePrivileges (String, String, String)

r

ResultSet getTableTypes()

r

ResultSet getTables (String, String, String, String[])

r

String getTimeDateFunctions()

r

ResultSet getTypeInfo()

r

ResultSet getUDTs (String, String, String, int[])

r

String getURL()

r

String getUserName()

r

ResultSet getVersionColumns (String, String, String)

r

boolean insertsAreDetected (int)

r

boolean isCatalogAtStart()

r

boolean isReadOnly()

r

boolean nullPlusNonNullIsNull()

r

boolean nullsAreSortedAtEnd()

r

boolean nullsAreSortedAtStart()

r

boolean nullsAreSortedHigh()

r

boolean nullsAreSortedLow()

r

boolean othersDeletesAreVisible (int)

r

boolean othersInsertsAreVisible (int)

r

boolean othersUpdatesAreVisible (int)

r

boolean ownDeletesAreVisible (int)

r

boolean ownInsertsAreVisible (int)

r

boolean ownUpdatesAreVisible (int)

r

boolean storesLowerCaseIdentifiers()

a

Returns false.

boolean storesLowerCaseQuotedIdentifiers()

a

Returns false.

boolean storesMixedCaseIdentifiers()

a

Returns false.

boolean storesMixedCaseQuotedIdentifiers()

a

Returns true.

boolean storesUpperCaseIdentifiers()

a

Returns true.

boolean storesUpperCaseQuotedIdentifiers()

a

Returns false.

boolean supportsANSI92EntryLevelSQL()

a

Returns true.

boolean supportsANSI92FullSQL()

a

Returns false.

boolean supportsANSI92IntermediateSQL()

a

Returns false.

boolean supportsAlterTableWithAddColumn()

r

boolean supportsAlterTableWithDropColumn()

r

boolean supportsBatchUpdates()

a

Returns true.

boolean supportsCatalogsInDataManipulation()

r

boolean supportsCatalogsInIndexDefinitions()

r

boolean supportsCatalogsInPrivilegeDefinitions()

r

boolean supportsCatalogsInProcedureCalls()

r

boolean supportsCatalogsInTableDefinitions()

r

boolean supportsColumnAliasing()

r

boolean supportsConvert (int, int)

a

Returns false.

boolean supportsConvert()

a

Returns false.

boolean supportsCoreSQLGrammar()

a

Returns false.

boolean supportsCorrelatedSubqueries()

a

Returns true.

boolean supportsDataDefinitionAndDataManipulationTransactions()

r

boolean supportsDataManipulationTransactionsOnly()

r

boolean supportsDifferentTableCorrelationNames()

r

boolean supportsExpressionsInOrderBy()

a

Returns false.

boolean supportsExtendedSQLGrammar()

a

Returns false.

boolean supportsFullOuterJoins()

a

Returns false.

boolean supportsGroupBy()

a

Returns true.

boolean supportsGroupByBeyondSelect()

r

boolean supportsGroupByUnrelated()

a

Returns true.

boolean supportsIntegrityEnhancementFacility()

r

boolean supportsLikeEscapeClause()

a

Returns true.

boolean supportsLimitedOuterJoins()

a

Returns true.

boolean supportsMinimumSQLGrammar()

a

Returns true.

boolean supportsMixedCaseIdentifiers()

a

Returns false.

boolean supportsMixedCaseQuotedIdentifiers()

a

Returns true.

boolean supportsMultipleResultSets()

a

Returns false.

boolean supportsMultipleTransactions()

a

Returns true.

boolean supportsNonNullableColumns()

a

Returns true.

boolean supportsOpenCursorsAcrossCommit()

r

boolean supportsOpenCursorsAcrossRollback()

r

boolean supportsOpenStatementsAcrossCommit()

r

boolean supportsOpenStatementsAcrossRollback()

r

boolean supportsOrderByUnrelated()

a

Returns false.

boolean supportsOuterJoins()

a

Returns true.

boolean supportsPositionedDelete()

a

Returns false.

boolean supportsPositionedUpdate()

a

Returns false.

boolean supportsResultSetConcurrency (int, int)

r

boolean supportsResultSetType (int)

r

boolean supportsSchemasInDataManipulation()

r

boolean supportsSchemasInIndexDefinitions()

r

boolean supportsSchemasInPrivilegeDefinitions()

r

boolean supportsSchemasInProcedureCalls()

r

boolean supportsSchemasInTableDefinitions()

r

boolean supportsSelectForUpdate()

a

Returns true.

boolean supportsStoredProcedures()

a

Returns false.

boolean supportsSubqueriesInComparisons()

a

Returns true.

boolean supportsSubqueriesInExists()

a

Returns true.

boolean supportsSubqueriesInIns()

a

Returns true.

boolean supportsSubqueriesInQuantifieds()

a

Returns true.

boolean supportsTableCorrelationNames()

r

boolean supportsTransactionIsolationLevel (int)

a

Open SQL supports TRANSACTION_READ_COMMITTED and TRANSACTION_READ_UNCOMMITTED isolation levels.

boolean supportsTransactions()

a

Returns true.

Boolean supportsUnion()

a

Returns true.

Boolean supportsUnionAll()

a

Returns true.

boolean updatesAreDetected (int)

r

boolean usesLocalFilePerTable()

r

boolean usesLocalFiles()

r