SQL Connection Attributes
About
All database system supports the standard connection attributes and the following attributes:
| Name | Description | Default value |
|---|---|---|
| BUILDER_CACHE_ENABLED | A builder cache | true |
| NAME_QUOTING_ENABLED | Enable quoting of SQL name identifier | true |
| DRIVER | The Jdbc Driver Class |
List
BUILDER_CACHE_ENABLED
BUILDER_CACHE_ENABLED defines if the builder cache is used or not.
The builder cache is used to cache the building of relation object such as table, view.
Why? Because a relation object (table, views, …) may have dependencies, building them each time as a significative impact as it's a recursive process.
NAME_QUOTING_ENABLED
Name quoting of quoted identifier is adding a quotation marks at the end and the beginning of the words to:
- make it case sensitive
- allow:
- the use of reserved keywords (ie char is not allowed but "char" is)
- characters such as space, number at first position
Relational databases have different behavior around it. By default, we enable it so that SQL Developer does not have to type in uppercase.
With NAME_QUOTING_ENABLED, you can disable this feature.
Remark that we may disable this feature by database.
For instance, we do for Oracle. Why ? Because it requires you to put always the quotation mark even in a SQL SELECT which is crazy. You can't write select cat_id, you need to write select "cat_id"
If you name a schema object using a quoted identifier, then you must use the double quotation marks whenever you refer to that object.