Setting SQLJ Translator Options

You can control the translation of SQLJ class through the controls in the Project Properties dialog:

Provide syntactic as well as semantic checking of SQL code.
Provide syntax and type checking on the SQL statements.
Test the compatibility of Java and SQL expressions at compile time
Specify a connection to a database server
Check the semantics of your SQL statements against the database schemas specified by connection contexts

To set the SQLJ translator options:

In the Workspace Navigator, select the project that contains the SQLJ file.
Choose Tools | Project Properties | Profiles and select the configuration you wish to use.
In the selected configuration, expand Compiler and select SQLJ.
In the SQLJ panel, set the compilation options.
When finished, click OK.