8.3.16 getFetchSize()

(1) Function

This method acquires the default fetch size (number of retrieval result rows to be transferred from the HADB server to the HADB client in the batch mode) for a ResultSet object that is created from the Statement object.

To Page Top

(2) Format

public synchronized int getFetchSize() throws SQLException

To Page Top

(3) Arguments

None.

To Page Top

(4) Return value

This method returns the default fetch size (number of retrieval result rows to be transferred from the HADB server to the HADB client in the batch mode) for a ResultSet object that is created from this Statement object.

If 0 is specified in the setFetchSize method, the value of adb_clt_fetch_size in the system properties, user properties, or URL connection properties is applied as the fetch size, but the return value is 0. The following table shows the relationship between the fetch size and the return value.

Table 8‒9: Relationship between the fetch size and the return value

Setting by the setFetchSize method (m)	Return value
0	0
1 ≤ m ≤ 65,535	m

To Page Top

(5) Exceptions

The JDBC driver throws an SQLException in the following cases:

• The Statement object is closed.

• The Connection object that created the Statement object is closed.

To Page Top