Determines whether the Name attribute of NamedID fields is exposed in the relational map.
Valid Values
1 | 2
The value for this option is specified as a key=value pair in the Config Options field. See "Config Options" for details.
Behavior
If set to 1, the driver exposes the Name attribute of the NamedID fields in the relational model. Specify this setting if your application needs to access the Name strings associated with NamedID columns.
If set to 2, the driver does not expose the Name attribute of the NamedID fields in the relational model. This setting can be used to avoid "poor performing query" errors received when executing SELECT * queries against tables containing a large number of rows.
Default
1
Notes
If you are receiving "poor performing query" errors, you can work around this issue by setting NamedIDBehavior=2. This reduces the size of the result set, allowing the Oracle Service Cloud service to successfully return the query. For this change to have effect, you will need recreate the local mapping files by setting CreateDB=1; then, connecting to your Oracle Service Cloud instance. After creating your new local mapping files, you should reconfigure CreateDB to your preferred setting. We recommend a setting of CreateDB=2. For more information, see "Poor Performing Query errors."
GUI Tab
The value for config options are specified in the Config Options field on the Advanced tab.
If you are receiving "poor performing query" errors, you can work around this issue by setting NamedIDBehavior=2. This reduces the size of the result set, allowing the Oracle Service Cloud service to successfully return the query. For this change to have effect, you will need recreate the local mapping files by setting CreateDB=1; then, connecting to your Oracle Service Cloud instance. After creating your new local mapping files, you should reconfigure CreateDB to your preferred setting. We recommend a setting of CreateDB=2. For more information, see "Poor Performing Query errors."