Implementing Custom Result Set Filters

Developers can write a filter to add, delete, or change columns as well as to add and delete rows.

Prerequisites

To write a filter, developers must have previous experience with Java programming — particularly with the reference implementations for javax.sql.RowSet, which is used to implement the filter interface and described in the JDBC RowSet Implementations Tutorial.

Note: Sybase strongly encourages developers to initially create filters in Unwired WorkSpace: a wizard assists you by autogenerating required imports, and methods correctly generated so the implementation already compiles and runs. Then to customize the code, you can cut and paste fragments from the sample, and make the required changes to get the desired end result.
Task
Once the filter has been implemented and deployed to Unwired Server as part of an MBO package, the MBO developer can apply the filter to other MBOs from Unwired Workspace. See Filtering Result Sets Returned by Attributes in Sybase Unwired WorkSpace - Mobile Business Object Development.
Note: Validate the performance of any custom result set filters, before deploying packages to Unwired Server.
  1. Writing a Custom Result Set Filter
    Write a custom result set filter to define specific application processing logic. Save the compiled Java class file to location that is accessible from Unwired WorkSpace.
  2. Deploying Custom Filters to Unwired Server
    Deploy custom filters as part of a deployment unit.
  3. Validating Result Set Filter Performance
    After you deploy the filters to Unwired Server, synchronize data and ensure that filters are performing as you expect.