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:
- Select Window > Preferences.
- In the Preferences window, select Data
Management > SQL Development > Data
Access Development.
- On the Data Access Development page,
follow these steps under Compilation settings:
- 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.
- 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.