| Methods: | Return Types: | Supported: |
Interface Blob |
| getBinaryStream() | InputStream | Yes |
| getBytes(long pos, int length) | byte[] | Yes |
| length() | long | Yes |
| position(Blob pattern, long start) | long | No |
| position(byte[] pattern, long start) | long | No |
| Methods: | Return Types: | Supported: |
Interface CallableStatement |
| getArray(int i) | Array | No |
| getBigDecimal(int parameterIndex) | BigDecimal | Yes |
| getBigDecimal(int parameterIndex, int scale) | BigDecimal | Yes |
| getBlob(int i) | Blob | No (soon) |
| getBoolean(int parameterIndex) | boolean | Yes |
| getByte(int parameterIndex) | byte | Yes |
| getBytes(int parameterIndex) | byte[] | Yes |
| getClob(int i) | Clob | No (soon) |
| getDate(int parameterIndex) | Date | Yes |
| getDate(int parameterIndex, Calendar cal) | Date | No (soon) |
| getDouble(int parameterIndex) | double | Yes |
| getFloat(int parameterIndex) | float | Yes |
| getInt(int parameterIndex) | int | Yes |
| getLong(int parameterIndex) | long | Yes |
| getObject(int parameterIndex) | Object | Yes |
| getObject(int i, Map map) | Object | No |
| getRef(int i) | Ref | No |
| getShort(int parameterIndex) | short | Yes |
| getString(int parameterIndex) | String | Yes |
| getTime(int parameterIndex) | Time | Yes |
| getTime(int parameterIndex, Calendar cal) | Time | Yes |
| getTimestamp(int parameterIndex) | Timestamp | Yes |
| getTimestamp(int parameterIndex, Calendar cal) | Timestamp | No |
| registerOutParameter(int parameterIndex, int sqlType) | void | Yes |
| registerOutParameter(int parameterIndex, int sqlType, int scale) | void | No |
| registerOutParameter(int paramIndex, int sqlType, String typeName) | void | No |
| wasNull() | boolean | Yes |
| Methods: | Return Types: | Supported: |
Interface Clob |
| getAsciiStream() | InputStream | No |
| getCharacterStream() | Reader | Yes |
| getSubString(long pos, int length) | String | Yes |
| length() | long | Yes |
| position(Clob searchstr, long start) | long | No |
| position(String searchstr, long start) | long | No |
| Methods: | Return Types: | Supported: |
Interface Connection |
| clearWarnings() | void | Yes |
| close() | void | Yes |
| commit() | void | Yes |
| createStatement() | Statement | Yes |
| createStatement(int resultSetType, int resultSetConcurrency) | Statement | Yes |
| getAutoCommit() | boolean | Yes |
| getCatalog() | String | Yes |
| getMetaData() | DatabaseMetaData | Yes |
| getTransactionIsolation() | int | Yes |
| getTypeMap() | Map | No |
| getWarnings() | SQLWarning | Yes |
| isClosed() | boolean | Yes |
| isReadOnly() | boolean | Yes |
| nativeSQL(String sql) | String | Yes |
| prepareCall(String sql) | CallableStatement | Yes |
| prepareCall(String sql, int resultSetType, int resultSetConcurrency) | CallableStatement | Yes |
| prepareStatement(String sql) | PreparedStatement | Yes |
| prepareStatement(String sql, int resultSetType, int resultSetConcurrency) | PreparedStatement | Yes |
| rollback() | void | Yes |
| setAutoCommit(boolean autoCommit) | void | Yes |
| setCatalog(String catalog) | void | Yes |
| setReadOnly(boolean readOnly) | void | Yes |
| setTransactionIsolation(int level) | void | Yes |
| setTypeMap(Map map) | void | No |
| Methods: | Return Types: | Supported: |
Interface DatabaseMetaData |
| allProceduresAreCallable() | boolean | Yes |
| allTablesAreSelectable() | boolean | Yes |
| dataDefinitionCausesTransactionCommit() | boolean | Yes |
| dataDefinitionIgnoredInTransactions() | boolean | Yes |
| deletesAreDetected(int type) | boolean | Yes |
| doesMaxRowSizeIncludeBlobs() | boolean | Yes |
| getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) | ResultSet | Yes |
| getCatalogs() | ResultSet | Yes |
| getCatalogSeparator() | String | Yes |
| getCatalogTerm() | String | Yes |
| getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) | ResultSet | Yes |
| getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | ResultSet | Yes |
| getConnection() | Connection | Yes |
| getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) | ResultSet | Yes |
| getDatabaseProductName() | String | Yes |
| getDatabaseProductVersion() | String | Yes |
| getDefaultTransactionIsolation() | int | Yes |
| getDriverMajorVersion() | int | Yes |
| getDriverMinorVersion() | int | Yes |
| getDriverName() | String | Yes |
| getDriverVersion() | String | Yes |
| getExportedKeys(String catalog, String schema, String table) | ResultSet | Yes |
| getExtraNameCharacters() | String | 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 |
| 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 |
| 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 |
| getSchemaTerm() | String | Yes |
| getSearchStringEscape() | String | Yes |
| getSQLKeywords() | String | Yes |
| getStringFunctions() | String | Yes |
| getSystemFunctions() | String | Yes |
| getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) | ResultSet | Yes |
| getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) | ResultSet | Yes |
| getTableTypes() | ResultSet | Yes |
| getTimeDateFunctions() | String | Yes |
| getTypeInfo() | ResultSet | Yes |
| getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) | ResultSet | Yes |
| getURL() | String | Yes |
| getUserName() | String | Yes |
| getVersionColumns(String catalog, String schema, String table) | ResultSet | Yes |
| insertsAreDetected(int type) | boolean | Yes |
| isCatalogAtStart() | boolean | Yes |
| isReadOnly() | boolean | Yes |
| nullPlusNonNullIsNull() | boolean | Yes |
| nullsAreSortedAtEnd() | boolean | Yes |
| nullsAreSortedAtStart() | boolean | Yes |
| nullsAreSortedHigh() | boolean | Yes |
| nullsAreSortedLow() | 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 |
| storesLowerCaseQuotedIdentifiers() | boolean | Yes |
| storesMixedCaseIdentifiers() | boolean | Yes |
| storesMixedCaseQuotedIdentifiers() | boolean | Yes |
| storesUpperCaseIdentifiers() | boolean | Yes |
| storesUpperCaseQuotedIdentifiers() | boolean | Yes |
| supportsAlterTableWithAddColumn() | boolean | Yes |
| supportsAlterTableWithDropColumn() | boolean | Yes |
| supportsANSI92EntryLevelSQL() | boolean | Yes |
| supportsANSI92FullSQL() | boolean | Yes |
| supportsANSI92IntermediateSQL() | boolean | Yes |
| supportsBatchUpdates() | boolean | Yes |
| supportsCatalogsInDataManipulation() | boolean | Yes |
| supportsCatalogsInIndexDefinitions() | boolean | Yes |
| supportsCatalogsInPrivilegeDefinitions() | boolean | Yes |
| supportsCatalogsInProcedureCalls() | boolean | Yes |
| supportsCatalogsInTableDefinitions() | boolean | Yes |
| supportsColumnAliasing() | boolean | Yes |
| supportsConvert() | boolean | No |
| supportsConvert(int fromType, int toType) | boolean | No |
| supportsCoreSQLGrammar() | boolean | Yes |
| supportsCorrelatedSubqueries() | boolean | Yes |
| supportsDataDefinitionAndDataManipulationTransactions() | boolean | Yes |
| supportsDataManipulationTransactionsOnly() | boolean | Yes |
| supportsDifferentTableCorrelationNames() | boolean | Yes |
| supportsExpressionsInOrderBy() | boolean | Yes |
| supportsExtendedSQLGrammar() | boolean | Yes |
| supportsFullOuterJoins() | boolean | Yes |
| supportsGroupBy() | boolean | Yes |
| supportsGroupByBeyondSelect() | boolean | Yes |
| supportsGroupByUnrelated() | boolean | Yes |
| supportsIntegrityEnhancementFacility() | boolean | Yes |
| supportsLikeEscapeClause() | boolean | Yes |
| supportsLimitedOuterJoins() | boolean | Yes |
| supportsMinimumSQLGrammar() | boolean | Yes |
| supportsMixedCaseIdentifiers() | boolean | Yes |
| supportsMixedCaseQuotedIdentifiers() | boolean | Yes |
| supportsMultipleResultSets() | boolean | Yes |
| supportsMultipleTransactions() | boolean | Yes |
| supportsNonNullableColumns() | boolean | Yes |
| supportsOpenCursorsAcrossCommit() | boolean | Yes |
| supportsOpenCursorsAcrossRollback() | boolean | Yes |
| supportsOpenStatementsAcrossCommit() | boolean | Yes |
| supportsOpenStatementsAcrossRollback() | boolean | Yes |
| supportsOrderByUnrelated() | boolean | Yes |
| supportsOuterJoins() | boolean | Yes |
| supportsPositionedDelete() | boolean | Yes |
| supportsPositionedUpdate() | boolean | Yes |
| supportsResultSetConcurrency(int type, int concurrency) | boolean | Yes |
| supportsResultSetType(int type) | boolean | Yes |
| supportsSchemasInDataManipulation() | boolean | Yes |
| supportsSchemasInIndexDefinitions() | boolean | Yes |
| supportsSchemasInPrivilegeDefinitions() | boolean | Yes |
| supportsSchemasInProcedureCalls() | boolean | Yes |
| supportsSchemasInTableDefinitions() | boolean | Yes |
| supportsSelectForUpdate() | boolean | Yes |
| supportsStoredProcedures() | boolean | Yes |
| supportsSubqueriesInComparisons() | boolean | Yes |
| supportsSubqueriesInExists() | boolean | Yes |
| supportsSubqueriesInIns() | boolean | Yes |
| supportsSubqueriesInQuantifieds() | boolean | Yes |
| supportsTableCorrelationNames() | boolean | Yes |
| supportsTransactionIsolationLevel(int level) | boolean | Yes |
| supportsTransactions() | boolean | Yes |
| supportsUnion() | boolean | Yes |
| supportsUnionAll() | boolean | Yes |
| updatesAreDetected(int type) | boolean | Yes |
| usesLocalFilePerTable() | boolean | Yes |
| usesLocalFiles() | boolean | Yes |
| Methods: | Return Types: | Supported: |
Interface PreparedStatement |
| addBatch() | void | Yes |
| clearParameters() | void | Yes |
| execute() | boolean | Yes |
| executeQuery() | ResultSet | Yes |
| executeUpdate() | int | Yes |
| getMetaData() | ResultSetMetaData | Yes |
| setArray(int i, Array x) | void | No |
| setAsciiStream(int parameterIndex, InputStream x, int length) | void | Yes |
| setBigDecimal(int parameterIndex, BigDecimal x) | void | Yes |
| setBinaryStream(int parameterIndex, InputStream x, int length) | void | Yes |
| setBlob(int i, Blob x) | void | Yes |
| setBoolean(int parameterIndex, boolean x) | void | Yes |
| setByte(int parameterIndex, byte x) | void | Yes |
| setBytes(int parameterIndex, byte[] x) | void | Yes |
| setCharacterStream(int parameterIndex, Reader reader, int length) | void | Yes |
| setClob(int i, Clob x) | void | Yes |
| setDate(int parameterIndex, Date x) | void | Yes |
| setDate(int parameterIndex, Date x, Calendar cal) | void | Yes |
| setDouble(int parameterIndex, double x) | void | Yes |
| setFloat(int parameterIndex, float x) | void | Yes |
| setInt(int parameterIndex, int x) | void | Yes |
| setLong(int parameterIndex, long x) | void | Yes |
| setNull(int parameterIndex, int sqlType) | void | yes |
| setNull(int paramIndex, int sqlType, String typeName) | void | no |
| setObject(int parameterIndex, Object x) | void | Yes |
| setObject(int parameterIndex, Object x, int targetSqlType) | void | Yes |
| setObject(int parameterIndex, Object x, int targetSqlType, int scale) | void | Yes |
| setRef(int i, Ref x) | void | No |
| setShort(int parameterIndex, short x) | void | Yes |
| setString(int parameterIndex, String x) | void | Yes |
| setTime(int parameterIndex, Time x) | void | Yes |
| setTime(int parameterIndex, Time x, Calendar cal) | void | Yes |
| setTimestamp(int parameterIndex, Timestamp x) | void | Yes |
| setTimestamp(int parameterIndex, Timestamp x, Calendar cal) | void | Yes |
| setUnicodeStream(int parameterIndex, InputStream x, int length) | void | Yes |
| Methods: | Return Types: | Supported: |
Interface ResultSet |
| absolute(int row) | boolean | Yes |
| afterLast() | void | Yes |
| beforeFirst() | void | Yes |
| cancelRowUpdates() | void | Yes |
| clearWarnings() | void | Yes |
| close() | void | Yes |
| deleteRow() | void | Yes |
| findColumn(String columnName) | int | Yes |
| first() | boolean | Yes |
| getArray(int i) | Array | No |
| getArray(String colName) | Array | Yes |
| getAsciiStream(int columnIndex) | InputStream | Yes |
| getAsciiStream(String columnName) | InputStream | Yes |
| getBigDecimal(int columnIndex) | BigDecimal | Yes |
| getBigDecimal(int columnIndex, int scale) | BigDecimal | Yes |
| getBigDecimal(String columnName) | BigDecimal | Yes |
| getBigDecimal(String columnName, int scale) | BigDecimal | Yes |
| getBinaryStream(int columnIndex) | InputStream | Yes |
| getBinaryStream(String columnName) | InputStream | Yes |
| getBlob(int i) | Blob | Yes |
| getBlob(String colName) | Blob | Yes |
| getBoolean(int columnIndex) | boolean | Yes |
| getBoolean(String columnName) | boolean | Yes |
| getByte(int columnIndex) | byte | Yes |
| getByte(String columnName) | byte | Yes |
| getBytes(int columnIndex) | byte[] | Yes |
| getBytes(String columnName) | byte[] | Yes |
| getCharacterStream(int columnIndex) | Reader | Yes |
| getCharacterStream(String columnName) | Reader | Yes |
| getClob(int i) | Clob | Yes |
| getClob(String colName) | Clob | Yes |
| getConcurrency() | int | Yes |
| getCursorName() | String | Yes |
| getDate(int columnIndex) | Date | Yes |
| getDate(int columnIndex, Calendar cal) | Date | Yes |
| getDate(String columnName) | Date | Yes |
| getDate(String columnName, Calendar cal) | Date | Yes |
| getDouble(int columnIndex) | double | Yes |
| getDouble(String columnName) | double | Yes |
| getFetchDirection() | int | Yes |
| getFetchSize() | int | Yes |
| getFloat(int columnIndex) | float | Yes |
| getFloat(String columnName) | float | Yes |
| getInt(int columnIndex) | int | Yes |
| getInt(String columnName) | int | Yes |
| getLong(int columnIndex) | long | Yes |
| getLong(String columnName) | long | Yes |
| getMetaData() | ResultSetMetaData | Yes |
| getObject(int columnIndex) | Object | Yes |
| getObject(int i, Map map) | Object | No |
| getObject(String columnName) | Object | Yes |
| getObject(String colName, Map map) | Object | No |
| getRef(int i) | Ref | No |
| getRef(String colName) | Ref | No |
| getRow() | int | Yes |
| getShort(int columnIndex) | short | Yes |
| getShort(String columnName) | short | Yes |
| getStatement() | Statement | Yes |
| getString(int columnIndex) | String | Yes |
| getString(String columnName) | String | Yes |
| getTime(int columnIndex) | Time | Yes |
| getTime(int columnIndex, Calendar cal) | Time | Yes |
| getTime(String columnName) | Time | Yes |
| getTime(String columnName, Calendar cal) | Time | Yes |
| getTimestamp(int columnIndex) | Timestamp | Yes |
| getTimestamp(int columnIndex, Calendar cal) | Timestamp | Yes |
| getTimestamp(String columnName) | Timestamp | Yes |
| getTimestamp(String columnName, Calendar cal) | Timestamp | Yes |
| getType() | int | Yes |
| getUnicodeStream(int columnIndex) | InputStream | Yes |
| getUnicodeStream(String columnName) | InputStream | Yes |
| getWarnings() | SQLWarning | Yes |
| insertRow() | void | Yes |
| isAfterLast() | boolean | Yes |
| isBeforeFirst() | boolean | Yes |
| isFirst() | boolean | Yes |
| isLast() | boolean | Yes |
| last() | boolean | Yes |
| moveToCurrentRow() | void | Yes |
| moveToInsertRow() | void | Yes |
| next() | boolean | Yes |
| previous() | boolean | Yes |
| refreshRow() | void | Yes |
| relative(int rows) | boolean | Yes |
| rowDeleted() | boolean | Yes |
| rowInserted() | boolean | Yes |
| rowUpdated() | boolean | Yes |
| setFetchDirection(int direction) | void | Yes |
| setFetchSize(int rows) | void | Yes |
| updateAsciiStream(int columnIndex, InputStream x, int length) | void | Yes |
| updateAsciiStream(String columnName, InputStream x, int length) | void | Yes |
| updateBigDecimal(int columnIndex, BigDecimal x) | void | Yes |
| updateBigDecimal(String columnName, BigDecimal x) | void | Yes |
| updateBinaryStream(int columnIndex, InputStream x, int length) | void | Yes |
| updateBinaryStream(String columnName, InputStream x, int length) | void | Yes |
| updateBoolean(int columnIndex, boolean x) | void | Yes |
| updateBoolean(String columnName, boolean x) | void | Yes |
| updateByte(int columnIndex, byte x) | void | Yes |
| updateByte(String columnName, byte x) | void | Yes |
| updateBytes(int columnIndex, byte[] x) | void | Yes |
| updateBytes(String columnName, byte[] x) | void | Yes |
| updateCharacterStream(int columnIndex, Reader x, int length) | void | Yes |
| updateCharacterStream(String columnName, Reader reader, int length) | void | Yes |
| updateDate(int columnIndex, Date x) | void | Yes |
| updateDate(String columnName, Date x) | void | Yes |
| updateDouble(int columnIndex, double x) | void | Yes |
| updateDouble(String columnName, double x) | void | Yes |
| updateFloat(int columnIndex, float x) | void | Yes |
| updateFloat(String columnName, float x) | void | Yes |
| updateInt(int columnIndex, int x) | void | Yes |
| updateInt(String columnName, int x) | void | Yes |
| updateLong(int columnIndex, long x) | void | Yes |
| updateLong(String columnName, long x) | void | Yes |
| updateNull(int columnIndex) | void | Yes |
| updateNull(String columnName) | void | Yes |
| updateObject(int columnIndex, Object x) | void | Yes |
| updateObject(int columnIndex, Object x, int scale) | void | Yes |
| updateObject(String columnName, Object x) | void | Yes |
| updateObject(String columnName, Object x, int scale) | void | Yes |
| updateRow() | void | Yes |
| updateShort(int columnIndex, short x) | void | Yes |
| updateShort(String columnName, short x) | void | Yes |
| updateString(int columnIndex, String x) | void | Yes |
| updateString(String columnName, String x) | void | Yes |
| updateTime(int columnIndex, Time x) | void | Yes |
| updateTime(String columnName, Time x) | void | Yes |
| updateTimestamp(int columnIndex, Timestamp x) | void | Yes |
| updateTimestamp(String columnName, Timestamp x) | void | Yes |
| wasNull() | boolean | Yes |
| Methods: | Return Types: | Supported: |
Interface ResultSetMetaData |
| getCatalogName(int column) | String | Yes |
| getColumnClassName(int column) | String | No |
| getColumnCount() | int | Yes |
| getColumnDisplaySize(int column) | int | Yes |
| getColumnLabel(int column) | String | Yes |
| getColumnName(int column) | String | Yes |
| getColumnType(int column) | int | Yes |
| getColumnTypeName(int column) | String | Yes |
| getPrecision(int column) | int | Yes |
| getScale(int column) | int | Yes |
| getSchemaName(int column) | String | Yes |
| getTableName(int column) | String | Yes |
| isAutoIncrement(int column) | boolean | Yes |
| isCaseSensitive(int column) | boolean | Yes |
| isCurrency(int column) | boolean | Yes |
| isDefinitelyWritable(int column) | boolean | Yes |
| isNullable(int column) | int | Yes |
| isReadOnly(int column) | boolean | Yes |
| isSearchable(int column) | boolean | Yes |
| isSigned(int column) | boolean | Yes |
| isWritable(int column) | boolean | Yes |
| Methods: | Return Types: | Supported: |
Interface Statement |
| addBatch(String sql) | void | Yes |
| cancel() | void | No |
| clearBatch() | void | Yes |
| clearWarnings() | void | Yes |
| close() | void | Yes |
| execute(String sql) | boolean | Yes |
| executeBatch() | int[] | Yes |
| executeQuery(String sql) | ResultSet | Yes |
| executeUpdate(String sql) | int | Yes |
| getConnection() | Connection | Yes |
| getFetchDirection() | int | Yes |
| getFetchSize() | int | Yes |
| getMaxFieldSize() | int | Yes |
| getMaxRows() | int | Yes |
| getMoreResults() | boolean | Yes |
| getQueryTimeout() | int | Yes |
| getResultSet() | ResultSet | Yes |
| getResultSetConcurrency() | int | Yes |
| getResultSetType() | int | Yes |
| getUpdateCount() | int | Yes |
| getWarnings() | SQLWarning | Yes |
| setCursorName(String name) | void | no |
| setEscapeProcessing(boolean enable) | void | Yes |
| setFetchDirection(int direction) | void | no |
| setFetchSize(int rows) | void | no |
| setMaxFieldSize(int max) | void | Yes |
| setMaxRows(int max) | void | Yes |
| setQueryTimeout(int seconds) | void | Yes |
| Methods: | Return Types: | Supported: |
Interface Array |
No | |
Interface Struct |
No | |
Interface SQLOutput |
No | |
Interface SQLInput |
No | |
Interface SQLData |
No | |
Interface Ref |
No | |
Interface Driver |
Support but not to public |
Posted in: DB2Connectivity -JDBC
