1 Reply Latest reply: Oct 26, 2011 12:16 PM by user11985990 RSS

    oracle.lite.sync.Consolidator.PubItemProps => isLogBased ?

    user11985990
      Hi All,

      I am a little confuse about isLogBased.

      Doc said:

      isLogBased

      If true, log based (automatic) publication item will be created

      Does it mean that if isLogBased = true, then Oracle Lite does not use trigger process, but capture data

      in redo logs (like streams) ?

      Of course this does not work whith Standard Edition main db , only with enterpriseEdition ?

      If it is clear for you, thak you for your clarification.

      All the best.

      Fabrice
        • 1. Re: oracle.lite.sync.Consolidator.PubItemProps => isLogBased ?
          user11985990
          Hi all,

          I was completely lost.

          Setting "isLogBased" to True enables automatic sync for a pub item.

          The following example uses the automatic synchronization version of createPublicationItem method, which uses the PubItemProps class to define all publication item definitions, including automatic synchronization, as follows:

          PubItemProps pi_props = new PubItemProps();
          pi_props.owner = "MASTER"; // owner schema
          pi_props.store = STORES[0]; // store
          pi_props.refresh_mode = "F"; //default // uses fast refresh
          pi_props.select_stmt = // specify select statement for snapshot
          "SELECT * FROM "+"MASTER"+"."+STORES[i][0]+ " WHERE C1 =:CLIENTID";
          pi_props.cl2log_rec_stmt = "SELECT base.C1 FROM " // client sub-query to
          + "MASTER"+"."+STORES[i][0] + " base," // return unique clientids
          + "MASTER"+".CLG$"+STORES[i][0] + " log"
          + " WHERE base.ID = log.ID";
          // Setting "isLogBased" to True enables automatic sync for this pub item.
          pi_props.isLogBased = true;
          // If doChangeNtf is true, automatic publication item sends notifications
          // from server about new/modified records
          pi_props.doChangeNtf = true;

          cm.createPublicationItem(PUBITEMS[i], pi_props);
          cm.addPublicationItem(PUB,PUBITEMS[i],null,null,"S",null,null);

          Regards.

          Fabrice