ij Commands and Errors Reference
Page 39 of 39

ij Errors

ij issues the following messages to inform the user of errors during processing of statements:

ERROR SQLState

When the underlying JDBC driver returns an SQLException, ij displays the SQLException message with the prefix "ERROR SQLState". If the SQLException has no SQLState associated with it, the prefix "ERROR (no SQLState)" is used.

WARNING SQLState

Upon completion of execution of any JDBC request, ij will issue a getWarnings request and display the SQLWarnings that are returned. Each SQLWarning message is displayed with the prefix "WARNING SQLState". If an SQLWarning has no SQLState associated with it, the prefix "WARNING (no SQLState)" is used.

IJ ERROR

When ij runs into errors processing user commands, such as being unable to open the file named in a Run command or not having a connection to disconnect from, it prints out a message with the prefix "IJ ERROR".

IJ WARNING

ij displays warning messages to let the user know if behavior may be unexpected. For example, using the Execute command's USING clause while in auto-commit mode can cause unexpected results. ij warnings are prefixed with "IJ WARNING".

JAVA ERROR

When an unexpected Java exception occurs, ij prints a message with the prefix "JAVA ERROR".