affected-rows
($dataset-id as xs:anyURI) as xs:integer external
: Return the number of affected rows of a particular DataSet. |
clear-params
($prepared-statement as xs:anyURI) as empty-sequence() external
: Clears the current parameter values immediately. |
close-dataset
($dataset-id as xs:anyURI) as empty-sequence() external
: Closes and free resources from a particular DataSet. |
close-prepared
($prepared-statement as xs:anyURI) as empty-sequence() external
: Closes and frees from memory any prepared SQL statement created with jdbc:prepare-statement : : @param $prepared-statement The identifier to a prepared statement. |
commit
($connection-id as xs:anyURI) as empty-sequence() external
: Commit current transaction from an active connection. |
connect
($connection-config as object()) as xs:anyURI external
: Opens a connection to a database. |
connect
($connection-config as object(), $options as object()?) as xs:anyURI external
: Opens a connection to a database with specified options. |
connection-options
($connection-id as xs:anyURI) as object() external
: Returns a set with options for a specified connection. |
execute-prepared
($prepared-statement as xs:anyURI) as xs:anyURI external
: Executes SQL statements prepared with 5. |
execute-query-prepared
($prepared-statement as xs:anyURI) as object()* external
: Executes a non-updating SQL statement prepared with 5. |
execute-query
($connection-id as xs:anyURI, $sql as xs:string) as object()* external
: Executes non-updating SQL statements. |
execute-update-prepared
($prepared-statement as xs:anyURI) as xs:integer external
: Executes an updating SQL statement prepared with 5. |
execute-update
($connection-id as xs:anyURI, $sql as xs:string) as xs:integer external
: Executes updating SQL statements. |
execute
($connection-id as xs:anyURI, $sql as xs:string) as xs:anyURI external
: Executes any kind of SQL statement. |
is-connected
($connection-id as xs:anyURI) as xs:boolean external
: Verify if a connection is still active. |
metadata
($dataset-id as xs:anyURI) as object() external
: Return the metadata of the result of a particular DataSet. |
parameter-metadata
($prepared-statement as xs:anyURI) as object() external
: Retrieves the number, types and properties of the prepared statement parameters. |
prepare-statement
($connection-id as xs:anyURI, $sql as xs:string) as xs:anyURI external
: Creates a prepared statement for multiple executions with diferent values. |
result-set
($dataset-id as xs:anyURI) as object()* external
: This function returns a sequence of objects representing the rows of data from a non-updating query. |
rollback
($connection-id as xs:anyURI) as empty-sequence() external
: Rollback the current transaction of a connection. |
set-boolean
($prepared-statement as xs:anyURI, $parameter-index as xs:integer, $value as xs:boolean) as empty-sequence() external
: Set the value of the designated parameter with the given value, this function will assign only boolean values. |
set-null
($prepared-statement as xs:anyURI, $parameter-index as xs:integer) as empty-sequence() external
: Set the value of the designated parameter with the given value, this function will assign only null values if possible. |
set-numeric
($prepared-statement as xs:anyURI, $parameter-index as xs:decimal, $value as xs:anyAtomicType) as empty-sequence() external
: Set the value of the designated parameter with the given value, this function will assign only numeric values. |
set-string
($prepared-statement as xs:anyURI, $parameter-index as xs:integer, $value as xs:string) as empty-sequence() external
: Set the value of the designated parameter with the given value, this function will assign only string values. |
set-value
($prepared-statement as xs:anyURI, $parameter-index as xs:decimal, $value as xs:anyAtomicType) as empty-sequence() external
: Set the value of the designated parameter with the given value, : this function will assign any value you send : and it will try to cast to the correct type. |
tables
($connection-id as xs:anyURI) as object()*
: : Return the list of tables from a connection : : @param $connection-id The identifier to a connection. |
tables
($connection-id as xs:anyURI, $catalog as xs:string?, $schema as xs:string?, $table as xs:string?) as object()* external
: Return the list of tables from a connection : : @param $connection-id The identifier to a connection. |
declare function jdbc:affected-rows($dataset-id as xs:anyURI) as xs:integer external
declare %an:sequential function jdbc:clear-params($prepared-statement as xs:anyURI) as empty-sequence() external
declare %an:sequential function jdbc:close-dataset($dataset-id as xs:anyURI) as empty-sequence() external
declare %an:sequential function jdbc:close-prepared($prepared-statement as xs:anyURI) as empty-sequence() external
declare %an:sequential function jdbc:commit($connection-id as xs:anyURI) as empty-sequence() external
declare %an:sequential function jdbc:connect($connection-config as object()) as xs:anyURI external
declare %an:sequential function jdbc:connect($connection-config as object(), $options as object()?) as xs:anyURI external
declare function jdbc:connection-options($connection-id as xs:anyURI) as object() external
declare %an:sequential function jdbc:execute-prepared($prepared-statement as xs:anyURI) as xs:anyURI external
declare function jdbc:execute-query-prepared($prepared-statement as xs:anyURI) as object()* external
declare function jdbc:execute-query($connection-id as xs:anyURI, $sql as xs:string) as object()* external
declare function jdbc:execute-update-prepared($prepared-statement as xs:anyURI) as xs:integer external
declare function jdbc:execute-update($connection-id as xs:anyURI, $sql as xs:string) as xs:integer external
declare %an:sequential function jdbc:execute($connection-id as xs:anyURI, $sql as xs:string) as xs:anyURI external
declare function jdbc:is-connected($connection-id as xs:anyURI) as xs:boolean external
declare function jdbc:metadata($dataset-id as xs:anyURI) as object() external
declare function jdbc:parameter-metadata($prepared-statement as xs:anyURI) as object() external
declare %an:sequential function jdbc:prepare-statement($connection-id as xs:anyURI, $sql as xs:string) as xs:anyURI external
declare function jdbc:result-set($dataset-id as xs:anyURI) as object()* external
declare %an:sequential function jdbc:rollback($connection-id as xs:anyURI) as empty-sequence() external
declare %an:sequential function jdbc:set-boolean($prepared-statement as xs:anyURI, $parameter-index as xs:integer, $value as xs:boolean) as empty-sequence() external
declare %an:sequential function jdbc:set-null($prepared-statement as xs:anyURI, $parameter-index as xs:integer) as empty-sequence() external
declare %an:sequential function jdbc:set-numeric($prepared-statement as xs:anyURI, $parameter-index as xs:decimal, $value as xs:anyAtomicType) as empty-sequence() external
declare %an:sequential function jdbc:set-string($prepared-statement as xs:anyURI, $parameter-index as xs:integer, $value as xs:string) as empty-sequence() external
declare %an:sequential function jdbc:set-value($prepared-statement as xs:anyURI, $parameter-index as xs:decimal, $value as xs:anyAtomicType) as empty-sequence() external
declare %an:sequential function jdbc:tables($connection-id as xs:anyURI) as object()*
declare %an:sequential function jdbc:tables($connection-id as xs:anyURI, $catalog as xs:string?, $schema as xs:string?, $table as xs:string?) as object()* external
$jdbc:NOT-SUPPORTED as item()*
$jdbc:READ-COMMITTED as item()*
$jdbc:READ-UNCOMMITTED as item()*
$jdbc:REPEATABLE-READ as item()*
$jdbc:SERIALIZABLE as item()*