11.2.6 getParameterTypeName(int param)

(1) Function

This method acquires a specified parameter's data type.

To Page Top

(2) Format

public synchronized String getParameterTypeName(int param) throws SQLException

To Page Top

(3) Arguments

int param

Specifies a parameter number (beginning with 1).

To Page Top

(4) Return value

The method returns a String object. The following table shows the return values of the getParameterTypeName method.

Table 11‒4: Return values of the getParameterTypeName method

Parameter's data type (HADB data type)	Return value (character string returned)
INTEGER	"INTEGER"
SMALLINT	"SMALLINT"
DECIMAL	"DECIMAL"
DOUBLE PRECISION	"DOUBLE PRECISION"
CHAR	"CHAR"
VARCHAR	"VARCHAR"
DATE	"DATE"
TIME	"TIME"
TIMESTAMP	"TIMESTAMP"
BINARY	"BINARY"
VARBINARY	"VARBINARY"
ROW	"ROW"

To Page Top

(5) Exceptions

If the specified param value is 0 or less, or is greater than the number of parameters, the JDBC driver throws an SQLException.

To Page Top