Configure Connection Initialization Settings
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.
|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.