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, UnitPrice FROM Products
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
to debug them. The sample classes are compiled for debugging.
To use the Java examples, you must have the Java example classes installed into the sample database. See “Preparing the database”.