Symfoware Server アプリケーション開発ガイド(JDBCドライバ編) - FUJITSU -
目次 索引 前ページ

付録F サポートAPI一覧

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)

×

×


目次 索引 前ページ

All Rights Reserved, Copyright (C) 富士通株式会社 2007