Changes

Jump to navigation Jump to search
526 bytes added ,  15:51, 8 September 2011
m
no edit summary
|-
| valign='top' width='90' | '''Signatures'''
|<code><b>sql:connect</b>($url as xs:string) as xs:int</code><br/ ><code><b>sql:connect</b>($url as xs:string, $auto-commit user as xs:booleanstring, $password as xs:string) as xs:int</code><br/ ><code><b>sql:connect</b>($url as xs:string, $auto-commit user as xs:booleanstring, $user password as xs:string, $password options as xs:stringitem()) as xs:int</code><br/ >
|-
| valign='top' | '''Summary'''
|This function establishes a connection to a relational database. As a result a connection handle is returned. The parameter <code>$url</code> is the URL of the database and shall be of the form: <code>jdbc:<driver name>:[//<server>[/<database>]</code>. If the parameters <code>$user</code> and <code>$password</code> are specified, they are used as credentials for connecting to the database. The parameter <code>$auto-commitoptions</code> is can be used to indicate if the set connection options, e.g. auto-commit mode shall . It can be activated or not. Its default value is true. If the parameters specified as:* <code>$userelement(sql:options):</code> and <code>$password&lt;sql:options/&gt;</code> must be used as root element, and the options are specifiedas child nodes, they are used with the element name representing the key and the text node representing the value:<br //><code>&lt;sql:options&gt;<br/>&nbsp;&nbsp;&lt;sql:autocommit&gt;true&lt;/sql:autocommit&gt;<br/>&nbsp;&nbsp;...<br/>&lt;/sql:options&gt;</code>* [[Map_Functions|map structure]]: all options can be directly represented as credentials for connecting to the databasekey/value pairs:<br /><code>map { "autocommit" := "true", ...</code>}<br/ >
|-
| valign='top' | '''Errors'''
administrator, Bureaucrats, editor, reviewer
41

edits

Navigation menu