getWarning()

Since USoft 9.1.1.B, some functionality was added to provide RulesService warnings in the Services Framework. This functionality can be used when you have one of the USoft Default Providers, or the USoftService utility class, as a functional type. To check if there is a warning that occurred in the RulesService, you can use the getWarning() method after you have executed a sql statement. For example:

Returns a java.sql.SQLWarning of the last SQL statement that has been executed. If the last SQL statement did not return a warning, the function will return null.

If you have 2 SQL statements where the first statement gave a warning and the second one does not give a warning, and you check for a warning after the second statement the warning of the first statement is not available anymore. If you want to know each warning then you have to check after every statement.

Syntax

public SQLWarning getWarning()

Example

SQLWarning lastWarning = getWarning();

If you would like to check if a warning has occurred before requesting the warning you can use the warningHasOccurred method. This method will return a boolean to indicate a warning has occurred in the last SQL statement. If the result is true, a warning has occurred.

Syntax

public boolean warningHasOccurred()

Example

if(warningHasOccurred()){

Logger log = Logger.getLogger(this.getClass());

log.warn("A warning has occurred -> " + getWarning());

}