Steps to upgrade from 4.1.0 to 4.2.0

  1. Upgrade the Soiree plugin to 4.2.0
  2. Upgrade your Java projects
    1. Right click on the project name in the package explorer.
    2. Select ‘Soiree Project Configuration’
    3. Update the Library Files
  3. Clean your project
  4. Modify the definition of some Soiree system tables.
    • For MS SQL Server databases use this script
      ALTER TABLE SoireeSignonLog ADD I_PROD VARCHAR(254);
      ALTER TABLE SoireeUser DROP COLUMN I_CONN_CREA;
      ALTER TABLE SoireeUser DROP COLUMN I_CONN_MODF;
      ALTER TABLE SoireeSequence DROP COLUMN F_ACTV;
      
    • For all other database types use this script
      ALTER TABLE SoireeSignonLog ADD COLUMN I_PROD VARCHAR(254);
      ALTER TABLE SoireeUser DROP COLUMN I_CONN_CREA;
      ALTER TABLE SoireeSequence DROP COLUMN F_ACTV;
      ALTER TABLE SoireeUser DROP COLUMN I_CONN_MODF;
      
  5. Soiree authenticator declarations have moved from the Solution to the Product.
    • You will need to add your authenticators to the product definition.
  6. Create the File Download tables in your system database. Due to a bug, v4.2.0’s ‘Soiree Project Configuration’ tool does not automatically add the DDL for the File Download tables to your project. You can manually download the DDL for the File Download tables here.

You can obtain the Android, iOS, and Server runtime libraries here: Soiree Downloads