Skip to content
The latest version of DbVisualizer was released 2024-07-04DOWNLOAD HERE ->

Locating SQL Errors

If errors occur, the corresponding text is underlined with a red wavy line. Hovering the mouse over the error indication shows the corresponding error message. The right margin contains markers for each error as well, and clicking on a marker scrolls the editor to the corresponding error. Alternatively, you can click the FAILED link in the Log tab grid to move the caret to the error location.

If you prefer to navigate between errors using the keyboard, you can use the defined key bindings for the Insertion Point to Next Marker and Insertion Point to Previous Marker actions in the Tool Properties dialog, in the Key Bindings category, in the Editor Commands group. Alternative is to use the Goto Next Failed and Goto Previous Failed in the right click menu of Log tab grid, and then click the link for the FAILED entries.

Error location information is not available for some databases. In that case the complete statement is underlined in the editor.

Disable Error Markers in the SQL Editor

From DbVisualizer 10.0.5 it is possible to disable error markers in the SQL Commander->SQL Commander Options menus. With Show Error Position Markers turned on it shows markers only for databases that specifically report positions of errors in a statement. With Show Error Statement Markers turned on the complete statement is highlighted if it fails during execution, but only if either the Show Error Position Markers is turned off or if the driver/database doesn't report positions of errors.

If you re looking to minimize the amount of error markers when executing scripts, turn off Show Error Statement Markers and keep the Show Error Position Markers checked (turned on). DbVisualizer will then report errors reported by the JDBC driver only.

To set default values for these settings visit Tools->Tool Properties and the General / SQL Commander category.