test

Sun GlassFish ESB Upgrade Guide

ProcedureTo Upgrade the BPEL Monitoring Database

If you are using monitoring for BPEL processes, you need to update the monitoring database to complete the upgrade.

  1. For MySQL databases, run the following script against the BPEL monitoring database:


    CREATE TABLE MONITORBPELPROCESS (
    suname varchar (256),
    bpelid varchar (744),
    genbpelevents char(1),
    primary key (bpelid)
) ENGINE=InnoDB;

  2. For Oracle or Derby databases, run the following script against the BPEL monitoring database:


    CREATE TABLE MONITORBPELPROCESS (
    suname varchar(256),
    bpelid varchar(1028),
    genbpelevents char(1),
    primary key (bpelid)
);