Purpose

Determines whether the driver returns table name information in the ResultSet metadata for Select statements.

Valid values

0 | 1

Behavior

If set to 0 and the ResultSetMetaData.getTableName() method is called, the driver does not perform additional processing to determine the correct table name for each column in the result set. The getTableName() method may return an empty string for each column in the result set.

If set to 1 and the ResultSetMetaData.getTableName() method is called, the driver performs additional processing to determine the correct table name for each column in the result set. The driver returns schema name and catalog name information when the ResultSetMetaData.getSchemaName() and ResultSetMetaData.getCatalogName() methods are called if the driver can determine that information.

Data source method

public Integer getResultSetMetaDataOptions()

public void setResultSetMetaDataOptions(Integer)

Default

0

Data type

Int

See also

Performance considerations