Extending pluggable SQL at runtime

If the existing common Resultset Processor is not sufficient for your implementation, you can define a new Resultset Processor.

About this task

When extending pluggable SQL at runtime, keep the following considerations in mind:

Procedure

  • All Resultset Processors must implement the GenericResultsetProcessor abstract class.
  • The implementation must be configured as follows: 
    optimized.sql.rsprocessor.<GroupName>=<Implementation class for RS Processor>
  • The metadata class must be implemented as described in Enabling or disabling pluggable SQL at runtime.