8.6.17 getBoolean(int columnIndex)

(1) Function

This method acquires as boolean in the Java programming language the value in a specified column in the current row of the ResultSet object. The column whose value is to be acquired is specified in the argument.

To Page Top

(2) Format

public synchronized boolean getBoolean(int columnIndex) throws SQLException

To Page Top

(3) Arguments

int columnIndex

Specifies a column number.

To Page Top

(4) Return value

This method returns true or false. The following table shows the relationship between the retrieval result and the return value.

Table 8‒27: Relationship between the retrieval result and the return value (getBoolean method)

HADB data type	Retrieval result	Return value
CHAR VARCHAR STRING	Null value	false
	[space]1[space]	true
	Other than the above	false
SMALLINT	Null value	false
	0	false
	Other than the above	true
INTEGER BIGINT	Null value	false
	0	false
	Other than the above	true
DECIMAL NUMERIC	Null value	false
	0[.00...0]	false
	Other than the above	true
DOUBLE PRECISION FLOAT REAL	Null value	false
	0.0 or -0.0	false
	Other than the above	true
BOOLEAN	Null value	false
	Non-null value	retrieval-result
Other	Not applicable	SQLException is thrown.

To Page Top

(5) Exceptions

The JDBC driver throws an SQLException in the following cases:

• This ResultSet object is closed.

  This includes the case where the ResultSet object was closed because the Statement object that created this ResultSet object was closed.

• The Connection used to create the Statement object that created this ResultSet object has been closed.

• The ResultSet object has become invalid due to transaction settlement.

• A nonexistent column number was specified.

• The data type cannot be acquired by this method.

• An error occurred in the JDBC driver.

To Page Top