| Object Methods | JDBC Version Introduced | i-net UNA | i-net SPRINTA | i-net OPTA | i-net MERLIA | Comments |
|---|---|---|---|---|---|---|
| boolean allProceduresAreCallable() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean allTablesAreSelectable() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean dataDefinitionCausesTransactionCommit() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean dataDefinitionIgnoredInTransactions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean deletesAreDetected( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean doesMaxRowSizeIncludeBlobs() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getAttributes( String, String, String, String ) | 3.0 | – | – | – | Yes | |
| ResultSet getBestRowIdentifier( String, String, String, int, boolean ) | 1.0 | Yes | Yes | Yes | Yes | |
| String getCatalogSeparator() | 1.0 | Yes | Yes | Yes | Yes | |
| String getCatalogTerm() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getCatalogs() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getColumnPrivileges( String, String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getColumns(String, String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| Connection getConnection() | 2.0 Core | – | Yes | Yes | Yes | |
| ResultSet getCrossReference( String, String, String, String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| int getDatabaseMajorVersion() | 3.0 | – | – | – | Yes | |
| int getDatabaseMinorVersion() | 3.0 | – | – | – | Yes | |
| String getDatabaseProductName() | 1.0 | Yes | Yes | Yes | Yes | |
| String getDatabaseProductVersion() | 1.0 | Yes | Yes | Yes | Yes | |
| int getDefaultTransactionIsolation() | 1.0 | Yes | Yes | Yes | Yes | |
| int getDriverMajorVersion() | 1.0 | Yes | Yes | Yes | Yes | |
| int getDriverMinorVersion() | 1.0 | Yes | Yes | Yes | Yes | |
| String getDriverName() | 1.0 | Yes | Yes | Yes | Yes | |
| String getDriverVersion() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getExportedKeys( String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| String getExtraNameCharacters() | 1.0 | Yes | Yes | Yes | Yes | |
| String getIdentifierQuoteString() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getImportedKeys( String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getIndexInfo( String, String, String, boolean, boolean ) | 1.0 | Yes | Yes | Yes | Yes | |
| int getJDBCMajorVersion() | 3.0 | – | – | – | Yes | |
| int getJDBCMinorVersion() | 3.0 | – | – | – | Yes | |
| int getMaxBinaryLiteralLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxCatalogNameLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxCharLiteralLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxColumnNameLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxColumnsInGroupBy() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxColumnsInIndex() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxColumnsInOrderBy() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxColumnsInSelect() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxColumnsInTable() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxConnections() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxCursorNameLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxIndexLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxProcedureNameLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxRowSize() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxSchemaNameLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxStatementLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxStatements() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxTableNameLength() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxTablesInSelect() | 1.0 | Yes | Yes | Yes | Yes | |
| int getMaxUserNameLength() | 1.0 | Yes | Yes | Yes | Yes | |
| String getNumericFunctions() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getPrimaryKeys( String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getProcedureColumns( String, String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| String getProcedureTerm() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getProcedures( String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| int getResultSetHoldability() | 3.0 | – | – | – | Yes | |
| String getSQLKeywords() | 1.0 | Yes | Yes | Yes | Yes | |
| int getSQLStateType() | 3.0 | – | – | – | Yes | |
| String getSchemaTerm() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getSchemas() | 1.0 | Yes | Yes | Yes | Yes | |
| String getSearchStringEscape() | 1.0 | Yes | Yes | Yes | Yes | |
| String getStringFunctions() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getSuperTables( String, String, String ) | 3.0 | – | – | – | Yes | |
| ResultSet getSuperTypes( String, String, String ) | 3.0 | – | – | – | Yes | |
| String getSystemFunctions() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getTablePrivileges( String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getTableTypes() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getTables( String, String, String, String [] ) | 1.0 | Yes | Yes | Yes | Yes | |
| String getTimeDateFunctions() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getTypeInfo() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getUDTs( String, String, String, int [] ) | 2.0 Core | – | Yes | Yes | Yes | |
| String getURL() | 1.0 | Yes | Yes | Yes | Yes | |
| String getUserName() | 1.0 | Yes | Yes | Yes | Yes | |
| ResultSet getVersionColumns( String, String, String ) | 1.0 | Yes | Yes | Yes | Yes | |
| boolean insertsAreDetected( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean isCatalogAtStart() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean isReadOnly() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean locatorsUpdateCopy() | 3.0 | – | – | – | Yes | |
| boolean nullPlusNonNullIsNull() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean nullsAreSortedAtEnd() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean nullsAreSortedAtStart() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean nullsAreSortedHigh() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean nullsAreSortedLow() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean othersDeletesAreVisible( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean othersInsertsAreVisible( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean othersUpdatesAreVisible( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean ownDeletesAreVisible( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean ownInsertsAreVisible( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean ownUpdatesAreVisible( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean storesLowerCaseIdentifiers() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean storesLowerCaseQuotedIdentifiers() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean storesMixedCaseIdentifiers() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean storesMixedCaseQuotedIdentifiers() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean storesUpperCaseIdentifiers() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean storesUpperCaseQuotedIdentifiers() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsANSI92EntryLevelSQL() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsANSI92FullSQL() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsANSI92IntermediateSQL() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsAlterTableWithAddColumn() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsAlterTableWithDropColumn() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsBatchUpdates() | 2.0 Core | – | Yes | Yes | Yes | |
| boolean supportsCatalogsInDataManipulation() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsCatalogsInIndexDefinitions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsCatalogsInPrivilegeDefinitions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsCatalogsInProcedureCalls() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsCatalogsInTableDefinitions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsColumnAliasing() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsConvert() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsConvert( int, int ) | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsCoreSQLGrammar() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsCorrelatedSubqueries() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsDataDefinitionAndDataManipulationTransactions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsDataManipulationTransactionsOnly() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsDifferentTableCorrelationNames() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsExpressionsInOrderBy() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsExtendedSQLGrammar() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsFullOuterJoins() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsGetGeneratedKeys() | 3.0 | – | – | – | Yes | |
| boolean supportsGroupBy() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsGroupByBeyondSelect() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsGroupByUnrelated() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsIntegrityEnhancementFacility() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsLikeEscapeClause() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsLimitedOuterJoins() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsMinimumSQLGrammar() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsMixedCaseIdentifiers() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsMixedCaseQuotedIdentifiers() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsMultipleOpenResults() | 3.0 | – | – | – | Yes | |
| boolean supportsMultipleResultSets() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsMultipleTransactions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsNamedParameters() | 3.0 | – | – | – | Yes | |
| boolean supportsNonNullableColumns() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsOpenCursorsAcrossCommit() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsOpenCursorsAcrossRollback() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsOpenStatementsAcrossCommit() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsOpenStatementsAcrossRollback() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsOrderByUnrelated() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsOuterJoins() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsPositionedDelete() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsPositionedUpdate() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsResultSetConcurrency( int, int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean supportsResultSetHoldability( int ) | 3.0 | – | – | – | Yes | |
| boolean supportsResultSetType( int ) | 2.0 Core | No | Yes | Yes | Yes | |
| boolean supportsSavepoints() | 3.0 | – | – | – | Yes | |
| boolean supportsSchemasInDataManipulation() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSchemasInIndexDefinitions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSchemasInPrivilegeDefinitions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSchemasInProcedureCalls() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSchemasInTableDefinitions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSelectForUpdate() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsStatementPooling() | 3.0 | – | – | – | Yes | |
| boolean supportsStoredProcedures() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSubqueriesInComparisons() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSubqueriesInExists() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSubqueriesInIns() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsSubqueriesInQuantifieds() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsTableCorrelationNames() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsTransactionIsolationLevel( int ) | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsTransactions() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsUnion() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean supportsUnionAll() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean updatesAreDetected( int ) | 2.0 Core | – | Yes | Yes | Yes | |
| boolean usesLocalFilePerTable() | 1.0 | Yes | Yes | Yes | Yes | |
| boolean usesLocalFiles() | 1.0 | Yes | Yes | Yes | Yes |