Configure Connection Initialization Settings
Table of contents
Overview
During the initialization of a new database session, the Connection Initialization Settings provide a customizable set of parameters. These settings ensure that every time you connect to the database, certain predefined behaviors are automatically initialized. This feature allows you to set the:
- Transaction management options such as auto-commit status and transaction isolation levels.
- Defaults for the initial database and schema selection upon connection establishment.
- Network handling features like keep-alive settings and idle connection timeout.
- Bootstrap queries to execute predetermined SQL commands at the start of every session.
Accessing Connection Initialization Settings
To configure the Initialization Settings for your database connections, follow these steps:
For a new connection:
In the connection creation wizard, navigate to Connection details -> Connection Initialization Settings to specify your preferences.
For an existing connection:
Go to the Database Navigator, find the connection you want to configure.
Right-click on it and select Edit Connection.
In the edit menu, navigate to the Initialization tab where you can adjust the settings.
Settings
Setting | Description |
---|---|
Auto-commit | Determines if each SQL statement is committed automatically upon execution. |
Isolation level | Sets the transaction isolation level which defines the degree of visibility of transactions to each other. |
Read uncommitted: Allows a transaction to read data that has not yet been committed by other transactions. | |
Read committed: Ensures a transaction only reads data that has been committed at the time the transaction began. | |
Repeatable read: Guarantees if a row is read twice in the same transaction, the result will be the same. | |
Serializable: Ensures transactions occur in a completely isolated fashion, equivalent to serial transaction execution. | |
Default database | Specifies the default database to be selected once the connection is established. |
Default schema | Indicates the default schema to be used within the selected database. |
Keep-Alive | Interval (seconds) for sending a signal to maintain the connection open during user inactivity. |
Close idle connections after | The duration in seconds after which idle connections (those with no activity) will be closed. Setting this to zero disables auto-close. |
Bootstrap queries | Allows configuration of specific SQL queries to run at the start of the session. |
Note: The transaction isolation levels and available schemas can only be viewed by clicking on Test Connection after the connection has been established.