8.5.12 getBigDecimal(String columnName)

(1) Function

This method acquires in a java.math.BigDecimal object 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 BigDecimal getBigDecimal(String columnName) throws SQLException

To Page Top

(3) Arguments

String columnName

Specifies a column name.

To Page Top

(4) Return value

This method returns the column value that corresponds to the specified column name in the current row.

For details about the relationship between the retrieval result and the return value, see Table 8‒19: Relationship between the retrieval result and the return value (getBigDecimal method).

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 name was specified.

• The data type cannot be acquired by this method.

• The column value cannot be acquired as BigDecimal.

• An error occurred in the JDBC driver.

To Page Top