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:

  1. Open Site Preferences > Database Configurations.
  2. Select the Database Connection 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.