UpdateBLOBFieldProcess

Top  Previous  Next

This process is used to load files into the BLOB type fields of the tables.

  <process name="StoreImagesProcess" basedon="mor.RelDB.UpdateBLOBFieldProcess">
    <param name="conn">SuperStore</param>
    <param name="query">
      SELECT ID, SMALL_IMAGE, BIG_IMAGE FROM products
        WHERE ID = @vof(ID) FOR UPDATE
    </param>
    <param name="fields">
      SMALL_IMAGE = 'WEB-INF/MM-INF/~tempfiles/' + SMALL_IMAGE_FILE_NAME
      BIG_IMAGE   = 'WEB-INF/MM-INF/~tempfiles/' + BIG_IMAGE_FILE_NAME
    </param>
  </process>

See more...