Connection types reference

Connection types are named labels with a color and transaction defaults. Each connection's type field references one of these labels by its ID.

The data-sources.json ships with three built-in types: dev, test, and prod. You can add custom types or adjust the defaults by editing the connection-types block.

Info

For information on managing connection types in the UI, see Connection types.

Fields¶

Field	Type	Default	Description
`name`	string	-	Display name, e.g. `"Production"`
`color`	string	-	Set the color for the connection type in the Database Navigator.
`auto-commit`	boolean	`true`	Default auto-commit setting for connections of this type
`confirm-execute`	boolean	`false`	Show a confirmation dialog before running transactional queries (INSERT, UPDATE, DELETE)
`confirm-data-change`	boolean	`false`	Ask for confirmation before saving data changes to the database
`smart-commit`	boolean	`false`	Start transactions automatically for data-changing statements
`smart-commit-recover`	boolean	`true`	Re-enable auto-commit after a transaction ends. Only applies if `smart-commit` is `true`
`auto-close-transactions`	boolean	`true`	Automatically close and roll back idle transactions after `close-transactions-period` seconds
`close-transactions-period`	integer	`1800`	Seconds before an idle transaction is closed. Only applies if `auto-close-transactions` is `true`
`auto-close-connections`	boolean	`true`	Disconnect the connection after `close-connections-period` seconds of inactivity
`close-connections-period`	integer	`14400`	Seconds before an idle connection is closed. Only applies if `auto-close-connections` is `true`

Example

{
  "connection-types": {
    "dev": {
      "name": "Development",
      "color": "255,255,255",
      "auto-commit": true,
      "confirm-execute": false,
      "confirm-data-change": false,
      "auto-close-transactions": true,
      "close-transactions-period": 1800,
      "auto-close-connections": true,
      "close-connections-period": 14400
    }
  }
}