WARNING: This server provides a static reference view of the NetKernel documentation. Links to dynamic content do not work. For the best experience we recommend you install NetKernel and view the documentation in the live system .

Endpoint
Name:SQL UpdateClob Accessor
Description:Provides sqlUpdateClob processing for a SQL relational databases
Id:mod-db:sqlUpdateClob
Category:accessor
Identifier Syntax

SQL UpdateClob Accessor is an accessor using Active URI syntax with the following base identifiers:

Base
active:sqlUpdateClob

and the following arguments: (for more details on argument passing details see here)

ArgumentRulesTypingDescription
operand
Mandatory
Representation (java.lang.Object)SQL INSERT or UPDATE statement to be executed
param
Mandatory
Representation (java.lang.Object)In memory String value
configuration
Optional
Representation (java.lang.Object)Connection pool configuration
Request Verbs

The following verb is supported:

Verb
SOURCE
Response

The response representation of this accessor for SOURCE requests is unknown.

This accessor throws no documented exceptions.

Import Requirements

To use SQL UpdateClob Accessor accessor you must import the module urn:org:netkernel:mod:db:

<import>
  <uri>urn:org:netkernel:mod:db</uri>
</import>

When a request with the SOURCE verb is issued to active:sqlUpdateClob the SQL statement in the required operand argument is used with the database connection pool specified in the optional configuration argument. (If the configuration argument is not supplied then the service issues a request for the resource res:/etc/ConfigRDBMS.xml in the current space.) The SQL statement must be an UPDATE or INSERT parameterized statement (see below) with a single parameter. When executed, the service will issue a SOURCE request for the resource specified by the required param argument and stream it over the database connection to the database.

The service does not return a representation.

Because of the nature of a large object, only one can be sent by this service for each request. If there are fewer or more parameters than required an exception is thrown.

Parameterized SQL

Parameterized SQL statements are complete except for specific parts signified by a "?" (question mark) symbol. Before execution the parameters must be replaced by parameter values. The active:sqlUpdateClob service must have a parameterized SQL statement with a single parameter which is supplied by the resource identified by the param argument.

Example

The following code implements the example query illustrated above.

request = context.createRequest("active:sqlUpdateBlob");
request.addArgumentByValue("operand", "INSERT INTO big_table (image) VALUES (?);");
request.addArgument("param", "res:/resource/documents/novel.txt");
context.issueRequest(request);