<?xml version="1.0" encoding="iso-8859-1"?>
<?xml-stylesheet href="../make-menu.xsl" type="text/xsl"?><html>
<head>
<this-is section="sql-extension" page="close" subpage=""/>
<!--
Generated at 2011-12-09T20:47:22.916Z--><title>Saxonica: XSLT and XQuery Processing: sql:close</title>
<meta name="coverage" content="Worldwide"/>
<meta name="copyright" content="Copyright Saxonica Ltd"/>
<meta name="title" content="Saxonica: XSLT and XQuery Processing: sql:close"/>
<meta name="robots" content="noindex,nofollow"/>
<link rel="stylesheet" href="../saxondocs.css" type="text/css"/>
</head>
<body class="main">
<h1>sql:close</h1>
<p><code>sql:close</code> closes the database connection.
There is a mandatory <code>connection</code> attribute, used as in the <code>sql:query</code>
instruction described above.</p>
<p>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 <code>sql:execute</code>
instruction: see <a class="bodylink" href="../sql-extension/execute.xml">sql:execute</a>.</p>
<table width="100%">
<tr>
<td>
<p align="right"><a class="nav" href="execute.xml">Next</a></p>
</td>
</tr>
</table>
</body>
</html>
