Debugging ESQL

Before you start

Complete the following tasks:

While stepping over the source code in an ESQL node (see Stepping into source code), the ESQL variables are displayed in the Variables view in the Debug Perspective. You can browse them and change their associated data values.

You can also set breakpoints on lines in the ESQL code.

To work with ESQL variables

  1. Switch to the Debug perspective.
  2. Open the Variables view. Variables are shown in a tree, using the symbol Variable.
  3. To work with a variable, right-click it and select an option from the pop-up menu.

To use breakpoints on ESQL code lines

  1. Switch to the Debug perspective.
  2. Open the ESQL editor.
  3. Right-click a line where a breakpoint can be set. You cannot set a breakpoint on a comment line or a blank line.
  4. Select from the menu to create, delete, or restrict the breakpoint, in a similar way to normal debugger breakpoints, as described in Working with breakpoints.

To debug promoted ESQL

If you are debugging promoted ESQL, ensure that the Default Compatibility Level is correct by clicking Window > Preferences > ESQL and Mapping > Code Generation > Default Compatibility Level.
  • If you are deploying to Version 5.0 brokers, select 5.0 from the drop-down list (this is the default setting).
  • If you are deploying to Version 2.1 brokers, select 2.1 from the drop-down list.
If you change this setting, you must rebuild every message flow project in your workspace.

If you try to deploy a message set that uses functionality that is not supported by your level of broker, you will receive an error message. To solve this, modify your message set to ensure that it only uses functionality supported by your level of broker, or upgrade your broker to the required level.

Related concepts
Flow debugger overview