Preferred getXXX() methods for Derby-style table functions

While scanning a Derby-style table function, Derby calls a preferred getXXX() method for each column, based on the column's data type.

The following table lists the preferred getXXX() method for each Derby data type.

Table 1. getXXX() methods called for declared SQL types
Column Type Declared by CREATE FUNCTION getXXX() Method Called by Derby
BIGINT getLong()
BLOB getBlob()
CHAR getString()
CHAR FOR BIT DATA getBytes()
CLOB getClob()
DATE getDate()
DECIMAL getBigDecimal()
DOUBLE getDouble()
DOUBLE PRECISION getDouble()
FLOAT getDouble()
INTEGER getInt()
LONG VARCHAR getString()
LONG VARCHAR FOR BIT DATA getBytes()
NUMERIC getBigDecimal()
REAL getFloat()
SMALLINT getShort()
TIME getTime()
TIMESTAMP getTimestamp()
VARCHAR getString()
VARCHAR FOR BIT DATA getBytes()
XML Not supported