DB Release Connection

This Database tool releases a connection to the database server, freeing up the server for another connection. This step is usually followed by a DB Close step.

You may not want to follow this step with a DB Close in cases where you have opened multiple connections to the same data source. This is useful in cases where you want to perform "nested" queries against the database.

For instance, suppose you execute a query step, then fetch a record, then you need to perform an additional query (based on some data in that fetched record) in order to process the record. If you perform that 2nd query on the same connection, your first result set will be lost (the server keeps 1 current result set for each connection). So, you open another connection (or use another one that was opened before) and perform the 2nd query on that. Then you fetch the result from that 2nd query and finish whatever processing you needed to do for that original record. Now you can go back and fetch the 2nd record from the 1st query. To process the 2nd record you'll probably do the same thing you did for the first -- do another query & fetch, then finish processing.

After you finished processing all the records from your original query, you're left with 2 open connections. If you only need one for the rest of your handler, then you can release the 2nd one.

Settings Page

Database Connection Variable

Specifies which database variable for the connection you want to release.

Exit Paths

Success

If this step executes successfully, this step takes the Success exit path.

Failure

If this step does not execute successfully, this step takes the Failure exit path. This can occur when the DB connection variable is not valid.