UpdateBLOBFieldProcess |
![]() ![]() ![]() |
org.moremotion.mmcomp.reldb.UpdateBLOBFieldProcess class existing in mmcomp_reldb.jar extends MoreMotion's org.moremotion.process.Process base class and it is used to load files into the BLOB type fields of the tables. The capacity of the file BLOB fields may differ from one Database to another. This class is configured as follows.
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: BLOB_FIELD_NAME = FILE_NAME BLOB_FIELD_NAME The name of a BLOB field that exists in the result set. Note that the BLOB field should have an initial value otherwise the process may fail. FILE_NAME An MScript expression that resolves to a file name. The content of the file will be transferred to the given BLOB field. The file name can be absolute or relative to the root directory of the web application.
Completion Codes This Process returns the following completion codes
|