Choosing how the workbench notifies you when it cannot validate SQL statements

You can specify how the workbench lets you know that it could not validate SQL statements in code that it compiles.

Before you begin

The Java code in which the SQL statements appear must be part of a Java project that is enabled for development with pureQuery.

Procedure

To set this preference:

  1. Select Window > Preferences.
  2. In the Preferences window, select Data Management > SQL Development > Data Access Development.
  3. On the Data Access Development page, follow these steps under Compilation settings:
    1. In the Severity level for SQL problems field, choose whether the workbench should issue errors for SQL statements that it cannot validate, issue warnings, or ignore the fact that validation failed.
    2. Select the Validate table references check box if you want the workbench to check whether SQL statements refer to database objects by their correct names. The workbench validates the references as you type SQL statements in the Java editor, when you save a Java file, and when you build the Java project.

Feedback