Additional Functions

From InterBase
Jump to: navigation, search

Go Up to InterClient Scrollability


Additional functions that implement the JDBC 2.x API functionality are listed below.

Function Functionality

int Statement.getResultSetType()

Returns the type if resultSet is open, otherwise throws an exception

int Statement. getResultSetConcurreny()

Returns the concurrency if resultSet is open.

int Statement. getFetchDirection()

Returns the fetch direction if resultSet is open, the return value is always FETCH_FORWARD for InterBase.

int ResultSet. getFetchDirection()

Returns FETCH_FORWARD in all cases

int ResultSet. getFetchSize()

Returns the fetch size for the result set of the statement.

int ResultSet. setFetchSize()

Allows you to set the fetch size of the resultset and the statement.

int ResultSet. setFetchDirection()

Throws an exception; it can only work with TYPE_SCROLL_SENSITIVE and TYPE_SCROLL_INSENSITIVE. Neither of these are supported by InterBase, since InterBase does not support scrollable cursors. The only ResultSet type allowed by InterClient/InterBase is TYPE_FORWARD_ONLY.