1.0

}
//process the row , may be persist to file.
break;
case AFTER_UPDATE:
List<Object> rowUpdated = event.getNewRow();
//Modified column's column position is given by the below API.
//The unmodified cols are null
List<Integer> modifiedCols = event.getModifiedColumns();
for (int colNum : modifiedCols) {
//The column number which is modified is given by colNum.
//Obtain info about modified column
String colName = rsmd.getColumnName(colNum);
//Obtain the modified value of the column
//Notice that the value is obtained at position colNum -1, as
the
//List containing values is zero based while column position
in table
// is 1 based.
Object newColNalue = rowUpdated.get(colNum - 1);
//process the information using the column name , table name,
schema name
//& modified value.
}
break;
case AFTER_DELETE:
//Utilize the pk , primary key for processing the deleted row.
break;
}
}
}
catch (Exception e) {
//handle exception
return false;
}
return true;
}
}
Install the AsyncEventListener Configuration
Install the AsyncEventListener implementation by executing the CREATE ASYNCEVENTLISTENER statement
on any member of the SQLFire system. You must specify the server groups on which to deploy the implementation,
as well as a unique identification and class name for the implementation.
For example:
CREATE ASYNCEVENTLISTENER MyListener
(
LISTENERCLASSNAME 'user.application.TestAsyncEventListener'
INITPARAMS ''
) SERVER GROUPS ( SG1 );
Note: You must include the INITPARAMS argument, even if it defines no parameters.
Note: You can optionally install the AsyncEventListener configuration after you associate a table with
the listener name. Make sure that you use the same listener name with both the CREATE
ASYNCEVENTLISTNER command and the CREATE TABLE command.
vFabric SQLFire User's Guide188
Caching Data with vFabric SQLFire