A connection attribute is a attribute of a connection.
The connection attribute of type parameters:
The only mandatory parameter variable is the URI.
Base parameters are parameters used for all connections. Each connection type has its own parameters variable.
You can see the attributes of your connection with the connection info command.
You can set connection parameters:
connections:
connectionName:
parameter1: value1
connections:
connectionName:
parameter1: ${MY_OS_ENV}
Base Connection Attribute are connection attributes available to all connections.
| Name | Description |
|---|---|
| URI | The connection URI |
| COMMENT | A connection description |
| USER | The user |
| PASSWORD | The password |
| DATE_DATA_TYPE | Define the text storage format of a Date data type (YYYY-MM-DD) if not supported by the connection . See Time storage |
| TIMESTAMP_DATA_TYPE | Define the text storage format of a Timestamp data type (YYYY-MM-DD HH:MM:SS) if not supported by the connection . See Time storage |
| TIME_DATA_TYPE | Define the text storage format of a Time data type (HH:MM:SS) if not supported by the connection . See Time storage |
| BOOLEAN_DATA_TYPE | Define the text storage format of a Boolean. See boolean if not supported by the connection |
| VARCHAR_DEFAULT_PRECISION | Define the default precision of a Varchar |
| NVARCHAR_DEFAULT_PRECISION | Define the default precision of a NVarchar |
| CHAR_DEFAULT_PRECISION | Define the default precision of a char |
| NCHAR_DEFAULT_PRECISION | Define the default precision of a nchar |
| MAX_NAME_IN_PATH | The maximum name in a path (for instance, Sqlite supports only one) |
| MAX_CONCURRENT_THREAD | The maximum number of concurrent thread for the connection (for instance, Sqlite supports only one) |
| NATIVES | The native driver connection properties as map of key value (jdbc driver properties, …) |
Derived: You can't change it
| Name | Description |
|---|---|
| ORIGIN | The origin of the connection data (ie built-in or user) |