Symfoware Server アプリケーション開発ガイド(JDBCドライバ編)

付録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)	×	×