How do I close a database connection created by a ...
How do I close a database connection created by a tMysqlConnection?
The tMysqlConnection is used to create a MySQL connection that will be used by other MySQL components, such as tMysqlnput or tMysqlOutput. The tMysqlConnection does not close the connection and should be used with a tMysqlCommit/tMysqlRollback or a tMysqlClose component in a Job. The option Close Connection in the tMysqlCommit/tMysqlRollback components can be used to close the connection.
Here is a simple Job design using these components:
The tMysqlConnection component creates a connection, the tMysqlCommit commits the changes if the subjob works fine and closes the connection, while the tMysqlRollback rolls back the changes if the subjob fails and closes the connection.
The tMysqlClose can also be used 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.