Rod,

Below is a list of all of the problems that I have encountered with the 
example application.

1. The payment.html view using jsp (I have not looked at the other view 
implementations) is only partially implemented. The only inputs to appear 
on the page are the postcode and email address. The other inputs (Credit 
card, address, etc.) as illustrated in the book are absent. Also this page 
navigates to a test.html view, which is not implemented.

2. The confirmation.html view using jsp is a debug view not the page shown 
in the book which displays the booking reference number etc.

3. The insertion of data for the performance table in the populate.sql 
file should occur after the data for the seat table and seat_plan_seat 
table have been inserted. This will allow population of the seat_status 
table when the performance_seat_status trigger fires.

4. As previously mentioned I get the following error when the 
performance_seat_status trigger fires.

 Error on line 0
 insert into performance (id, date_and_time, show_id, price_structure_id)
 value

 ORA-00001: unique constraint (DEMO.SYS_IOT_TOP_30333) violated
 ORA-06512: at "DEMO.PERFORMANCE_SEAT_STATUS", line 2

The unique constraint is violated because the select in the trigger 
returns redundant data as follows....


SQL>    select 1, seat_plan_seat.seat_id, price_band.id
  2      from seat_plan_seat, show, price_band
  3      where
  4       show.seating_plan_id = seat_plan_seat.seating_plan_id
  5       and price_band.price_structure_id = 1
  6       and price_band.seat_class_id = seat_plan_seat.seat_class_id;

         1    SEAT_ID         ID
---------- ---------- ----------
         1         12          2
         1         11          2
         1         10          1
         1          9          1
         1          8          1
         1          7          2
         1          6          2
         1          5          2
         1          4          1
         1          3          1
         1          2          1

         1    SEAT_ID         ID
---------- ---------- ----------
         1          1          2
         1         12          2
         1         11          2
         1         10          1
         1          9          1
         1          8          1
         1          7          2
         1          6          2
         1          5          2
         1          4          1
         1          3          1

         1    SEAT_ID         ID
---------- ---------- ----------
         1          2          1
         1          1          2
         1         12          2
         1         11          2
         1         10          1
         1          9          1
         1          8          1
         1          7          2
         1          6          2
         1          5          2
         1          4          1

         1    SEAT_ID         ID
---------- ---------- ----------
         1          3          1
         1          2          1
         1          1          2
         1         12          2
         1         11          2
         1         10          1
         1          9          1
         1          8          1
         1          7          2
         1          6          2
         1          5          2

         1    SEAT_ID         ID
---------- ---------- ----------
         1          4          1
         1          3          1
         1          2          1
         1          1          2
         1         12          2
         1         11          2
         1         10          1
         1          9          1
         1          8          1
         1          7          2
         1          6          2

         1    SEAT_ID         ID
---------- ---------- ----------
         1          5          2
         1          4          1
         1          3          1
         1          2          1
         1          1          2
         1         12          2
         1         11          2
         1         10          1
         1          9          1
         1          8          1
         1          7          2

         1    SEAT_ID         ID
---------- ---------- ----------
         1          6          2
         1          5          2
         1          4          1
         1          3          1
         1          2          1
         1          1          2
         1         12          2
         1         11          2
         1         10          1
         1          9          1
         1          8          1

         1    SEAT_ID         ID
---------- ---------- ----------
         1          7          2
         1          6          2
         1          5          2
         1          4          1
         1          3          1
         1          2          1
         1          1          2

84 rows selected.


5. Also when running JBoss I get a conflict with the logger and the 
following message appears "ERROR: invalid console appender config 
detected, console stream is looping" at the end of the JBoss startup and
can see no log output. The only why I can get log output to show up is the 
comment out the CONSOLE definition in the log4j.xml file before this file 
is loaded by JBoss and uncomment this definition right after the file is 
loaded.



I would appreciate your help in these matters. Your book has been a great 
learning experience!

Regards,

Chris Axe