execute an init sql script when establishing a connection

The purpose is to be able to init some sql parameters when establishing  a connection to the database.

DbVisualizer to allow this, let you enter some sql commands that will be executed when the connection is made. They call this a "connection hook". I think this is a simple and powerful way to allow this type of configuration.

This is an exemple of use :

ALTER SESSION SET CURRENT_SCHEMA = TOTO;
ALTER SESSION SET TIME_ZONE='Australia/Sydney';

 

0
1 comment

Hi,

We have already got the similar issue https://youtrack.jetbrains.com/issue/DBE-3600

Thank you.

0

Please sign in to leave a comment.