Oracle8i SQLJ Developer's Guide and Reference
Release 8.1.5






Prev  Chap Top Next

Functionality of Translator Errors, Messages, and Exit Codes

This section provides an overview of SQLJ translator messages and exit codes.

Translator Error, Warning, and Information Messages

There are three major levels of SQLJ messages you may encounter during the translation phase: error, warning, and information. Warning messages can be further broken down into two levels: non-suppressable and suppressable. Therefore, there are four message categories (in order of seriousness):

  1. errors

  2. non-suppressable warnings

  3. suppressable warnings

  4. information

You can control suppressable warnings and information by using the SQLJ -warn option, as described below.

Error messages, prefixed by Error:, indicate that one of the following has been encountered:

If errors are encountered during SQLJ translation, then no output is produced (.java file or profiles) and compilation and customization are not executed.

Non-suppressable warning messages, prefixed by Warning:, indicate that one of the following has been encountered:

SQLJ translation will complete if a non-suppressable warning is encountered but you should analyze the problem and determine if it should be fixed before running the application. If online checking is specified but cannot be completed, offline checking is performed instead.


For logistical reasons, the parser that the SQLJ translator employs to analyze SQL operations is not the same top-level parser that will be used at runtime. Therefore, errors may occasionally be detected during translation that will not actually cause problems when your application runs. Accordingly, such errors are reported as non-suppressable warnings rather than fatal errors.  

Suppressable warning messages, also prefixed by Warning:, indicate that there is a problem with a particular aspect of your application, such as portability. For example, retrieving data from a nullable column into a primitive int variable. These messages can be suppressed by using the various -warn option flags:

See "Translator Warnings (-warn)" for more information about the -warn option and how to set the flags.

If you receive warnings during your SQLJ translation, then you can try running the translator again with -warn=none to see if any of the warnings are of the more serious (non-suppressable) variety.

Informational or status messages prefixed by Info: do not indicate an error condition. They merely provide additional information about what occurred during the translation phase. These messages can be suppressed by using the -warn option verbose flag, as follows:


For information about particular error, warning, and information messages, see "Translation Time Messages" and "Runtime Messages".  

Table 9-1 summarizes the categories of error and status messages generated by the SQLJ translator.

Table 9-1 SQLJ Translator Error Message Categories
Message Category  Prefix  Indicates  Suppressed By 



fatal error that will cause compilation failure or runtime failure (translation is aborted)  


non-suppressable warning  


condition that prevents proper translation or might cause runtime failure (translation is completed)  


suppressable warning  


problem regarding a particular aspect of your application (translation is completed)  

-warn option flags:

informational/status message  


information regarding the translation process  

-warn option flags:

Translator Status Messages

In addition to the translator's error, warning, and information messages, SQLJ can produce status messages throughout all phases of SQLJ operation--translation, compilation, and customization. Status messages are output as each file is processed and at each phase of SQLJ operation.

You can control status messages by using the SQLJ -status option. This option is also discussed in "Real-Time Status Messages (-status)".

Translator Exit Codes

The following exit codes are returned by the SQLJ translator to the operating system upon completion:


  • If you issue the -help or -version option, then the SQLJ exit code is 0.

  • If you run SQLJ without specifying any files to process, then SQLJ issues help output and returns exit code 1.




Copyright © 1999 Oracle Corporation.

All Rights Reserved.