Bureaucrats, editor, reviewer, Administrators
13,554
edits
Changes
Jump to navigation
Jump to search
no edit summary
The SQL Module contains [[Querying#Functions|XQuery functions]] to access relational databases from XQuery using SQL. With this module, you can execute query, update and prepared statements, and the result sets are returned as sequences of XML elements representing tuples. Each element has attributes representing the columns returned by the SQL statement. All functions dealing with access to relational databases use the <code>sql</code> prefix, which is linked to the <code><nowiki>http://www.basex.org/sql</nowiki></code> namespace. The module will be officially supported with the upcoming <font color="red">Version 6.8</font> of BaseX.
==sql:init==
{|
|-
| valign='top' width='90' | '''Signatures'''
|<code><b>sql:init</b>($class as xs:string) as empty-sequence()</code>
|-
| valign='top' | '''Summary'''
|This function initializes a JDBC driver specified via <code>$class</code>. This step might be superfluous if the SQL database is not embedded.<br/ >
|-
| valign='top' | '''Errors'''
|<b>[[XQuery Errors#SQL Functions Errors (XSQL)|XSQL0007]]</b> is raised if the specified driver class is not found.
|}
==sql:connect==
