snaulus (8) [Avatar] Offline
Running the code in listing 10.1 will produce a number of exceptions if you are using HSQLDB 2.2. The worst is an error message stating:

"user lacks privilege or object not found: ATHLETE"

It turns out that this message is produced by the CREATE INDEX call. If you remove the CREATE INDEX call from the reset() method and create the index separately (after creating the table), you are fine.

But why inflicting all this pain on yourself if there is an easier way? Just use HSQLDB 1.8 and all works as planned!