This tutorial describes a sample session for debugging a stored procedure. It is a continuation of “Tutorial: Getting started with the debugger”.
In this tutorial, you call JDBCExamples.Query() from Interactive SQL (DBISQL), interrupt the execution in the debugger, and trace through the source code for this method.
The JDBCExamples.Query() method executes the following query against the sample database:
SELECT id, unit_price FROM product
It then loops through all the rows of the result set, and returns the one with the highest unit price.
You must compile classes with the javac -g option
in order to debug them. The sample classes are compiled for debugging.
