sql:close

sql:close closes the database connection. There is a mandatory connection attribute, used as in the sql:query instruction described above.

Note that the JDBC documentation advises calling "commit" or "rollback" before closing the connection; the effects of not doing so are said to be implementation-defined. It is possible to issue a commit or rollback request using the sql:execute instruction: see sql:execute.