About
The connection pool of the physical layer gives the possibility in the Connection Script tab to execute a command script:
- on connect
- before query
- after query
- on disconnect
Articles Related
Examples
Execute on (connect|disconnect)
insert into login_table(:user,sysdate)
Execute (before|after) query
You can call an autonomous function/store procedure.
With variable
with a server variable
Setting a database session variable.
SET SESSION 'APPLICATIONUSER' = 'VALUEOF(NQ_SESSION.USER)'
