API tools faq
paste
Guest User

Untitled

a guest
May 31st, 2018
147
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 151.66 KB | None | 0 0
raw download clone embed print report
  1. 23:41:21,887 (DBWorkload.java:126) INFO - **********************************************************************************
  2. 23:41:21,889 (DBWorkload.java:134) INFO - Configuration file: config/sample_oraseats_config.xml
  3. 23:41:21,896 (DBWorkload.java:147) INFO - DB Type = ORACLE
  4. 23:41:21,896 (DBWorkload.java:148) INFO - Driver = net.sf.log4jdbc.DriverSpy
  5. 23:41:21,897 (DBWorkload.java:149) INFO - URL = jdbc:oracle:thin:@ora.co5wlv4yvt1b.us-east-1.rds.amazonaws.com:1521:mydb
  6. 23:41:21,897 (DBWorkload.java:150) INFO - Isolation mode = TRANSACTION_SERIALIZABLE [DEFAULT]
  7. 23:41:22,064 (DBWorkload.java:191) INFO - Benchmark: seats {Class: com.oltpbenchmark.benchmarks.seats.SEATSBenchmark}
  8. 23:41:22,283 (BenchmarkModule.java:206) DEBUG - Executing script 'seats-ddl.sql'
  9. 23:41:22,588 (StatementDialects.java:102) DEBUG - Loading the SQL dialect file 'seats-dialects.xml' for ORACLE
  10. 23:41:22,588 (StatementDialects.java:131) DEBUG - ORACLE.GetReviewItemById.getReviewItem
  11.  
  12. SELECT * FROM review r, item i WHERE i.i_id = r.i_id and r.i_id=? AND ROWNUM = 10
  13. ORDER BY rating
  14.  
  15.  
  16. 23:41:22,598 (DBWorkload.java:301) INFO - Creating 100 virtual terminals ..
  17. 23:41:25,121 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  18. 23:41:25,123 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  19. 23:41:25,124 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  20. 23:41:25,124 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  21. 23:41:25,125 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  22. 23:41:25,126 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  23. 23:41:25,126 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  24. 23:41:25,130 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  25. 23:41:25,131 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  26. 23:41:25,131 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  27. 23:41:25,131 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  28. 23:41:25,131 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  29. 23:41:25,132 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  30. 23:41:25,132 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  31. 23:41:25,132 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  32. 23:41:25,132 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  33. 23:41:25,133 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  34. 23:41:25,133 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  35. 23:41:25,133 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  36. 23:41:27,243 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  37. 23:41:27,244 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  38. 23:41:27,244 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  39. 23:41:27,245 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  40. 23:41:27,245 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  41. 23:41:27,245 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  42. 23:41:27,246 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  43. 23:41:27,246 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  44. 23:41:27,247 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  45. 23:41:27,247 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  46. 23:41:27,247 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  47. 23:41:27,248 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  48. 23:41:27,248 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  49. 23:41:27,248 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  50. 23:41:27,249 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  51. 23:41:27,249 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  52. 23:41:27,249 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  53. 23:41:27,249 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  54. 23:41:27,249 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  55. 23:41:29,205 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  56. 23:41:29,206 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  57. 23:41:29,206 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  58. 23:41:29,207 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  59. 23:41:29,207 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  60. 23:41:29,208 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  61. 23:41:29,208 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  62. 23:41:29,209 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  63. 23:41:29,209 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  64. 23:41:29,210 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  65. 23:41:29,210 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  66. 23:41:29,210 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  67. 23:41:29,211 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  68. 23:41:29,211 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  69. 23:41:29,211 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  70. 23:41:29,212 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  71. 23:41:29,212 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  72. 23:41:29,212 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  73. 23:41:29,213 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  74. 23:41:31,130 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  75. 23:41:31,131 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  76. 23:41:31,132 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  77. 23:41:31,132 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  78. 23:41:31,133 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  79. 23:41:31,133 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  80. 23:41:31,134 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  81. 23:41:31,135 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  82. 23:41:31,135 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  83. 23:41:31,135 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  84. 23:41:31,136 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  85. 23:41:31,136 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  86. 23:41:31,136 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  87. 23:41:31,137 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  88. 23:41:31,137 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  89. 23:41:31,137 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  90. 23:41:31,138 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  91. 23:41:31,138 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  92. 23:41:31,138 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  93. 23:41:33,267 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  94. 23:41:33,268 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  95. 23:41:33,268 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  96. 23:41:33,268 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  97. 23:41:33,268 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  98. 23:41:33,269 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  99. 23:41:33,269 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  100. 23:41:33,269 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  101. 23:41:33,270 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  102. 23:41:33,270 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  103. 23:41:33,270 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  104. 23:41:33,270 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  105. 23:41:33,270 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  106. 23:41:33,271 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  107. 23:41:33,271 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  108. 23:41:33,271 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  109. 23:41:33,271 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  110. 23:41:33,272 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  111. 23:41:33,272 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  112. 23:41:35,342 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  113. 23:41:35,342 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  114. 23:41:35,342 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  115. 23:41:35,342 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  116. 23:41:35,343 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  117. 23:41:35,343 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  118. 23:41:35,343 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  119. 23:41:35,344 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  120. 23:41:35,344 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  121. 23:41:35,344 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  122. 23:41:35,344 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  123. 23:41:35,344 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  124. 23:41:35,345 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  125. 23:41:35,345 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  126. 23:41:35,345 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  127. 23:41:35,345 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  128. 23:41:35,346 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  129. 23:41:35,346 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  130. 23:41:35,346 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  131. 23:41:37,506 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  132. 23:41:37,507 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  133. 23:41:37,507 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  134. 23:41:37,508 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  135. 23:41:37,508 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  136. 23:41:37,508 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  137. 23:41:37,509 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  138. 23:41:37,509 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  139. 23:41:37,509 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  140. 23:41:37,510 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  141. 23:41:37,510 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  142. 23:41:37,510 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  143. 23:41:37,510 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  144. 23:41:37,511 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  145. 23:41:37,511 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  146. 23:41:37,511 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  147. 23:41:37,512 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  148. 23:41:37,512 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  149. 23:41:37,512 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  150. 23:41:39,617 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  151. 23:41:39,617 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  152. 23:41:39,618 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  153. 23:41:39,618 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  154. 23:41:39,618 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  155. 23:41:39,619 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  156. 23:41:39,619 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  157. 23:41:39,619 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  158. 23:41:39,620 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  159. 23:41:39,620 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  160. 23:41:39,620 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  161. 23:41:39,620 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  162. 23:41:39,620 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  163. 23:41:39,621 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  164. 23:41:39,621 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  165. 23:41:39,621 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  166. 23:41:39,621 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  167. 23:41:39,621 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  168. 23:41:39,622 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  169. 23:41:41,633 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  170. 23:41:41,633 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  171. 23:41:41,634 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  172. 23:41:41,634 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  173. 23:41:41,635 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  174. 23:41:41,635 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  175. 23:41:41,635 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  176. 23:41:41,636 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  177. 23:41:41,636 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  178. 23:41:41,636 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  179. 23:41:41,637 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  180. 23:41:41,637 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  181. 23:41:41,637 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  182. 23:41:41,637 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  183. 23:41:41,638 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  184. 23:41:41,638 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  185. 23:41:41,638 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  186. 23:41:41,638 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  187. 23:41:41,638 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  188. 23:41:43,548 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  189. 23:41:43,548 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  190. 23:41:43,549 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  191. 23:41:43,549 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  192. 23:41:43,550 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  193. 23:41:43,550 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  194. 23:41:43,551 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  195. 23:41:43,551 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  196. 23:41:43,551 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  197. 23:41:43,552 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  198. 23:41:43,552 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  199. 23:41:43,552 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  200. 23:41:43,553 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  201. 23:41:43,553 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  202. 23:41:43,553 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  203. 23:41:43,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  204. 23:41:43,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  205. 23:41:43,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  206. 23:41:43,555 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  207. 23:41:45,596 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  208. 23:41:45,596 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  209. 23:41:45,596 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  210. 23:41:45,597 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  211. 23:41:45,597 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  212. 23:41:45,597 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  213. 23:41:45,598 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  214. 23:41:45,598 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  215. 23:41:45,598 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  216. 23:41:45,598 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  217. 23:41:45,598 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  218. 23:41:45,599 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  219. 23:41:45,599 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  220. 23:41:45,599 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  221. 23:41:45,599 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  222. 23:41:45,599 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  223. 23:41:45,600 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  224. 23:41:45,600 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  225. 23:41:45,600 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  226. 23:41:47,695 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  227. 23:41:47,695 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  228. 23:41:47,696 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  229. 23:41:47,696 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  230. 23:41:47,696 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  231. 23:41:47,697 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  232. 23:41:47,697 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  233. 23:41:47,697 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  234. 23:41:47,697 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  235. 23:41:47,698 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  236. 23:41:47,698 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  237. 23:41:47,698 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  238. 23:41:47,698 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  239. 23:41:47,698 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  240. 23:41:47,699 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  241. 23:41:47,699 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  242. 23:41:47,699 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  243. 23:41:47,699 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  244. 23:41:47,699 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  245. 23:41:49,583 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  246. 23:41:49,584 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  247. 23:41:49,584 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  248. 23:41:49,585 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  249. 23:41:49,585 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  250. 23:41:49,586 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  251. 23:41:49,586 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  252. 23:41:49,587 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  253. 23:41:49,587 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  254. 23:41:49,587 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  255. 23:41:49,588 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  256. 23:41:49,588 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  257. 23:41:49,589 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  258. 23:41:49,589 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  259. 23:41:49,589 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  260. 23:41:49,590 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  261. 23:41:49,590 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  262. 23:41:49,590 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  263. 23:41:49,591 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  264. 23:41:51,447 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  265. 23:41:51,448 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  266. 23:41:51,449 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  267. 23:41:51,449 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  268. 23:41:51,450 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  269. 23:41:51,450 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  270. 23:41:51,451 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  271. 23:41:51,451 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  272. 23:41:51,452 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  273. 23:41:51,452 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  274. 23:41:51,452 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  275. 23:41:51,453 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  276. 23:41:51,453 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  277. 23:41:51,453 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  278. 23:41:51,454 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  279. 23:41:51,454 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  280. 23:41:51,454 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  281. 23:41:51,455 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  282. 23:41:51,455 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  283. 23:41:53,426 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  284. 23:41:53,426 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  285. 23:41:53,426 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  286. 23:41:53,427 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  287. 23:41:53,427 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  288. 23:41:53,427 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  289. 23:41:53,427 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  290. 23:41:53,428 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  291. 23:41:53,428 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  292. 23:41:53,428 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  293. 23:41:53,428 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  294. 23:41:53,428 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  295. 23:41:53,429 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  296. 23:41:53,429 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  297. 23:41:53,429 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  298. 23:41:53,429 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  299. 23:41:53,429 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  300. 23:41:53,429 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  301. 23:41:53,430 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  302. 23:41:55,916 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  303. 23:41:55,917 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  304. 23:41:55,917 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  305. 23:41:55,918 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  306. 23:41:55,919 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  307. 23:41:55,919 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  308. 23:41:55,920 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  309. 23:41:55,921 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  310. 23:41:55,921 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  311. 23:41:55,921 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  312. 23:41:55,921 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  313. 23:41:55,921 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  314. 23:41:55,921 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  315. 23:41:55,921 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  316. 23:41:55,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  317. 23:41:55,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  318. 23:41:55,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  319. 23:41:55,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  320. 23:41:55,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  321. 23:41:57,815 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  322. 23:41:57,816 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  323. 23:41:57,816 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  324. 23:41:57,817 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  325. 23:41:57,817 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  326. 23:41:57,817 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  327. 23:41:57,818 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  328. 23:41:57,818 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  329. 23:41:57,819 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  330. 23:41:57,819 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  331. 23:41:57,819 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  332. 23:41:57,819 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  333. 23:41:57,819 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  334. 23:41:57,820 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  335. 23:41:57,820 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  336. 23:41:57,820 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  337. 23:41:57,820 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  338. 23:41:57,821 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  339. 23:41:57,821 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  340. 23:41:59,959 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  341. 23:41:59,959 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  342. 23:41:59,959 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  343. 23:41:59,959 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  344. 23:41:59,960 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  345. 23:41:59,960 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  346. 23:41:59,960 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  347. 23:41:59,960 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  348. 23:41:59,960 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  349. 23:41:59,961 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  350. 23:41:59,961 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  351. 23:41:59,961 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  352. 23:41:59,961 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  353. 23:41:59,961 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  354. 23:41:59,961 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  355. 23:41:59,961 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  356. 23:41:59,962 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  357. 23:41:59,962 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  358. 23:41:59,962 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  359. 23:42:02,099 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  360. 23:42:02,099 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  361. 23:42:02,099 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  362. 23:42:02,100 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  363. 23:42:02,100 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  364. 23:42:02,100 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  365. 23:42:02,100 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  366. 23:42:02,101 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  367. 23:42:02,101 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  368. 23:42:02,101 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  369. 23:42:02,101 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  370. 23:42:02,101 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  371. 23:42:02,101 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  372. 23:42:02,101 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  373. 23:42:02,102 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  374. 23:42:02,102 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  375. 23:42:02,102 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  376. 23:42:02,102 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  377. 23:42:02,102 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  378. 23:42:04,176 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  379. 23:42:04,176 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  380. 23:42:04,177 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  381. 23:42:04,177 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  382. 23:42:04,177 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  383. 23:42:04,178 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  384. 23:42:04,178 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  385. 23:42:04,179 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  386. 23:42:04,179 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  387. 23:42:04,179 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  388. 23:42:04,179 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  389. 23:42:04,180 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  390. 23:42:04,180 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  391. 23:42:04,180 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  392. 23:42:04,180 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  393. 23:42:04,181 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  394. 23:42:04,181 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  395. 23:42:04,181 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  396. 23:42:04,181 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  397. 23:42:06,279 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  398. 23:42:06,279 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  399. 23:42:06,280 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  400. 23:42:06,280 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  401. 23:42:06,280 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  402. 23:42:06,281 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  403. 23:42:06,281 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  404. 23:42:06,282 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  405. 23:42:06,282 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  406. 23:42:06,282 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  407. 23:42:06,282 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  408. 23:42:06,283 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  409. 23:42:06,283 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  410. 23:42:06,283 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  411. 23:42:06,283 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  412. 23:42:06,283 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  413. 23:42:06,284 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  414. 23:42:06,284 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  415. 23:42:06,284 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  416. 23:42:08,267 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  417. 23:42:08,267 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  418. 23:42:08,268 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  419. 23:42:08,268 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  420. 23:42:08,269 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  421. 23:42:08,269 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  422. 23:42:08,269 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  423. 23:42:08,270 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  424. 23:42:08,270 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  425. 23:42:08,270 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  426. 23:42:08,271 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  427. 23:42:08,271 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  428. 23:42:08,271 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  429. 23:42:08,271 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  430. 23:42:08,272 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  431. 23:42:08,272 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  432. 23:42:08,272 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  433. 23:42:08,272 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  434. 23:42:08,273 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  435. 23:42:10,356 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  436. 23:42:10,357 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  437. 23:42:10,357 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  438. 23:42:10,357 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  439. 23:42:10,357 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  440. 23:42:10,358 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  441. 23:42:10,358 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  442. 23:42:10,359 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  443. 23:42:10,359 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  444. 23:42:10,359 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  445. 23:42:10,359 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  446. 23:42:10,359 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  447. 23:42:10,360 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  448. 23:42:10,360 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  449. 23:42:10,360 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  450. 23:42:10,360 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  451. 23:42:10,360 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  452. 23:42:10,361 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  453. 23:42:10,361 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  454. 23:42:12,250 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  455. 23:42:12,250 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  456. 23:42:12,251 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  457. 23:42:12,251 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  458. 23:42:12,251 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  459. 23:42:12,252 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  460. 23:42:12,252 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  461. 23:42:12,252 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  462. 23:42:12,253 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  463. 23:42:12,253 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  464. 23:42:12,253 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  465. 23:42:12,253 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  466. 23:42:12,254 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  467. 23:42:12,254 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  468. 23:42:12,254 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  469. 23:42:12,254 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  470. 23:42:12,254 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  471. 23:42:12,255 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  472. 23:42:12,255 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  473. 23:42:14,303 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  474. 23:42:14,303 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  475. 23:42:14,304 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  476. 23:42:14,304 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  477. 23:42:14,304 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  478. 23:42:14,305 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  479. 23:42:14,305 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  480. 23:42:14,306 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  481. 23:42:14,306 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  482. 23:42:14,306 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  483. 23:42:14,306 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  484. 23:42:14,306 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  485. 23:42:14,307 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  486. 23:42:14,307 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  487. 23:42:14,307 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  488. 23:42:14,307 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  489. 23:42:14,308 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  490. 23:42:14,308 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  491. 23:42:14,308 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  492. 23:42:16,315 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  493. 23:42:16,316 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  494. 23:42:16,316 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  495. 23:42:16,317 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  496. 23:42:16,317 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  497. 23:42:16,317 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  498. 23:42:16,318 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  499. 23:42:16,318 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  500. 23:42:16,319 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  501. 23:42:16,319 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  502. 23:42:16,319 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  503. 23:42:16,320 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  504. 23:42:16,320 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  505. 23:42:16,321 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  506. 23:42:16,321 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  507. 23:42:16,321 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  508. 23:42:16,322 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  509. 23:42:16,322 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  510. 23:42:16,323 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  511. 23:42:18,179 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  512. 23:42:18,180 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  513. 23:42:18,180 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  514. 23:42:18,180 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  515. 23:42:18,180 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  516. 23:42:18,181 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  517. 23:42:18,181 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  518. 23:42:18,181 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  519. 23:42:18,182 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  520. 23:42:18,182 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  521. 23:42:18,182 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  522. 23:42:18,182 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  523. 23:42:18,182 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  524. 23:42:18,182 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  525. 23:42:18,182 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  526. 23:42:18,183 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  527. 23:42:18,183 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  528. 23:42:18,183 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  529. 23:42:18,183 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  530. 23:42:20,396 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  531. 23:42:20,397 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  532. 23:42:20,397 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  533. 23:42:20,398 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  534. 23:42:20,398 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  535. 23:42:20,398 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  536. 23:42:20,399 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  537. 23:42:20,399 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  538. 23:42:20,399 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  539. 23:42:20,400 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  540. 23:42:20,400 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  541. 23:42:20,400 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  542. 23:42:20,401 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  543. 23:42:20,401 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  544. 23:42:20,401 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  545. 23:42:20,401 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  546. 23:42:20,402 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  547. 23:42:20,402 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  548. 23:42:20,402 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  549. 23:42:22,613 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  550. 23:42:22,613 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  551. 23:42:22,614 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  552. 23:42:22,614 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  553. 23:42:22,614 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  554. 23:42:22,615 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  555. 23:42:22,615 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  556. 23:42:22,616 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  557. 23:42:22,616 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  558. 23:42:22,616 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  559. 23:42:22,616 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  560. 23:42:22,616 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  561. 23:42:22,616 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  562. 23:42:22,617 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  563. 23:42:22,617 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  564. 23:42:22,617 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  565. 23:42:22,617 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  566. 23:42:22,617 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  567. 23:42:22,618 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  568. 23:42:24,504 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  569. 23:42:24,504 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  570. 23:42:24,505 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  571. 23:42:24,505 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  572. 23:42:24,505 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  573. 23:42:24,506 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  574. 23:42:24,506 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  575. 23:42:24,506 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  576. 23:42:24,507 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  577. 23:42:24,507 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  578. 23:42:24,507 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  579. 23:42:24,507 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  580. 23:42:24,508 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  581. 23:42:24,508 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  582. 23:42:24,508 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  583. 23:42:24,508 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  584. 23:42:24,508 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  585. 23:42:24,509 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  586. 23:42:24,509 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  587. 23:42:26,550 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  588. 23:42:26,551 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  589. 23:42:26,551 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  590. 23:42:26,551 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  591. 23:42:26,551 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  592. 23:42:26,552 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  593. 23:42:26,552 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  594. 23:42:26,553 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  595. 23:42:26,553 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  596. 23:42:26,553 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  597. 23:42:26,553 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  598. 23:42:26,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  599. 23:42:26,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  600. 23:42:26,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  601. 23:42:26,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  602. 23:42:26,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  603. 23:42:26,554 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  604. 23:42:26,555 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  605. 23:42:26,555 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  606. 23:42:28,579 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  607. 23:42:28,580 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  608. 23:42:28,580 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  609. 23:42:28,580 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  610. 23:42:28,580 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  611. 23:42:28,580 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  612. 23:42:28,581 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  613. 23:42:28,581 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  614. 23:42:28,581 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  615. 23:42:28,581 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  616. 23:42:28,581 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  617. 23:42:28,582 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  618. 23:42:28,582 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  619. 23:42:28,582 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  620. 23:42:28,582 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  621. 23:42:28,618 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  622. 23:42:28,618 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  623. 23:42:28,619 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  624. 23:42:28,619 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  625. 23:42:30,770 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  626. 23:42:30,770 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  627. 23:42:30,771 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  628. 23:42:30,771 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  629. 23:42:30,771 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  630. 23:42:30,771 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  631. 23:42:30,771 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  632. 23:42:30,771 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  633. 23:42:30,772 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  634. 23:42:30,772 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  635. 23:42:30,772 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  636. 23:42:30,772 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  637. 23:42:30,772 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  638. 23:42:30,772 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  639. 23:42:30,772 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  640. 23:42:30,772 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  641. 23:42:30,772 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  642. 23:42:30,773 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  643. 23:42:30,773 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  644. 23:42:32,919 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  645. 23:42:32,919 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  646. 23:42:32,919 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  647. 23:42:32,920 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  648. 23:42:32,920 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  649. 23:42:32,920 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  650. 23:42:32,920 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  651. 23:42:32,921 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  652. 23:42:32,921 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  653. 23:42:32,921 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  654. 23:42:32,921 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  655. 23:42:32,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  656. 23:42:32,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  657. 23:42:32,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  658. 23:42:32,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  659. 23:42:32,922 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  660. 23:42:32,923 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  661. 23:42:32,923 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  662. 23:42:32,923 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  663. 23:42:34,999 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  664. 23:42:34,999 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  665. 23:42:35,000 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  666. 23:42:35,000 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  667. 23:42:35,000 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  668. 23:42:35,000 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  669. 23:42:35,001 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  670. 23:42:35,001 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  671. 23:42:35,001 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  672. 23:42:35,002 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  673. 23:42:35,002 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  674. 23:42:35,002 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  675. 23:42:35,002 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  676. 23:42:35,002 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  677. 23:42:35,003 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  678. 23:42:35,003 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  679. 23:42:35,003 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  680. 23:42:35,003 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  681. 23:42:35,004 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  682. 23:42:37,054 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  683. 23:42:37,055 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  684. 23:42:37,055 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  685. 23:42:37,055 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  686. 23:42:37,055 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  687. 23:42:37,056 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  688. 23:42:37,056 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  689. 23:42:37,057 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  690. 23:42:37,057 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  691. 23:42:37,057 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  692. 23:42:37,057 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  693. 23:42:37,057 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  694. 23:42:37,058 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  695. 23:42:37,058 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  696. 23:42:37,058 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  697. 23:42:37,058 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  698. 23:42:37,058 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  699. 23:42:37,058 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  700. 23:42:37,059 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  701. 23:42:39,155 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  702. 23:42:39,157 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  703. 23:42:39,157 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  704. 23:42:39,157 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  705. 23:42:39,157 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  706. 23:42:39,158 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  707. 23:42:39,158 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  708. 23:42:39,158 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  709. 23:42:39,159 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  710. 23:42:39,159 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  711. 23:42:39,159 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  712. 23:42:39,159 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  713. 23:42:39,160 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  714. 23:42:39,160 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  715. 23:42:39,160 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  716. 23:42:39,160 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  717. 23:42:39,160 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  718. 23:42:39,160 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  719. 23:42:39,161 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  720. 23:42:41,026 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  721. 23:42:41,027 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  722. 23:42:41,027 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  723. 23:42:41,027 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  724. 23:42:41,028 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  725. 23:42:41,028 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  726. 23:42:41,028 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  727. 23:42:41,029 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  728. 23:42:41,029 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  729. 23:42:41,029 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  730. 23:42:41,029 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  731. 23:42:41,029 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  732. 23:42:41,029 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  733. 23:42:41,030 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  734. 23:42:41,030 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  735. 23:42:41,030 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  736. 23:42:41,030 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  737. 23:42:41,030 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  738. 23:42:41,030 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  739. 23:42:43,025 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  740. 23:42:43,025 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  741. 23:42:43,026 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  742. 23:42:43,026 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  743. 23:42:43,026 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  744. 23:42:43,026 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  745. 23:42:43,027 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  746. 23:42:43,027 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  747. 23:42:43,027 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  748. 23:42:43,028 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  749. 23:42:43,028 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  750. 23:42:43,028 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  751. 23:42:43,028 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  752. 23:42:43,028 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  753. 23:42:43,028 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  754. 23:42:43,029 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  755. 23:42:43,029 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  756. 23:42:43,029 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  757. 23:42:43,029 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  758. 23:42:44,959 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  759. 23:42:44,959 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  760. 23:42:44,959 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  761. 23:42:44,960 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  762. 23:42:44,960 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  763. 23:42:44,960 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  764. 23:42:44,961 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  765. 23:42:44,961 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  766. 23:42:44,962 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  767. 23:42:44,962 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  768. 23:42:44,962 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  769. 23:42:44,962 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  770. 23:42:44,962 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  771. 23:42:44,962 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  772. 23:42:44,963 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  773. 23:42:44,963 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  774. 23:42:44,963 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  775. 23:42:44,963 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  776. 23:42:44,964 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  777. 23:42:47,038 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  778. 23:42:47,038 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  779. 23:42:47,038 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  780. 23:42:47,039 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  781. 23:42:47,039 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  782. 23:42:47,039 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  783. 23:42:47,039 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  784. 23:42:47,039 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  785. 23:42:47,039 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  786. 23:42:47,039 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  787. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  788. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  789. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  790. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  791. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  792. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  793. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  794. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  795. 23:42:47,040 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  796. 23:42:49,082 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  797. 23:42:49,082 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  798. 23:42:49,082 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  799. 23:42:49,083 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  800. 23:42:49,083 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  801. 23:42:49,083 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  802. 23:42:49,083 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  803. 23:42:49,084 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  804. 23:42:49,084 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  805. 23:42:49,084 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  806. 23:42:49,084 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  807. 23:42:49,085 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  808. 23:42:49,085 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  809. 23:42:49,085 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  810. 23:42:49,085 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  811. 23:42:49,085 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  812. 23:42:49,085 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  813. 23:42:49,086 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  814. 23:42:49,086 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  815. 23:42:51,129 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  816. 23:42:51,130 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  817. 23:42:51,130 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  818. 23:42:51,130 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  819. 23:42:51,130 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  820. 23:42:51,130 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  821. 23:42:51,130 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  822. 23:42:51,131 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  823. 23:42:51,131 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  824. 23:42:51,131 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  825. 23:42:51,131 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  826. 23:42:51,131 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  827. 23:42:51,131 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  828. 23:42:51,131 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  829. 23:42:51,131 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  830. 23:42:51,132 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  831. 23:42:51,132 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  832. 23:42:51,132 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  833. 23:42:51,132 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  834. 23:42:53,074 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  835. 23:42:53,074 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  836. 23:42:53,075 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  837. 23:42:53,075 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  838. 23:42:53,075 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  839. 23:42:53,075 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  840. 23:42:53,076 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  841. 23:42:53,076 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  842. 23:42:53,076 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  843. 23:42:53,076 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  844. 23:42:53,077 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  845. 23:42:53,077 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  846. 23:42:53,077 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  847. 23:42:53,077 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  848. 23:42:53,078 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  849. 23:42:53,078 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  850. 23:42:53,078 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  851. 23:42:53,078 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  852. 23:42:53,078 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  853. 23:42:55,009 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  854. 23:42:55,009 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  855. 23:42:55,009 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  856. 23:42:55,009 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  857. 23:42:55,010 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  858. 23:42:55,010 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  859. 23:42:55,010 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  860. 23:42:55,010 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  861. 23:42:55,011 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  862. 23:42:55,011 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  863. 23:42:55,011 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  864. 23:42:55,011 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  865. 23:42:55,011 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  866. 23:42:55,011 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  867. 23:42:55,012 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  868. 23:42:55,012 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  869. 23:42:55,012 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  870. 23:42:55,012 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  871. 23:42:55,012 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  872. 23:42:56,860 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  873. 23:42:56,861 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  874. 23:42:56,861 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  875. 23:42:56,861 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  876. 23:42:56,862 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  877. 23:42:56,862 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  878. 23:42:56,862 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  879. 23:42:56,863 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  880. 23:42:56,863 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  881. 23:42:56,863 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  882. 23:42:56,863 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  883. 23:42:56,863 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  884. 23:42:56,864 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  885. 23:42:56,864 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  886. 23:42:56,864 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  887. 23:42:56,864 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  888. 23:42:56,864 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  889. 23:42:56,865 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  890. 23:42:56,865 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  891. 23:42:58,891 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  892. 23:42:58,892 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  893. 23:42:58,892 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  894. 23:42:58,892 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  895. 23:42:58,893 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  896. 23:42:58,893 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  897. 23:42:58,893 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  898. 23:42:58,894 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  899. 23:42:58,894 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  900. 23:42:58,894 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  901. 23:42:58,894 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  902. 23:42:58,895 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  903. 23:42:58,895 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  904. 23:42:58,895 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  905. 23:42:58,895 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  906. 23:42:58,895 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  907. 23:42:58,896 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  908. 23:42:58,896 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  909. 23:42:58,896 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  910. 23:43:00,909 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  911. 23:43:00,909 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  912. 23:43:00,909 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  913. 23:43:00,909 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  914. 23:43:00,910 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  915. 23:43:00,910 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  916. 23:43:00,910 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  917. 23:43:00,910 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  918. 23:43:00,911 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  919. 23:43:00,911 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  920. 23:43:00,911 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  921. 23:43:00,911 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  922. 23:43:00,911 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  923. 23:43:00,911 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  924. 23:43:00,911 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  925. 23:43:00,912 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  926. 23:43:00,912 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  927. 23:43:00,912 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  928. 23:43:00,912 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  929. 23:43:03,067 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  930. 23:43:03,068 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  931. 23:43:03,068 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  932. 23:43:03,068 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  933. 23:43:03,068 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  934. 23:43:03,068 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  935. 23:43:03,069 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  936. 23:43:03,069 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  937. 23:43:03,069 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  938. 23:43:03,069 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  939. 23:43:03,069 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  940. 23:43:03,069 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  941. 23:43:03,069 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  942. 23:43:03,069 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  943. 23:43:03,070 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  944. 23:43:03,070 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  945. 23:43:03,070 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  946. 23:43:03,070 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  947. 23:43:03,070 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  948. 23:43:05,201 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  949. 23:43:05,202 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  950. 23:43:05,202 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  951. 23:43:05,202 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  952. 23:43:05,203 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  953. 23:43:05,203 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  954. 23:43:05,203 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  955. 23:43:05,204 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  956. 23:43:05,204 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  957. 23:43:05,204 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  958. 23:43:05,204 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  959. 23:43:05,204 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  960. 23:43:05,204 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  961. 23:43:05,205 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  962. 23:43:05,205 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  963. 23:43:05,205 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  964. 23:43:05,205 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  965. 23:43:05,205 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  966. 23:43:05,205 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  967. 23:43:07,151 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  968. 23:43:07,151 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  969. 23:43:07,151 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  970. 23:43:07,151 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  971. 23:43:07,151 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  972. 23:43:07,151 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  973. 23:43:07,152 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  974. 23:43:07,152 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  975. 23:43:07,152 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  976. 23:43:07,152 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  977. 23:43:07,152 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  978. 23:43:07,152 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  979. 23:43:07,152 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  980. 23:43:07,153 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  981. 23:43:07,153 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  982. 23:43:07,153 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  983. 23:43:07,153 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  984. 23:43:07,153 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  985. 23:43:07,153 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  986. 23:43:09,103 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  987. 23:43:09,103 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  988. 23:43:09,104 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  989. 23:43:09,105 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  990. 23:43:09,142 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  991. 23:43:09,143 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  992. 23:43:09,143 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  993. 23:43:09,144 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  994. 23:43:09,144 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  995. 23:43:09,144 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  996. 23:43:09,145 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  997. 23:43:09,145 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  998. 23:43:09,145 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  999. 23:43:09,146 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1000. 23:43:09,146 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1001. 23:43:09,146 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1002. 23:43:09,146 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1003. 23:43:09,146 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1004. 23:43:09,146 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1005. 23:43:11,310 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1006. 23:43:11,310 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1007. 23:43:11,310 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1008. 23:43:11,311 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1009. 23:43:11,311 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1010. 23:43:11,311 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1011. 23:43:11,311 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1012. 23:43:11,312 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1013. 23:43:11,312 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1014. 23:43:11,312 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1015. 23:43:11,312 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1016. 23:43:11,313 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1017. 23:43:11,313 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1018. 23:43:11,313 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1019. 23:43:11,314 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1020. 23:43:11,314 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1021. 23:43:11,315 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1022. 23:43:11,353 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1023. 23:43:11,353 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1024. 23:43:13,439 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1025. 23:43:13,439 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1026. 23:43:13,440 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1027. 23:43:13,440 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1028. 23:43:13,440 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1029. 23:43:13,440 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1030. 23:43:13,441 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1031. 23:43:13,441 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1032. 23:43:13,441 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1033. 23:43:13,442 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1034. 23:43:13,442 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1035. 23:43:13,442 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1036. 23:43:13,442 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1037. 23:43:13,442 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1038. 23:43:13,442 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1039. 23:43:13,442 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1040. 23:43:13,443 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1041. 23:43:13,443 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1042. 23:43:13,450 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1043. 23:43:15,487 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1044. 23:43:15,488 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1045. 23:43:15,488 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1046. 23:43:15,488 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1047. 23:43:15,488 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1048. 23:43:15,488 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1049. 23:43:15,488 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1050. 23:43:15,488 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1051. 23:43:15,489 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1052. 23:43:15,489 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1053. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1054. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1055. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1056. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1057. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1058. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1059. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1060. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1061. 23:43:15,489 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1062. 23:43:17,534 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1063. 23:43:17,534 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1064. 23:43:17,535 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1065. 23:43:17,535 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1066. 23:43:17,535 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1067. 23:43:17,535 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1068. 23:43:17,535 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1069. 23:43:17,535 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1070. 23:43:17,535 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1071. 23:43:17,536 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1072. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1073. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1074. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1075. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1076. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1077. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1078. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1079. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1080. 23:43:17,536 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1081. 23:43:19,457 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1082. 23:43:19,457 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1083. 23:43:19,457 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1084. 23:43:19,457 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1085. 23:43:19,457 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1086. 23:43:19,458 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1087. 23:43:19,458 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1088. 23:43:19,458 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1089. 23:43:19,458 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1090. 23:43:19,458 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1091. 23:43:19,458 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1092. 23:43:19,458 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1093. 23:43:19,458 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1094. 23:43:19,458 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1095. 23:43:19,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1096. 23:43:19,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1097. 23:43:19,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1098. 23:43:19,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1099. 23:43:19,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1100. 23:43:21,791 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1101. 23:43:21,791 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1102. 23:43:21,791 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1103. 23:43:21,791 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1104. 23:43:21,792 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1105. 23:43:21,792 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1106. 23:43:21,792 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1107. 23:43:21,792 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1108. 23:43:21,792 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1109. 23:43:21,792 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1110. 23:43:21,792 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1111. 23:43:21,792 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1112. 23:43:21,793 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1113. 23:43:21,793 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1114. 23:43:21,793 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1115. 23:43:21,793 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1116. 23:43:21,793 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1117. 23:43:21,793 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1118. 23:43:21,793 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1119. 23:43:23,644 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1120. 23:43:23,645 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1121. 23:43:23,645 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1122. 23:43:23,645 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1123. 23:43:23,646 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1124. 23:43:23,646 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1125. 23:43:23,646 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1126. 23:43:23,647 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1127. 23:43:23,647 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1128. 23:43:23,647 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1129. 23:43:23,647 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1130. 23:43:23,647 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1131. 23:43:23,647 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1132. 23:43:23,648 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1133. 23:43:23,648 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1134. 23:43:23,648 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1135. 23:43:23,648 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1136. 23:43:23,648 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1137. 23:43:23,648 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1138. 23:43:25,637 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1139. 23:43:25,637 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1140. 23:43:25,637 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1141. 23:43:25,638 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1142. 23:43:25,638 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1143. 23:43:25,638 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1144. 23:43:25,639 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1145. 23:43:25,639 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1146. 23:43:25,639 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1147. 23:43:25,640 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1148. 23:43:25,640 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1149. 23:43:25,640 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1150. 23:43:25,640 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1151. 23:43:25,640 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1152. 23:43:25,640 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1153. 23:43:25,641 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1154. 23:43:25,641 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1155. 23:43:25,641 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1156. 23:43:25,641 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  1157. 23:43:28,128 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  1158. 23:43:28,128 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  1159. 23:43:28,128 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  1160. 23:43:28,128 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  1161. 23:43:28,128 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  1162. 23:43:28,129 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  1163. 23:43:28,129 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  1164. 23:43:28,129 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  1165. 23:43:28,129 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  1166. 23:43:28,129 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  1167. 23:43:28,129 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  1168. 23:43:28,129 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  1169. 23:43:28,130 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  1170. 23:43:28,130 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  1171. 23:43:28,130 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  1172. 23:43:28,130 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  1173. 23:43:28,130 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  1174. 23:43:28,130 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  1175. 23:43:28,130 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!