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 the server, the mobile business object (MBO) developer can use the filter created from Unwired WorkSpace. See Sybase Unwired WorkSpace - Mobile Business Object Development > Develop > Developing a Mobile Business Object > Binding Mobile Business Objects to Data Sources > Adding a Result Filter > Deploying Result Filter Classes to Unwired Server.
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.