Sharing a database connection
About this task
If you have various Jobs using the same database connection, you can factorize the connection by using the Use or register a shared DB Connection option so that the connection can be shared between parent and child Jobs.
This option has been added to all database connection components in order to reduce the number of connections to open and close.
Information noteWarning: The Use or register a
shared DB Connection option of all database connection components is
incompatible with the Use dynamic job and
Use an independent process to run subJob
options of the tRunJob component. Using a
shared database connection together with a tRunJob component with either of these two options enabled will
cause your Job to fail.
The procedure below assumes that you have two related Jobs (a parent Job and a child Job) that both need to connect to your remote MySQL database.
For a complete use case, see MySQL.
To use a shared database connection in the two Jobs, to the following:
Procedure
-
Connect each tMysqlConnection to the relevant component in your Jobs using a
Trigger > On Subjob Ok link.
-
Select the Use or register a shared
DB Connection check box, and give a name to the connection in
the Shared DB Connection Name
field.
You are now able to re-use the connection in your child Job.