Table of Contents

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.