dropstatementdata.js Filter

Within certain replication deployments, enforcing that only row-based information is replicated is important to ensure that the row data is replicated properly. For example, when replicating to databases that do not accept statements, these events must be filtered out.

Pre-configured filter name	dropstatementdata
JavaScript Filter File	tungsten-replicator/support/filters-javascript/dropstatementdata.js
Property prefix	replicator.filter.dropstatementdata
Stage compatibility	binlog-to-q, q-to-dbms
tpm Option compatibility	svc-extractor-filters, svc-applier-filters
Data compatibility	Any event

This is achieved by checking for statements, and then removing them from the event:

data = event.getData();

for(i = 0; i < data.size(); i++)
{
  d = data.get(i);

  if(d instanceof com.continuent.tungsten.replicator.dbms.StatementData)
  {
      data.remove(i);
      i--;
  }
}