8.6.51 getString(int columnIndex) : Hitachi Advanced Database Application Development Guide

(1) Function

This method acquires as String 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 String getString(int columnIndex) throws SQLException

To Page Top

(3) Arguments

int columnIndex: Specifies a column number.

To Page Top

(4) Return value

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

Table 8‒40: Relationship between the retrieval result and the return value (getString method)
HADB data type	Retrieval result	Return value
CHAR VARCHAR STRING	Null value	null
CHAR VARCHAR STRING	Other than the above	`retrieval-result`
SMALLINT	Null value	null
SMALLINT	Other than the above	String object containing the retrieval result in character string representation
INTEGER BIGINT	Null value	null
INTEGER BIGINT	Other than the above	String object containing the retrieval result in character string representation
DECIMAL NUMERIC	Null value	null
DECIMAL NUMERIC	Other than the above	String object containing the retrieval result in character string representation
DOUBLE PRECISION FLOAT REAL	Null value	null
DOUBLE PRECISION FLOAT REAL	Other than the above	String object containing the retrieval result in character string representation
DATE	Null value	null
DATE	Other than the above	String object of a character string in `YYYY`-`MM`-`DD` format
TIME	Null value	null
TIME	Other than the above	String object of a character string in `hh`:`mm`:`ss`[.`f`...] format
TIMESTAMP WITHOUT TIME ZONE	Null value	null
TIMESTAMP WITHOUT TIME ZONE	Other than the above	String object of a character string in `YYYY`-`MM`-`DD`Δ`hh`:`mm`:`ss`[.`f`...] format (Δ indicates a space)
TIMESTAMP WITH TIME ZONE	Null value	null
TIMESTAMP WITH TIME ZONE	Other than the above	String object of a character string in `YYYY`-`MM`-`DD`Δ`hh`:`mm`:`ss`[.`f`...]+00:00 format (Δ indicates a space)
BINARY VARBINARY	Null value	null
BINARY VARBINARY	Other than the above	`retrieval-result`
UUID	Null value	null
UUID	Other than the above	String object of a character string in `AAAAAAAA`-`BBBB`-`CCCC`-`DDDD`-`EEEEEEEEEEEE` format
BOOLEAN	Null value	null
	true	String object of the character string "true"
	false	String object of the character string "false"

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.
Encoding failed.
The data type cannot be acquired by this method.
An error occurred in the JDBC driver.

To Page Top