Configure Connection Initialization Settings

Table of contents

• Overview
• Accessing Connection Initialization Settings
• Settings

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:

1. Create a new connection.

2. In the connection creation wizard, navigate to Connection details -> Connection Initialization Settings to specify your preferences.

For an existing connection:

1. Go to the Database Navigator, find the connection you want to configure.

2. Right-click on it and select Edit Connection.

3. 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 connection (with no activity) will be closed. Unchecking this option allows the connection to remain active indefinitely. If the field is set to zero, the system will apply the values configured in the Connection Types settings. If a value other than zero is specified, that value will override the default settings from the Connection Types.
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.