UpdateCLOBFieldProcess

Top  Previous  Next

org.moremotion.mmcomp.reldb.UpdateCLOBFieldProcess class existing in mmcomp_reldb.jar extends MoreMotion's org.moremotion.process.Process base class and it is used to load large text values into the CLOB type fields of the tables.

This class is configured as follows.

  <process name="UpdateDescriptions" basedon="mor.RelDB.UpdateBLOBFieldProcess">
    <param name="conn">SuperStore</param>
    <param name="query">
  SELECT ID, SHORT_DESC, LONG_DESC FROM products 
    WHERE ID = @vof(ID) FOR UPDATE
    </param>
    <param name="fields">
  SHORT_DESC = f:SHORT_DESC
  LONG_DESC  = f:LONG_DESC    
    </param>
 
  </process>

Parameters

conn (Accepts MScript)

The name of a JDBC connection that is configured with jdbcConnection element.

query (Accepts MScript)

In this parameter a select query that selects the BLOB fields for update must be given. Some JDBC drivers require that the primary index columns are also selected.

fields (Accepts MScript)

This parameter should contain field assignments (each on a separate line).

The syntax for each line:

CLOB_FIELD_NAME = CLOB_FIELD_VALUE
 

CLOB_FIELD_NAME

The name of a CLOB field that exists in the result set. Note that the CLOB field should have an initial value otherwise the process may fail.

CLOB_FIELD_VALUE

An MScript expression that supplies the content for the CLOB field.

 

Completion Codes

This Process returns the following completion codes

0 Normal completion
12 An unknown error (probably a JDBC error) is occurred.