Symfoware Server アプリケーション開発ガイド(JDBCドライバ編) - FUJITSU - |
目次 索引 |
RDB2_TCP接続とRDA-SV接続でのSymfoware JDBCドライバのサポートAPIについて以下に示します。
インタフェース名 |
メソッド名 |
RDB2_TCP |
RDA-SV |
---|---|---|---|
CallableStatement |
getArray(int i) |
× |
× |
getBigDecimal(int parameterIndex) |
○ |
○ |
|
getBigDecimal(int parameterIndex, int scale) |
○ |
○ |
|
getBlob(int i) |
× |
× |
|
getBoolean(int parameterIndex) |
○ |
× |
|
getByte(int parameterIndex) |
○ |
○ |
|
getBytes(int parameterIndex) |
○ |
× |
|
getClob(int i) |
× |
× |
|
getDate(int parameterIndex) |
○ |
○ |
|
getDate(int parameterIndex, Calendar cal) |
× |
× |
|
getDouble(int parameterIndex) |
○ |
○ |
|
getFloat(int parameterIndex) |
○ |
○ |
|
getInt(int parameterIndex) |
○ |
○ |
|
getLong(int parameterIndex) |
○ |
○ |
|
getObject(int parameterIndex) |
× |
× |
|
getObject(int i, Map map) |
× |
× |
|
getRef(int i) |
× |
× |
|
getShort(int parameterIndex) |
○ |
○ |
|
getString(int parameterIndex) |
○ |
○ |
|
getTime(int parameterIndex) |
○ |
○ |
|
getTime(int parameterIndex, Calendar cal) |
× |
× |
|
getTimestamp(int parameterIndex) |
○ |
○ |
|
getTimestamp(int parameterIndex, Calendar cal) |
× |
× |
|
registerOutParameter(int parameterIndex, int sqlType) |
○ |
○ |
|
registerOutParameter(int parameterIndex, int sqlType, int scale) |
○ |
○ |
|
registerOutParameter(int paramIndex, int sqlType, String typeName) |
× |
× |
|
wasNull() |
○ |
○ |
|
Connection |
clearWarnings() |
○ |
○ |
close() |
○ |
○ |
|
commit() |
○ |
○ |
|
createStatement() |
○ |
○ |
|
createStatement(int resultSetType, int resultSetConcurrency) |
○ |
× |
|
getAutoCommit() |
○ |
○ |
|
getCatalog() |
○ |
× |
|
getMetaData() |
○ |
○ |
|
getTransactionIsolation() |
○ |
○ |
|
getTypeMap() |
× |
× |
|
getWarnings() |
○ |
○ |
|
isClosed() |
○ |
○ |
|
isReadOnly() |
○ |
○ |
|
nativeSQL(String sql) |
× |
× |
|
prepareCall(String sql) |
○ |
○ |
|
prepareCall(String sql, int resultSetType, int resultSetConcurrency) |
× |
× |
|
prepareStatement(String sql) |
○ |
○ |
|
prepareStatement(String sql, int resultSetType, int resultSetConcurrency) |
○ |
× |
|
rollback() |
○ |
○ |
|
setAutoCommit(boolean autoCommit) |
○ |
○ |
|
setCatalog(String catalog) |
○ |
× |
|
setReadOnly(boolean readOnly) |
○ |
○ |
|
setTransactionIsolation(int level) |
○ |
○ |
|
setTypeMap(Map map) |
× |
× |
|
DatabaseMetaData |
allProceduresAreCallable() |
○ |
○ |
allTablesAreSelectable() |
○ |
○ |
|
dataDefinitionCausesTransactionCommit() |
○ |
○ |
|
dataDefinitionIgnoredInTransactions() |
○ |
○ |
|
deletesAreDetected(int type) |
× |
× |
|
doesMaxRowSizeIncludeBlobs() |
○ |
○ |
|
getBestRowIdentifier(String catalog, String schema, String table, int scope, Boolean nullable) |
× |
× |
|
getCatalogs() |
× |
× |
|
getCatalogSeparator() |
× |
× |
|
getCatalogTerm() |
× |
× |
|
getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) |
× |
× |
|
getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) |
○ |
○ |
|
getConnection() |
○ |
○ |
|
getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) |
× |
× |
|
getDatabaseProductName() |
○ |
○ |
|
getDatabaseProductVersion() |
○ |
○ |
|
getDefaultTransactionIsolation() |
○ |
○ |
|
getDriverMajorVersion() |
○ |
○ |
|
getDriverMinorVersion() |
○ |
○ |
|
getDriverName() |
○ |
○ |
|
getDriverVersion() |
○ |
○ |
|
getExportedKeys(String catalog, String schema, String table) |
× |
× |
|
getExtraNameCharacters() |
○ |
○ |
|
getIdentifierQuoteString() |
○ |
○ |
|
getImportedKeys(String catalog, String schema, String table) |
× |
× |
|
getIndexInfo(String catalog, String schema, String table, Boolean unique, Boolean approximate) |
○ |
○ |
|
getMaxBinaryLiteralLength() |
○ |
○ |
|
getMaxCatalogNameLength() |
× |
× |
|
getMaxCharLiteralLength() |
○ |
○ |
|
getMaxColumnNameLength() |
○ |
○ |
|
getMaxColumnsInGroupBy() |
○ |
○ |
|
getMaxColumnsInIndex() |
○ |
○ |
|
getMaxColumnsInOrderBy() |
○ |
○ |
|
getMaxColumnsInSelect() |
○ |
○ |
|
getMaxColumnsInTable() |
○ |
○ |
|
getMaxConnections() |
○ |
○ |
|
getMaxCursorNameLength() |
○ |
○ |
|
getMaxIndexLength() |
○ |
○ |
|
getMaxProcedureNameLength() |
○ |
○ |
|
getMaxRowSize() |
○ |
○ |
|
getMaxSchemaNameLength() |
○ |
○ |
|
getMaxStatementLength() |
○ |
○ |
|
getMaxStatements() |
○ |
○ |
|
getMaxTableNameLength() |
○ |
○ |
|
getMaxTablesInSelect() |
○ |
○ |
|
getMaxUserNameLength() |
○ |
○ |
|
getNumericFunctions() |
○ |
○ |
|
getPrimaryKeys(String catalog, String schema, String table) |
○ |
○ |
|
getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) |
○ |
○ |
|
getProcedures(String catalog, String schemaPattern, String procedureNamePattern) |
○ |
○ |
|
getProcedureTerm() |
○ |
○ |
|
getSchemas() |
○ |
○ |
|
getSchemaTerm() |
○ |
○ |
|
getSearchStringEscape() |
○ |
○ |
|
getSQLKeywords() |
○ |
○ |
|
getStringFunctions() |
○ |
○ |
|
getSystemFunctions() |
○ |
○ |
|
getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) |
× |
× |
|
getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) |
○ |
○ |
|
getTableTypes() |
× |
× |
|
getTimeDateFunctions() |
○ |
○ |
|
getTypeInfo() |
○ |
○ |
|
getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) |
× |
× |
|
getURL() |
○ |
○ |
|
getUserName() |
○ |
○ |
|
getVersionColumns(String catalog, String schema, String table) |
× |
× |
|
insertsAreDetected(int type) |
× |
× |
|
isCatalogAtStart() |
× |
× |
|
isReadOnly() |
○ |
○ |
|
nullPlusNonNullIsNull() |
○ |
○ |
|
nullsAreSortedAtEnd() |
○ |
○ |
|
nullsAreSortedAtStart() |
○ |
○ |
|
nullsAreSortedHigh() |
○ |
○ |
|
nullsAreSortedLow() |
○ |
○ |
|
othersDeletesAreVisible(int type) |
× |
× |
|
othersInsertsAreVisible(int type) |
× |
× |
|
othersUpdatesAreVisible(int type) |
× |
× |
|
ownDeletesAreVisible(int type) |
× |
× |
|
ownInsertsAreVisible(int type) |
× |
× |
|
ownUpdatesAreVisible(int type) |
× |
× |
|
storesLowerCaseIdentifiers() |
○ |
○ |
|
storesLowerCaseQuotedIdentifiers() |
○ |
○ |
|
storesMixedCaseIdentifiers() |
○ |
○ |
|
storesMixedCaseQuotedIdentifiers() |
○ |
○ |
|
storesUpperCaseIdentifiers() |
○ |
○ |
|
storesUpperCaseQuotedIdentifiers() |
○ |
○ |
|
supportsAlterTableWithAddColumn() |
○ |
○ |
|
supportsAlterTableWithDropColumn() |
○ |
○ |
|
supportsANSI92EntryLevelSQL() |
○ |
○ |
|
supportsANSI92FullSQL() |
○ |
○ |
|
supportsANSI92IntermediateSQL() |
○ |
○ |
|
supportsBatchUpdates() |
× |
× |
|
supportsCatalogsInDataManipulation() |
× |
× |
|
supportsCatalogsInIndexDefinitions() |
× |
× |
|
supportsCatalogsInPrivilegeDefinitions() |
× |
× |
|
supportsCatalogsInProcedureCalls() |
× |
× |
|
supportsCatalogsInTableDefinitions() |
× |
× |
|
supportsColumnAliasing() |
○ |
○ |
|
supportsConvert() |
○ |
○ |
|
supportsConvert(int fromType, int toType) |
○ |
○ |
|
supportsCoreSQLGrammar() |
○ |
○ |
|
supportsCorrelatedSubqueries() |
○ |
○ |
|
supportsDataDefinitionAndDataManipulationTransactions() |
○ |
○ |
|
supportsDataManipulationTransactionsOnly() |
○ |
○ |
|
supportsDifferentTableCorrelationNames() |
○ |
○ |
|
supportsExpressionsInOrderBy() |
○ |
○ |
|
supportsExtendedSQLGrammar() |
○ |
○ |
|
supportsFullOuterJoins() |
○ |
○ |
|
supportsGroupBy() |
○ |
○ |
|
supportsGroupByBeyondSelect() |
○ |
○ |
|
supportsGroupByUnrelated() |
○ |
○ |
|
supportsIntegrityEnhancementFacility() |
○ |
○ |
|
supportsLikeEscapeClause() |
○ |
○ |
|
supportsLimitedOuterJoins() |
○ |
○ |
|
supportsMinimumSQLGrammar() |
○ |
○ |
|
supportsMixedCaseIdentifiers() |
○ |
○ |
|
supportsMixedCaseQuotedIdentifiers() |
○ |
○ |
|
supportsMultipleResultSets() |
○ |
○ |
|
supportsMultipleTransactions() |
○ |
○ |
|
supportsNonNullableColumns() |
○ |
○ |
|
supportsOpenCursorsAcrossCommit() |
○ |
○ |
|
supportsOpenCursorsAcrossRollback() |
○ |
○ |
|
supportsOpenStatementsAcrossCommit() |
○ |
○ |
|
supportsOpenStatementsAcrossRollback() |
○ |
○ |
|
supportsOrderByUnrelated() |
○ |
○ |
|
supportsOuterJoins() |
○ |
○ |
|
supportsPositionedDelete() |
○ |
○ |
|
supportsPositionedUpdate() |
○ |
○ |
|
supportsResultSetConcurrency(int type, int concurrency) |
○ |
× |
|
supportsResultSetType(int type) |
○ |
× |
|
supportsSchemasInDataManipulation() |
○ |
○ |
|
supportsSchemasInIndexDefinitions() |
○ |
○ |
|
supportsSchemasInPrivilegeDefinitions() |
○ |
○ |
|
supportsSchemasInProcedureCalls() |
○ |
○ |
|
supportsSchemasInTableDefinitions() |
○ |
○ |
|
supportsSelectForUpdate() |
○ |
○ |
|
supportsStoredProcedures() |
○ |
○ |
|
supportsSubqueriesInComparisons() |
○ |
○ |
|
supportsSubqueriesInExists() |
○ |
○ |
|
supportsSubqueriesInIns() |
○ |
○ |
|
supportsSubqueriesInQuantifieds() |
○ |
○ |
|
supportsTableCorrelationNames() |
○ |
○ |
|
supportsTransactionIsolationLevel(int level) |
○ |
○ |
|
supportsTransactions() |
○ |
○ |
|
supportsUnion() |
○ |
○ |
|
supportsUnionAll() |
○ |
○ |
|
updatesAreDetected(int type) |
× |
× |
|
usesLocalFilePerTable() |
○ |
○ |
|
usesLocalFiles() |
○ |
○ |
|
PreparedStatement |
addBatch() |
× |
× |
clearParameters() |
○ |
○ |
|
execute() |
○ |
○ |
|
executeQuery() |
○ |
○ |
|
executeUpdate() |
○ |
○ |
|
getMetaData() |
× |
× |
|
setArray(int i, Array x) |
× |
× |
|
setAsciiStream(int parameterIndex, InputStream x, int length) |
× |
× |
|
setBigDecimal(int parameterIndex, BigDecimal x) |
○ |
○ |
|
setBinaryStream(int parameterIndex, InputStream x, int length) |
○ |
○ |
|
setBlob(int i, Blob x) |
× |
× |
|
setBoolean(int parameterIndex, boolean x) |
○ |
× |
|
setByte(int parameterIndex, byte x) |
○ |
× |
|
setBytes(int parameterIndex, byte[] x) |
○ |
× |
|
setCharacterStream(int parameterIndex, Reader reader, int length) |
× |
× |
|
setClob(int i, Clob x) |
× |
× |
|
setDate(int parameterIndex, Date x) |
○ |
○ |
|
setDate(int parameterIndex, Date x, Calendar cal) |
× |
× |
|
setDouble(int parameterIndex, double x) |
○ |
○ |
|
setFloat(int parameterIndex, float x) |
○ |
○ |
|
setInt(int parameterIndex, int x) |
○ |
○ |
|
setLong(int parameterIndex, long x) |
○ |
× |
|
setNull(int parameterIndex, int sqlType) |
○ |
○ |
|
setNull(int paramIndex, int sqlType, String typeName) |
× |
× |
|
setObject(int parameterIndex, Object x) |
× |
× |
|
setObject(int parameterIndex, Object x, int targetSqlType) |
× |
× |
|
setObject(int parameterIndex, Object x, int targetSqlType, int scale) |
× |
× |
|
setRef(int i, Ref x) |
× |
× |
|
setShort(int parameterIndex, short x) |
○ |
○ |
|
setString(int parameterIndex, String x) |
○ |
○ |
|
setTime(int parameterIndex, Time x) |
○ |
○ |
|
setTime(int parameterIndex, Time x, Calendar cal) |
× |
× |
|
setTimestamp(int parameterIndex, Timestamp x) |
○ |
○ |
|
setTimestamp(int parameterIndex, Timestamp x, Calendar cal) |
× |
× |
|
setUnicodeStream(int parameterIndex, InputStream x, int length) |
× |
× |
|
ResultSet |
absolute(int row) |
○ |
× |
afterLast() |
○ |
× |
|
beforeFirst() |
○ |
× |
|
cancelRowUpdates() |
× |
× |
|
clearWarnings() |
○ |
○ |
|
close() |
○ |
○ |
|
deleteRow() |
× |
× |
|
findColumn(String columnName) |
○ |
○ |
|
first() |
○ |
× |
|
getArray(int I) |
× |
× |
|
getArray(String colName) |
× |
× |
|
getAsciiStream(int columnIndex) |
× |
× |
|
getAsciiStream(String columnName) |
× |
× |
|
getBigDecimal(int columnIndex) |
○ |
○ |
|
getBigDecimal(int columnIndex, int scale) |
○ |
○ |
|
getBigDecimal(String columnName) |
○ |
○ |
|
getBigDecimal(String columnName, int scale) |
○ |
○ |
|
getBinaryStream(int columnIndex) |
○ |
○ |
|
getBinaryStream(String columnName) |
○ |
○ |
|
getBlob(int i) |
× |
× |
|
getBlob(String colName) |
× |
× |
|
getBoolean(int columnIndex) |
○ |
× |
|
getBoolean(String columnName) |
○ |
× |
|
getByte(int columnIndex) |
○ |
○ |
|
getByte(String columnName) |
○ |
○ |
|
getBytes(int columnIndex) |
○ |
× |
|
getBytes(String columnName) |
○ |
× |
|
getCharacterStream(int columnIndex) |
× |
× |
|
getCharacterStream(String columnName) |
× |
× |
|
getClob(int I) |
× |
× |
|
getClob(String colName) |
× |
× |
|
getConcurrency() |
○ |
× |
|
getCursorName() |
○ |
○ |
|
getDate(int columnIndex) |
○ |
○ |
|
getDate(int columnIndex, Calendar cal) |
× |
× |
|
getDate(String columnName) |
○ |
○ |
|
getDate(String columnName, Calendar cal) |
× |
× |
|
getDouble(int columnIndex) |
○ |
○ |
|
getDouble(String columnName) |
○ |
○ |
|
getFetchDirection() |
○ |
× |
|
getFetchSize() |
× |
× |
|
getFloat(int columnIndex) |
○ |
○ |
|
getFloat(String columnName) |
○ |
○ |
|
getInt(int columnIndex) |
○ |
○ |
|
getInt(String columnName) |
○ |
○ |
|
getLong(int columnIndex) |
○ |
○ |
|
getLong(String columnName) |
○ |
○ |
|
getMetaData() |
○ |
○ |
|
getObject(int columnIndex) |
× |
× |
|
getObject(int i, Map map) |
× |
× |
|
getObject(String columnName) |
× |
× |
|
getObject(String colName, Map map) |
× |
× |
|
getRef(int I) |
× |
× |
|
getRef(String colName) |
× |
× |
|
getRow() |
○ |
× |
|
getShort(int columnIndex) |
○ |
○ |
|
getShort(String columnName) |
○ |
○ |
|
getStatement() |
○ |
○ |
|
getString(int columnIndex) |
○ |
○ |
|
getString(String columnName) |
○ |
○ |
|
getTime(int columnIndex) |
○ |
○ |
|
getTime(int columnIndex, Calendar cal) |
× |
× |
|
getTime(String columnName) |
○ |
○ |
|
getTime(String columnName, Calendar cal) |
× |
× |
|
getTimestamp(int columnIndex) |
○ |
○ |
|
getTimestamp(int columnIndex, Calendar cal) |
× |
× |
|
getTimestamp(String columnName) |
○ |
○ |
|
getTimestamp(String columnName, Calendar cal) |
× |
× |
|
getType() |
○ |
× |
|
getUnicodeStream(int columnIndex) |
× |
× |
|
getUnicodeStream(String columnName) |
× |
× |
|
getWarnings() |
○ |
○ |
|
insertRow() |
× |
× |
|
isAfterLast() |
○ |
× |
|
isBeforeFirst() |
○ |
× |
|
isFirst() |
○ |
× |
|
isLast() |
○ |
× |
|
last() |
○ |
× |
|
moveToCurrentRow() |
× |
× |
|
moveToInsertRow() |
× |
× |
|
next() |
○ |
○ |
|
previous() |
○ |
× |
|
refreshRow() |
× |
× |
|
relative(int rows) |
○ |
× |
|
rowDeleted() |
× |
× |
|
rowInserted() |
× |
× |
|
rowUpdated() |
× |
× |
|
setFetchDirection(int direction) |
○ |
× |
|
setFetchSize(int rows) |
× |
× |
|
updateAsciiStream(int columnIndex, InputStream x, int length) |
× |
× |
|
updateAsciiStream(String columnName, InputStream x, int length) |
× |
× |
|
updateBigDecimal(int columnIndex, BigDecimal x) |
× |
× |
|
updateBigDecimal(String columnName, BigDecimal x) |
× |
× |
|
updateBinaryStream(int columnIndex, InputStream x, int length) |
× |
× |
|
updateBinaryStream(String columnName, InputStream x, int length) |
× |
× |
|
updateBoolean(int columnIndex, Boolean x) |
× |
× |
|
updateBoolean(String columnName, Boolean x) |
× |
× |
|
updateByte(int columnIndex, byte x) |
× |
× |
|
updateByte(String columnName, byte x) |
× |
× |
|
updateBytes(int columnIndex, byte[] x) |
× |
× |
|
updateBytes(String columnName, byte[] x) |
× |
× |
|
updateCharacterStream(int columnIndex, Reader x, int length) |
× |
× |
|
updateCharacterStream(String columnName, Reader reader, int length) |
× |
× |
|
updateDate(int columnIndex, Date x) |
× |
× |
|
updateDate(String columnName, Date x) |
× |
× |
|
updateDouble(int columnIndex, double x) |
× |
× |
|
updateDouble(String columnName, double x) |
× |
× |
|
updateFloat(int columnIndex, float x) |
× |
× |
|
updateFloat(String columnName, float x) |
× |
× |
|
updateInt(int columnIndex, int x) |
× |
× |
|
updateInt(String columnName, int x) |
× |
× |
|
updateLong(int columnIndex, long x) |
× |
× |
|
updateLong(String columnName, long x) |
× |
× |
|
updateNull(int columnIndex) |
× |
× |
|
updateNull(String columnName) |
× |
× |
|
updateObject(int columnIndex, Object x) |
× |
× |
|
updateObject(int columnIndex, Object x, int scale) |
× |
× |
|
updateObject(String columnName, Object x) |
× |
× |
|
updateObject(String columnName, Object x, int scale) |
× |
× |
|
updateRow() |
× |
× |
|
updateShort(int columnIndex, short x) |
× |
× |
|
updateShort(String columnName, short x) |
× |
× |
|
updateString(int columnIndex, String x) |
× |
× |
|
updateString(String columnName, String x) |
× |
× |
|
updateTime(int columnIndex, Time x) |
× |
× |
|
updateTime(String columnName, Time x) |
× |
× |
|
updateTimestamp(int columnIndex, Timestamp x) |
× |
× |
|
updateTimestamp(String columnName, Timestamp x) |
× |
× |
|
wasNull() |
○ |
○ |
|
ResultSetMetaData |
getCatalogName(int column) |
× |
× |
getColumnClassName(int column) |
× |
× |
|
getColumnCount() |
○ |
○ |
|
getColumnDisplaySize(int column) |
○ |
○ |
|
getColumnLabel(int column) |
○ |
× |
|
getColumnName(int column) |
○ |
○ |
|
getColumnType(int column) |
○ |
○ |
|
getColumnTypeName(int column) |
○ |
○ |
|
getPrecision(int column) |
○ |
○ |
|
getScale(int column) |
○ |
○ |
|
getSchemaName(int column) |
○ |
× |
|
getTableName(int column) |
○ |
× |
|
isAutoIncrement(int column) |
○ |
○ |
|
isCaseSensitive(int column) |
○ |
○ |
|
isCurrency(int column) |
○ |
○ |
|
isDefinitelyWritable(int column) |
○ |
○ |
|
isNullable(int column) |
○ |
○ |
|
isReadOnly(int column) |
○ |
○ |
|
isSearchable(int column) |
○ |
○ |
|
isSigned(int column) |
○ |
○ |
|
isWritable(int column) |
○ |
○ |
|
Statement |
addBatch(String sql) |
× |
× |
cancel() |
× |
× |
|
clearBatch() |
× |
× |
|
clearWarnings() |
○ |
○ |
|
close() |
○ |
○ |
|
execute(String sql) |
○ |
○ |
|
executeBatch() |
× |
× |
|
executeQuery(String sql) |
○ |
○ |
|
executeUpdate(String sql) |
○ |
○ |
|
getConnection() |
○ |
○ |
|
getFetchDirection() |
○ |
× |
|
getFetchSize() |
× |
× |
|
getMaxFieldSize() |
○ |
○ |
|
getMaxRows() |
○ |
○ |
|
getMoreResults() |
○ |
× |
|
getQueryTimeout() |
× |
× |
|
getResultSet() |
○ |
× |
|
getResultSetConcurrency() |
○ |
× |
|
getResultSetType() |
○ |
× |
|
getUpdateCount() |
○ |
× |
|
getWarnings() |
○ |
○ |
|
setCursorName(String name) |
○ |
○ |
|
setEscapeProcessing(boolean enable) |
× |
× |
|
setFetchDirection(int direction) |
○ |
× |
|
setFetchSize(int rows) |
× |
× |
|
setMaxFieldSize(int max) |
○ |
○ |
|
setMaxRows(int max) |
○ |
○ |
|
setQueryTimeout(int seconds) |
× |
× |
目次 索引 |