Purpose

Specifies whether the driver uses native catalog functions to retrieve information returned by DatabaseMetaData functions.

Valid Values

mixed | native | query

Behavior

If set to mixed, the driver uses a combination of native catalog functions and driver-discovered information to retrieve catalog information. Select this option for the optimal balance of performance and accuracy.
Note: In this setting, the driver uses the best techniques for retrieving information. These techniques vary depending on the server used, which may result in variations in performance.

If set to native, the driver uses native catalog functions to retrieve information returned by DatabaseMetaData functions. This setting provides the best performance, but at the expense of less-accurate catalog information.

If set to query, the driver uses driver-discovered information to retrieve catalog information. This option provides highly accurate catalog information, but at the expense of slower performance.

Data Source Method

setCatalogMode

Default

mixed

Data Type

String

See Also