DB Close

DB Close

Type: db-close  ·  Package: Database Activities v1.0.0

Close the connection to the database and release the resources. It is the partner of DB Connect when you work without body (Option B of session model).

How it works

Close the connection associated with the session. After this, the session can no longer be used. Leaving connections open consumes database server resources, so it is important to close them.

Required parameters

Ninguno.

Optional parameters

Parameter	Editor	Description
session	session	The session returned by DB Connect.

Example

DB Connect   provider = mysql   connectionString = = credential("db").ToPlainText()   → output: db
DB Query   session = = db   sql = "SELECT * FROM productos"   → output: productos
DB Close   session = = db

Do I need DB Close?

Only in Option B (without body). If you use DB Connect with body, the connection closes by itself when body ends. To guarantee closure even if something fails in the middle, combine with a Try / Catch and put DB Close on finally.

Related activities

• DB Connect — open the connection.
• Try / Catch — close on finally to avoid leaving open connections.