Purpose

Specifies whether the driver fetches metadata for only tables in the database to which you are connected when a database name is not specified in metadata calls. When enabled, this property can provide better performance for metadata calls by reducing the number of tables queried.

Valid Values

true | false

Behavior

If set to true, the driver fetches metadata for only tables in the database to which you are connected.

If set to false, the driver fetches metadata for all tables in all databases.

Notes

  • When the database name is specified in the metadata calls, the driver ignores the value specified for this connection property and returns metadata only for the database specified in the metadata calls.

Data Source Methods

public Boolean getUseSessionDatabaseForMetadata()

public void setUseSessionDatabaseForMetadata(Boolean)

Default Value

false

Data Type

Boolean