How to close a database connection created by a tMysqlConnection component
- tMysqlCommit/tMysqlRollback components
- a tMysqlClose component
You can use the option Close Connection in the tMysqlCommit/tMysqlRollback components to close the connection.
You can use the tMysqlClose to close a MySQL connection if there is no tMysqlCommit/tMysqlRollback in the Job or if the Close Connection check box is not selected in the tMyslqCommit/tMysqlRollback.
For an example on using the tMysqlClose component, see Scenario: Reading data from databases through context-based dynamic connections.