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 |
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 of quoted identifier is adding a quotation marks at the end and the beginning of the words to:
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.