Example: Connect Success
In the Connect Success SQL panel, you can specify SQL statements to run upon a successful connection. Cloverleaf Global Variable substitution is supported for the SQL statements. If the SQL fails to successfully run, then the thread enters an error state. Errors are logged and added to the protocol error field in thread statistics.
The default value is empty.
The Database Protocol test tool is supported.
For example, to assign role permissions to a database connection:
- Open .
- Select the and specify the role permissions in the Connect Success SQL panel.
When the interface is deployed and started, the SQL statements are immediately run when the database connection is made.