Purpose

Specifies whether the driver maps all identifier names to uppercase. By default, the driver maps all identifier names to uppercase.

Valid Values

true | false

Behavior

If set to true, the driver maps identifiers to uppercase.

If set to false, the driver maps identifiers to the mixed case name of the object being mapped. If mixed case identifiers are used, SQL statements must enclose those identifiers in double quotes and the case of the identifier must exactly match the case of the identifier name. In addition, object names in results returned from catalog functions are returned in the case that they are stored in the database.

Example

If UppercaseIdentifiers=false, to query the Account table you specify:

SELECT "id", "name" FROM "Account"

Notes

  • Do not change the value of Uppercase Identifiers unless the data source you are connecting to has objects with names that differ only by case.

  • The setting for this property is written to the configuration file when generating the schema map. If you attempt a subsequent connection using the configuration file and specify a different value for this property, the driver will return an error.

Data Source Methods

public Boolean getUpperCaseIdentifiers()

public void setUpperCaseIdentifiers(Boolean)

Default Value

true

Data Type

Boolean