Question

At the end of the execution of workflow1, which retrieves some items from a database, is the database connection closed automatically

Answer 1

Answer: Yes surely.

Answer 2

The database connections might be closed after a period of time, may be when the garbage collector checks for unused objects. But it is always recommended to close the database connection whenever the task is over and reopen whenever the next query is sent. These avoid unwanted objects to be on the memory which diminishes the system speed. This is normally handled in the try catch finally block in the front-end application where the connection is being opened in the try block, catch if any error and at the end close the database connection in the finally block.