1.1

field
}
//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.
vFabric SQLFire User's Guide196
Caching Data with vFabric SQLFire