Provide the possibility to specify a list of statements to execute upon connect, like in the commons-dbcp parameter "connectionInitSqls" resource configuration.
On the bookmark "Options" tag a textarea could be added to contain initialization statements, one per line and separated by semi-columns.
Connection initialization statements could be used, for example, to alter session configuration automatically.
For a Oracle connection one could write, for example:
ALTER SESSION SET NLS_COMP=LINGUISTIC;
ALTER SESSION SET NLS_SORT=BINARY_CI;
and obtain a case insensitive search and ordering that can't be achieved using dialogs without having to issue the commands on every connection opening.
Log in to post a comment.