HiT JDBC/400 API サポート

 

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