Advertisement
popov-aa

Untitled

Mar 2nd, 2019
320
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 58.25 KB | None | 0 0
  1. Hibernate:
  2. select
  3. organizati0_.id as id1_9_0_,
  4. organizati0_.registration_date_time as registra2_9_0_,
  5. organizati0_.registration_member_id as registra4_9_0_,
  6. organizati0_.title as title3_9_0_,
  7. member1_.id as id1_8_1_,
  8. member1_.email as email2_8_1_,
  9. member1_.first_name as first_na3_8_1_,
  10. member1_.last_name as last_nam4_8_1_,
  11. member1_.password as password5_8_1_,
  12. member1_.role as role6_8_1_,
  13. advertiser2_.id as id1_0_2_,
  14. advertiser2_.organization_id as organiza2_0_2_,
  15. site3_.id as id1_12_3_,
  16. site3_.organization_id as organiza2_12_3_
  17. from
  18. webserver.organization organizati0_
  19. inner join
  20. webserver.member member1_
  21. on organizati0_.registration_member_id=member1_.id
  22. left outer join
  23. webserver.advertiser advertiser2_
  24. on organizati0_.id=advertiser2_.organization_id
  25. left outer join
  26. webserver.site site3_
  27. on organizati0_.id=site3_.organization_id
  28. where
  29. organizati0_.id=?
  30. Hibernate:
  31. select
  32. paidvideos0_.advertiser as advertis2_10_0_,
  33. paidvideos0_.id as id1_10_0_,
  34. paidvideos0_.id as id1_10_1_,
  35. paidvideos0_.advertiser as advertis2_10_1_,
  36. paidvideos0_.video_id as video_id3_10_1_,
  37. video1_.id as id1_14_2_,
  38. video1_.duration as duration2_14_2_,
  39. video1_.extension as extensio3_14_2_,
  40. video1_.md5sum as md4_14_2_,
  41. video1_.size as size5_14_2_,
  42. video1_.title as title6_14_2_,
  43. video1_.uploaded_date_time as uploaded7_14_2_,
  44. video1_.uploaded_member_id as uploaded8_14_2_,
  45. member2_.id as id1_8_3_,
  46. member2_.email as email2_8_3_,
  47. member2_.first_name as first_na3_8_3_,
  48. member2_.last_name as last_nam4_8_3_,
  49. member2_.password as password5_8_3_,
  50. member2_.role as role6_8_3_,
  51. freevideo3_.id as id1_6_4_,
  52. freevideo3_.video_id as video_id2_6_4_
  53. from
  54. webserver.paid_video paidvideos0_
  55. inner join
  56. webserver.video video1_
  57. on paidvideos0_.video_id=video1_.id
  58. inner join
  59. webserver.member member2_
  60. on video1_.uploaded_member_id=member2_.id
  61. left outer join
  62. webserver.free_video freevideo3_
  63. on video1_.id=freevideo3_.video_id
  64. where
  65. paidvideos0_.advertiser=?
  66. Hibernate:
  67. select
  68. bookings0_.paid_video_id as paid_vid6_2_0_,
  69. bookings0_.id as id1_2_0_,
  70. bookings0_.id as id1_2_1_,
  71. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  72. bookings0_.end_date as end_date3_2_1_,
  73. bookings0_.paid_video_id as paid_vid6_2_1_,
  74. bookings0_.registration_date_time as registra4_2_1_,
  75. bookings0_.registration_member_id as registra7_2_1_,
  76. bookings0_.start_date as start_da5_2_1_,
  77. member1_.id as id1_8_2_,
  78. member1_.email as email2_8_2_,
  79. member1_.first_name as first_na3_8_2_,
  80. member1_.last_name as last_nam4_8_2_,
  81. member1_.password as password5_8_2_,
  82. member1_.role as role6_8_2_
  83. from
  84. webserver.booking bookings0_
  85. inner join
  86. webserver.member member1_
  87. on bookings0_.registration_member_id=member1_.id
  88. where
  89. bookings0_.paid_video_id=?
  90. 2019-03-02 17:56:57.696 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #1 delete.
  91. Hibernate:
  92. select
  93. shownvideo0_.booking_id as booking_3_11_0_,
  94. shownvideo0_.id as id1_11_0_,
  95. shownvideo0_.id as id1_11_1_,
  96. shownvideo0_.booking_id as booking_3_11_1_,
  97. shownvideo0_.datetime as datetime2_11_1_,
  98. shownvideo0_.device_id as device_i4_11_1_,
  99. device1_.id as id1_4_2_,
  100. device1_.location_id as location3_4_2_,
  101. device1_.uuid as uuid2_4_2_,
  102. location2_.id as id1_7_3_,
  103. location2_.max_device_count as max_devi2_7_3_,
  104. location2_.site_id as site_id4_7_3_,
  105. location2_.title as title3_7_3_,
  106. site3_.id as id1_12_4_,
  107. site3_.organization_id as organiza2_12_4_,
  108. organizati4_.id as id1_9_5_,
  109. organizati4_.registration_date_time as registra2_9_5_,
  110. organizati4_.registration_member_id as registra4_9_5_,
  111. organizati4_.title as title3_9_5_,
  112. member5_.id as id1_8_6_,
  113. member5_.email as email2_8_6_,
  114. member5_.first_name as first_na3_8_6_,
  115. member5_.last_name as last_nam4_8_6_,
  116. member5_.password as password5_8_6_,
  117. member5_.role as role6_8_6_,
  118. advertiser6_.id as id1_0_7_,
  119. advertiser6_.organization_id as organiza2_0_7_
  120. from
  121. webserver.shown_video shownvideo0_
  122. inner join
  123. webserver.device device1_
  124. on shownvideo0_.device_id=device1_.id
  125. inner join
  126. webserver.location location2_
  127. on device1_.location_id=location2_.id
  128. inner join
  129. webserver.site site3_
  130. on location2_.site_id=site3_.id
  131. inner join
  132. webserver.organization organizati4_
  133. on site3_.organization_id=organizati4_.id
  134. inner join
  135. webserver.member member5_
  136. on organizati4_.registration_member_id=member5_.id
  137. left outer join
  138. webserver.advertiser advertiser6_
  139. on organizati4_.id=advertiser6_.organization_id
  140. where
  141. shownvideo0_.booking_id=?
  142. 2019-03-02 17:56:57.717 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #1 delete.
  143. Hibernate:
  144. select
  145. bookings0_.paid_video_id as paid_vid6_2_0_,
  146. bookings0_.id as id1_2_0_,
  147. bookings0_.id as id1_2_1_,
  148. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  149. bookings0_.end_date as end_date3_2_1_,
  150. bookings0_.paid_video_id as paid_vid6_2_1_,
  151. bookings0_.registration_date_time as registra4_2_1_,
  152. bookings0_.registration_member_id as registra7_2_1_,
  153. bookings0_.start_date as start_da5_2_1_,
  154. member1_.id as id1_8_2_,
  155. member1_.email as email2_8_2_,
  156. member1_.first_name as first_na3_8_2_,
  157. member1_.last_name as last_nam4_8_2_,
  158. member1_.password as password5_8_2_,
  159. member1_.role as role6_8_2_
  160. from
  161. webserver.booking bookings0_
  162. inner join
  163. webserver.member member1_
  164. on bookings0_.registration_member_id=member1_.id
  165. where
  166. bookings0_.paid_video_id=?
  167. 2019-03-02 17:56:57.720 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #2 delete.
  168. Hibernate:
  169. select
  170. shownvideo0_.booking_id as booking_3_11_0_,
  171. shownvideo0_.id as id1_11_0_,
  172. shownvideo0_.id as id1_11_1_,
  173. shownvideo0_.booking_id as booking_3_11_1_,
  174. shownvideo0_.datetime as datetime2_11_1_,
  175. shownvideo0_.device_id as device_i4_11_1_,
  176. device1_.id as id1_4_2_,
  177. device1_.location_id as location3_4_2_,
  178. device1_.uuid as uuid2_4_2_,
  179. location2_.id as id1_7_3_,
  180. location2_.max_device_count as max_devi2_7_3_,
  181. location2_.site_id as site_id4_7_3_,
  182. location2_.title as title3_7_3_,
  183. site3_.id as id1_12_4_,
  184. site3_.organization_id as organiza2_12_4_,
  185. organizati4_.id as id1_9_5_,
  186. organizati4_.registration_date_time as registra2_9_5_,
  187. organizati4_.registration_member_id as registra4_9_5_,
  188. organizati4_.title as title3_9_5_,
  189. member5_.id as id1_8_6_,
  190. member5_.email as email2_8_6_,
  191. member5_.first_name as first_na3_8_6_,
  192. member5_.last_name as last_nam4_8_6_,
  193. member5_.password as password5_8_6_,
  194. member5_.role as role6_8_6_,
  195. advertiser6_.id as id1_0_7_,
  196. advertiser6_.organization_id as organiza2_0_7_
  197. from
  198. webserver.shown_video shownvideo0_
  199. inner join
  200. webserver.device device1_
  201. on shownvideo0_.device_id=device1_.id
  202. inner join
  203. webserver.location location2_
  204. on device1_.location_id=location2_.id
  205. inner join
  206. webserver.site site3_
  207. on location2_.site_id=site3_.id
  208. inner join
  209. webserver.organization organizati4_
  210. on site3_.organization_id=organizati4_.id
  211. inner join
  212. webserver.member member5_
  213. on organizati4_.registration_member_id=member5_.id
  214. left outer join
  215. webserver.advertiser advertiser6_
  216. on organizati4_.id=advertiser6_.organization_id
  217. where
  218. shownvideo0_.booking_id=?
  219. 2019-03-02 17:56:57.728 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #2 delete.
  220. Hibernate:
  221. select
  222. bookings0_.paid_video_id as paid_vid6_2_0_,
  223. bookings0_.id as id1_2_0_,
  224. bookings0_.id as id1_2_1_,
  225. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  226. bookings0_.end_date as end_date3_2_1_,
  227. bookings0_.paid_video_id as paid_vid6_2_1_,
  228. bookings0_.registration_date_time as registra4_2_1_,
  229. bookings0_.registration_member_id as registra7_2_1_,
  230. bookings0_.start_date as start_da5_2_1_,
  231. member1_.id as id1_8_2_,
  232. member1_.email as email2_8_2_,
  233. member1_.first_name as first_na3_8_2_,
  234. member1_.last_name as last_nam4_8_2_,
  235. member1_.password as password5_8_2_,
  236. member1_.role as role6_8_2_
  237. from
  238. webserver.booking bookings0_
  239. inner join
  240. webserver.member member1_
  241. on bookings0_.registration_member_id=member1_.id
  242. where
  243. bookings0_.paid_video_id=?
  244. 2019-03-02 17:56:57.731 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #3 delete.
  245. Hibernate:
  246. select
  247. shownvideo0_.booking_id as booking_3_11_0_,
  248. shownvideo0_.id as id1_11_0_,
  249. shownvideo0_.id as id1_11_1_,
  250. shownvideo0_.booking_id as booking_3_11_1_,
  251. shownvideo0_.datetime as datetime2_11_1_,
  252. shownvideo0_.device_id as device_i4_11_1_,
  253. device1_.id as id1_4_2_,
  254. device1_.location_id as location3_4_2_,
  255. device1_.uuid as uuid2_4_2_,
  256. location2_.id as id1_7_3_,
  257. location2_.max_device_count as max_devi2_7_3_,
  258. location2_.site_id as site_id4_7_3_,
  259. location2_.title as title3_7_3_,
  260. site3_.id as id1_12_4_,
  261. site3_.organization_id as organiza2_12_4_,
  262. organizati4_.id as id1_9_5_,
  263. organizati4_.registration_date_time as registra2_9_5_,
  264. organizati4_.registration_member_id as registra4_9_5_,
  265. organizati4_.title as title3_9_5_,
  266. member5_.id as id1_8_6_,
  267. member5_.email as email2_8_6_,
  268. member5_.first_name as first_na3_8_6_,
  269. member5_.last_name as last_nam4_8_6_,
  270. member5_.password as password5_8_6_,
  271. member5_.role as role6_8_6_,
  272. advertiser6_.id as id1_0_7_,
  273. advertiser6_.organization_id as organiza2_0_7_
  274. from
  275. webserver.shown_video shownvideo0_
  276. inner join
  277. webserver.device device1_
  278. on shownvideo0_.device_id=device1_.id
  279. inner join
  280. webserver.location location2_
  281. on device1_.location_id=location2_.id
  282. inner join
  283. webserver.site site3_
  284. on location2_.site_id=site3_.id
  285. inner join
  286. webserver.organization organizati4_
  287. on site3_.organization_id=organizati4_.id
  288. inner join
  289. webserver.member member5_
  290. on organizati4_.registration_member_id=member5_.id
  291. left outer join
  292. webserver.advertiser advertiser6_
  293. on organizati4_.id=advertiser6_.organization_id
  294. where
  295. shownvideo0_.booking_id=?
  296. 2019-03-02 17:56:57.738 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #3 delete.
  297. Hibernate:
  298. select
  299. bookings0_.paid_video_id as paid_vid6_2_0_,
  300. bookings0_.id as id1_2_0_,
  301. bookings0_.id as id1_2_1_,
  302. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  303. bookings0_.end_date as end_date3_2_1_,
  304. bookings0_.paid_video_id as paid_vid6_2_1_,
  305. bookings0_.registration_date_time as registra4_2_1_,
  306. bookings0_.registration_member_id as registra7_2_1_,
  307. bookings0_.start_date as start_da5_2_1_,
  308. member1_.id as id1_8_2_,
  309. member1_.email as email2_8_2_,
  310. member1_.first_name as first_na3_8_2_,
  311. member1_.last_name as last_nam4_8_2_,
  312. member1_.password as password5_8_2_,
  313. member1_.role as role6_8_2_
  314. from
  315. webserver.booking bookings0_
  316. inner join
  317. webserver.member member1_
  318. on bookings0_.registration_member_id=member1_.id
  319. where
  320. bookings0_.paid_video_id=?
  321. 2019-03-02 17:56:57.740 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #4 delete.
  322. Hibernate:
  323. select
  324. shownvideo0_.booking_id as booking_3_11_0_,
  325. shownvideo0_.id as id1_11_0_,
  326. shownvideo0_.id as id1_11_1_,
  327. shownvideo0_.booking_id as booking_3_11_1_,
  328. shownvideo0_.datetime as datetime2_11_1_,
  329. shownvideo0_.device_id as device_i4_11_1_,
  330. device1_.id as id1_4_2_,
  331. device1_.location_id as location3_4_2_,
  332. device1_.uuid as uuid2_4_2_,
  333. location2_.id as id1_7_3_,
  334. location2_.max_device_count as max_devi2_7_3_,
  335. location2_.site_id as site_id4_7_3_,
  336. location2_.title as title3_7_3_,
  337. site3_.id as id1_12_4_,
  338. site3_.organization_id as organiza2_12_4_,
  339. organizati4_.id as id1_9_5_,
  340. organizati4_.registration_date_time as registra2_9_5_,
  341. organizati4_.registration_member_id as registra4_9_5_,
  342. organizati4_.title as title3_9_5_,
  343. member5_.id as id1_8_6_,
  344. member5_.email as email2_8_6_,
  345. member5_.first_name as first_na3_8_6_,
  346. member5_.last_name as last_nam4_8_6_,
  347. member5_.password as password5_8_6_,
  348. member5_.role as role6_8_6_,
  349. advertiser6_.id as id1_0_7_,
  350. advertiser6_.organization_id as organiza2_0_7_
  351. from
  352. webserver.shown_video shownvideo0_
  353. inner join
  354. webserver.device device1_
  355. on shownvideo0_.device_id=device1_.id
  356. inner join
  357. webserver.location location2_
  358. on device1_.location_id=location2_.id
  359. inner join
  360. webserver.site site3_
  361. on location2_.site_id=site3_.id
  362. inner join
  363. webserver.organization organizati4_
  364. on site3_.organization_id=organizati4_.id
  365. inner join
  366. webserver.member member5_
  367. on organizati4_.registration_member_id=member5_.id
  368. left outer join
  369. webserver.advertiser advertiser6_
  370. on organizati4_.id=advertiser6_.organization_id
  371. where
  372. shownvideo0_.booking_id=?
  373. 2019-03-02 17:56:57.745 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #4 delete.
  374. Hibernate:
  375. select
  376. bookings0_.paid_video_id as paid_vid6_2_0_,
  377. bookings0_.id as id1_2_0_,
  378. bookings0_.id as id1_2_1_,
  379. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  380. bookings0_.end_date as end_date3_2_1_,
  381. bookings0_.paid_video_id as paid_vid6_2_1_,
  382. bookings0_.registration_date_time as registra4_2_1_,
  383. bookings0_.registration_member_id as registra7_2_1_,
  384. bookings0_.start_date as start_da5_2_1_,
  385. member1_.id as id1_8_2_,
  386. member1_.email as email2_8_2_,
  387. member1_.first_name as first_na3_8_2_,
  388. member1_.last_name as last_nam4_8_2_,
  389. member1_.password as password5_8_2_,
  390. member1_.role as role6_8_2_
  391. from
  392. webserver.booking bookings0_
  393. inner join
  394. webserver.member member1_
  395. on bookings0_.registration_member_id=member1_.id
  396. where
  397. bookings0_.paid_video_id=?
  398. 2019-03-02 17:56:57.748 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #5 delete.
  399. Hibernate:
  400. select
  401. shownvideo0_.booking_id as booking_3_11_0_,
  402. shownvideo0_.id as id1_11_0_,
  403. shownvideo0_.id as id1_11_1_,
  404. shownvideo0_.booking_id as booking_3_11_1_,
  405. shownvideo0_.datetime as datetime2_11_1_,
  406. shownvideo0_.device_id as device_i4_11_1_,
  407. device1_.id as id1_4_2_,
  408. device1_.location_id as location3_4_2_,
  409. device1_.uuid as uuid2_4_2_,
  410. location2_.id as id1_7_3_,
  411. location2_.max_device_count as max_devi2_7_3_,
  412. location2_.site_id as site_id4_7_3_,
  413. location2_.title as title3_7_3_,
  414. site3_.id as id1_12_4_,
  415. site3_.organization_id as organiza2_12_4_,
  416. organizati4_.id as id1_9_5_,
  417. organizati4_.registration_date_time as registra2_9_5_,
  418. organizati4_.registration_member_id as registra4_9_5_,
  419. organizati4_.title as title3_9_5_,
  420. member5_.id as id1_8_6_,
  421. member5_.email as email2_8_6_,
  422. member5_.first_name as first_na3_8_6_,
  423. member5_.last_name as last_nam4_8_6_,
  424. member5_.password as password5_8_6_,
  425. member5_.role as role6_8_6_,
  426. advertiser6_.id as id1_0_7_,
  427. advertiser6_.organization_id as organiza2_0_7_
  428. from
  429. webserver.shown_video shownvideo0_
  430. inner join
  431. webserver.device device1_
  432. on shownvideo0_.device_id=device1_.id
  433. inner join
  434. webserver.location location2_
  435. on device1_.location_id=location2_.id
  436. inner join
  437. webserver.site site3_
  438. on location2_.site_id=site3_.id
  439. inner join
  440. webserver.organization organizati4_
  441. on site3_.organization_id=organizati4_.id
  442. inner join
  443. webserver.member member5_
  444. on organizati4_.registration_member_id=member5_.id
  445. left outer join
  446. webserver.advertiser advertiser6_
  447. on organizati4_.id=advertiser6_.organization_id
  448. where
  449. shownvideo0_.booking_id=?
  450. 2019-03-02 17:56:57.753 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #5 delete.
  451. Hibernate:
  452. select
  453. bookings0_.paid_video_id as paid_vid6_2_0_,
  454. bookings0_.id as id1_2_0_,
  455. bookings0_.id as id1_2_1_,
  456. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  457. bookings0_.end_date as end_date3_2_1_,
  458. bookings0_.paid_video_id as paid_vid6_2_1_,
  459. bookings0_.registration_date_time as registra4_2_1_,
  460. bookings0_.registration_member_id as registra7_2_1_,
  461. bookings0_.start_date as start_da5_2_1_,
  462. member1_.id as id1_8_2_,
  463. member1_.email as email2_8_2_,
  464. member1_.first_name as first_na3_8_2_,
  465. member1_.last_name as last_nam4_8_2_,
  466. member1_.password as password5_8_2_,
  467. member1_.role as role6_8_2_
  468. from
  469. webserver.booking bookings0_
  470. inner join
  471. webserver.member member1_
  472. on bookings0_.registration_member_id=member1_.id
  473. where
  474. bookings0_.paid_video_id=?
  475. 2019-03-02 17:56:57.757 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #6 delete.
  476. Hibernate:
  477. select
  478. shownvideo0_.booking_id as booking_3_11_0_,
  479. shownvideo0_.id as id1_11_0_,
  480. shownvideo0_.id as id1_11_1_,
  481. shownvideo0_.booking_id as booking_3_11_1_,
  482. shownvideo0_.datetime as datetime2_11_1_,
  483. shownvideo0_.device_id as device_i4_11_1_,
  484. device1_.id as id1_4_2_,
  485. device1_.location_id as location3_4_2_,
  486. device1_.uuid as uuid2_4_2_,
  487. location2_.id as id1_7_3_,
  488. location2_.max_device_count as max_devi2_7_3_,
  489. location2_.site_id as site_id4_7_3_,
  490. location2_.title as title3_7_3_,
  491. site3_.id as id1_12_4_,
  492. site3_.organization_id as organiza2_12_4_,
  493. organizati4_.id as id1_9_5_,
  494. organizati4_.registration_date_time as registra2_9_5_,
  495. organizati4_.registration_member_id as registra4_9_5_,
  496. organizati4_.title as title3_9_5_,
  497. member5_.id as id1_8_6_,
  498. member5_.email as email2_8_6_,
  499. member5_.first_name as first_na3_8_6_,
  500. member5_.last_name as last_nam4_8_6_,
  501. member5_.password as password5_8_6_,
  502. member5_.role as role6_8_6_,
  503. advertiser6_.id as id1_0_7_,
  504. advertiser6_.organization_id as organiza2_0_7_
  505. from
  506. webserver.shown_video shownvideo0_
  507. inner join
  508. webserver.device device1_
  509. on shownvideo0_.device_id=device1_.id
  510. inner join
  511. webserver.location location2_
  512. on device1_.location_id=location2_.id
  513. inner join
  514. webserver.site site3_
  515. on location2_.site_id=site3_.id
  516. inner join
  517. webserver.organization organizati4_
  518. on site3_.organization_id=organizati4_.id
  519. inner join
  520. webserver.member member5_
  521. on organizati4_.registration_member_id=member5_.id
  522. left outer join
  523. webserver.advertiser advertiser6_
  524. on organizati4_.id=advertiser6_.organization_id
  525. where
  526. shownvideo0_.booking_id=?
  527. 2019-03-02 17:56:57.762 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #6 delete.
  528. Hibernate:
  529. select
  530. bookings0_.paid_video_id as paid_vid6_2_0_,
  531. bookings0_.id as id1_2_0_,
  532. bookings0_.id as id1_2_1_,
  533. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  534. bookings0_.end_date as end_date3_2_1_,
  535. bookings0_.paid_video_id as paid_vid6_2_1_,
  536. bookings0_.registration_date_time as registra4_2_1_,
  537. bookings0_.registration_member_id as registra7_2_1_,
  538. bookings0_.start_date as start_da5_2_1_,
  539. member1_.id as id1_8_2_,
  540. member1_.email as email2_8_2_,
  541. member1_.first_name as first_na3_8_2_,
  542. member1_.last_name as last_nam4_8_2_,
  543. member1_.password as password5_8_2_,
  544. member1_.role as role6_8_2_
  545. from
  546. webserver.booking bookings0_
  547. inner join
  548. webserver.member member1_
  549. on bookings0_.registration_member_id=member1_.id
  550. where
  551. bookings0_.paid_video_id=?
  552. 2019-03-02 17:56:57.764 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #7 delete.
  553. Hibernate:
  554. select
  555. shownvideo0_.booking_id as booking_3_11_0_,
  556. shownvideo0_.id as id1_11_0_,
  557. shownvideo0_.id as id1_11_1_,
  558. shownvideo0_.booking_id as booking_3_11_1_,
  559. shownvideo0_.datetime as datetime2_11_1_,
  560. shownvideo0_.device_id as device_i4_11_1_,
  561. device1_.id as id1_4_2_,
  562. device1_.location_id as location3_4_2_,
  563. device1_.uuid as uuid2_4_2_,
  564. location2_.id as id1_7_3_,
  565. location2_.max_device_count as max_devi2_7_3_,
  566. location2_.site_id as site_id4_7_3_,
  567. location2_.title as title3_7_3_,
  568. site3_.id as id1_12_4_,
  569. site3_.organization_id as organiza2_12_4_,
  570. organizati4_.id as id1_9_5_,
  571. organizati4_.registration_date_time as registra2_9_5_,
  572. organizati4_.registration_member_id as registra4_9_5_,
  573. organizati4_.title as title3_9_5_,
  574. member5_.id as id1_8_6_,
  575. member5_.email as email2_8_6_,
  576. member5_.first_name as first_na3_8_6_,
  577. member5_.last_name as last_nam4_8_6_,
  578. member5_.password as password5_8_6_,
  579. member5_.role as role6_8_6_,
  580. advertiser6_.id as id1_0_7_,
  581. advertiser6_.organization_id as organiza2_0_7_
  582. from
  583. webserver.shown_video shownvideo0_
  584. inner join
  585. webserver.device device1_
  586. on shownvideo0_.device_id=device1_.id
  587. inner join
  588. webserver.location location2_
  589. on device1_.location_id=location2_.id
  590. inner join
  591. webserver.site site3_
  592. on location2_.site_id=site3_.id
  593. inner join
  594. webserver.organization organizati4_
  595. on site3_.organization_id=organizati4_.id
  596. inner join
  597. webserver.member member5_
  598. on organizati4_.registration_member_id=member5_.id
  599. left outer join
  600. webserver.advertiser advertiser6_
  601. on organizati4_.id=advertiser6_.organization_id
  602. where
  603. shownvideo0_.booking_id=?
  604. 2019-03-02 17:56:57.769 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #7 delete.
  605. Hibernate:
  606. select
  607. bookings0_.paid_video_id as paid_vid6_2_0_,
  608. bookings0_.id as id1_2_0_,
  609. bookings0_.id as id1_2_1_,
  610. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  611. bookings0_.end_date as end_date3_2_1_,
  612. bookings0_.paid_video_id as paid_vid6_2_1_,
  613. bookings0_.registration_date_time as registra4_2_1_,
  614. bookings0_.registration_member_id as registra7_2_1_,
  615. bookings0_.start_date as start_da5_2_1_,
  616. member1_.id as id1_8_2_,
  617. member1_.email as email2_8_2_,
  618. member1_.first_name as first_na3_8_2_,
  619. member1_.last_name as last_nam4_8_2_,
  620. member1_.password as password5_8_2_,
  621. member1_.role as role6_8_2_
  622. from
  623. webserver.booking bookings0_
  624. inner join
  625. webserver.member member1_
  626. on bookings0_.registration_member_id=member1_.id
  627. where
  628. bookings0_.paid_video_id=?
  629. 2019-03-02 17:56:57.771 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #8 delete.
  630. Hibernate:
  631. select
  632. shownvideo0_.booking_id as booking_3_11_0_,
  633. shownvideo0_.id as id1_11_0_,
  634. shownvideo0_.id as id1_11_1_,
  635. shownvideo0_.booking_id as booking_3_11_1_,
  636. shownvideo0_.datetime as datetime2_11_1_,
  637. shownvideo0_.device_id as device_i4_11_1_,
  638. device1_.id as id1_4_2_,
  639. device1_.location_id as location3_4_2_,
  640. device1_.uuid as uuid2_4_2_,
  641. location2_.id as id1_7_3_,
  642. location2_.max_device_count as max_devi2_7_3_,
  643. location2_.site_id as site_id4_7_3_,
  644. location2_.title as title3_7_3_,
  645. site3_.id as id1_12_4_,
  646. site3_.organization_id as organiza2_12_4_,
  647. organizati4_.id as id1_9_5_,
  648. organizati4_.registration_date_time as registra2_9_5_,
  649. organizati4_.registration_member_id as registra4_9_5_,
  650. organizati4_.title as title3_9_5_,
  651. member5_.id as id1_8_6_,
  652. member5_.email as email2_8_6_,
  653. member5_.first_name as first_na3_8_6_,
  654. member5_.last_name as last_nam4_8_6_,
  655. member5_.password as password5_8_6_,
  656. member5_.role as role6_8_6_,
  657. advertiser6_.id as id1_0_7_,
  658. advertiser6_.organization_id as organiza2_0_7_
  659. from
  660. webserver.shown_video shownvideo0_
  661. inner join
  662. webserver.device device1_
  663. on shownvideo0_.device_id=device1_.id
  664. inner join
  665. webserver.location location2_
  666. on device1_.location_id=location2_.id
  667. inner join
  668. webserver.site site3_
  669. on location2_.site_id=site3_.id
  670. inner join
  671. webserver.organization organizati4_
  672. on site3_.organization_id=organizati4_.id
  673. inner join
  674. webserver.member member5_
  675. on organizati4_.registration_member_id=member5_.id
  676. left outer join
  677. webserver.advertiser advertiser6_
  678. on organizati4_.id=advertiser6_.organization_id
  679. where
  680. shownvideo0_.booking_id=?
  681. 2019-03-02 17:56:57.775 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #8 delete.
  682. Hibernate:
  683. select
  684. bookings0_.paid_video_id as paid_vid6_2_0_,
  685. bookings0_.id as id1_2_0_,
  686. bookings0_.id as id1_2_1_,
  687. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  688. bookings0_.end_date as end_date3_2_1_,
  689. bookings0_.paid_video_id as paid_vid6_2_1_,
  690. bookings0_.registration_date_time as registra4_2_1_,
  691. bookings0_.registration_member_id as registra7_2_1_,
  692. bookings0_.start_date as start_da5_2_1_,
  693. member1_.id as id1_8_2_,
  694. member1_.email as email2_8_2_,
  695. member1_.first_name as first_na3_8_2_,
  696. member1_.last_name as last_nam4_8_2_,
  697. member1_.password as password5_8_2_,
  698. member1_.role as role6_8_2_
  699. from
  700. webserver.booking bookings0_
  701. inner join
  702. webserver.member member1_
  703. on bookings0_.registration_member_id=member1_.id
  704. where
  705. bookings0_.paid_video_id=?
  706. 2019-03-02 17:56:57.778 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #9 delete.
  707. Hibernate:
  708. select
  709. shownvideo0_.booking_id as booking_3_11_0_,
  710. shownvideo0_.id as id1_11_0_,
  711. shownvideo0_.id as id1_11_1_,
  712. shownvideo0_.booking_id as booking_3_11_1_,
  713. shownvideo0_.datetime as datetime2_11_1_,
  714. shownvideo0_.device_id as device_i4_11_1_,
  715. device1_.id as id1_4_2_,
  716. device1_.location_id as location3_4_2_,
  717. device1_.uuid as uuid2_4_2_,
  718. location2_.id as id1_7_3_,
  719. location2_.max_device_count as max_devi2_7_3_,
  720. location2_.site_id as site_id4_7_3_,
  721. location2_.title as title3_7_3_,
  722. site3_.id as id1_12_4_,
  723. site3_.organization_id as organiza2_12_4_,
  724. organizati4_.id as id1_9_5_,
  725. organizati4_.registration_date_time as registra2_9_5_,
  726. organizati4_.registration_member_id as registra4_9_5_,
  727. organizati4_.title as title3_9_5_,
  728. member5_.id as id1_8_6_,
  729. member5_.email as email2_8_6_,
  730. member5_.first_name as first_na3_8_6_,
  731. member5_.last_name as last_nam4_8_6_,
  732. member5_.password as password5_8_6_,
  733. member5_.role as role6_8_6_,
  734. advertiser6_.id as id1_0_7_,
  735. advertiser6_.organization_id as organiza2_0_7_
  736. from
  737. webserver.shown_video shownvideo0_
  738. inner join
  739. webserver.device device1_
  740. on shownvideo0_.device_id=device1_.id
  741. inner join
  742. webserver.location location2_
  743. on device1_.location_id=location2_.id
  744. inner join
  745. webserver.site site3_
  746. on location2_.site_id=site3_.id
  747. inner join
  748. webserver.organization organizati4_
  749. on site3_.organization_id=organizati4_.id
  750. inner join
  751. webserver.member member5_
  752. on organizati4_.registration_member_id=member5_.id
  753. left outer join
  754. webserver.advertiser advertiser6_
  755. on organizati4_.id=advertiser6_.organization_id
  756. where
  757. shownvideo0_.booking_id=?
  758. 2019-03-02 17:56:57.782 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #9 delete.
  759. Hibernate:
  760. select
  761. bookings0_.paid_video_id as paid_vid6_2_0_,
  762. bookings0_.id as id1_2_0_,
  763. bookings0_.id as id1_2_1_,
  764. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  765. bookings0_.end_date as end_date3_2_1_,
  766. bookings0_.paid_video_id as paid_vid6_2_1_,
  767. bookings0_.registration_date_time as registra4_2_1_,
  768. bookings0_.registration_member_id as registra7_2_1_,
  769. bookings0_.start_date as start_da5_2_1_,
  770. member1_.id as id1_8_2_,
  771. member1_.email as email2_8_2_,
  772. member1_.first_name as first_na3_8_2_,
  773. member1_.last_name as last_nam4_8_2_,
  774. member1_.password as password5_8_2_,
  775. member1_.role as role6_8_2_
  776. from
  777. webserver.booking bookings0_
  778. inner join
  779. webserver.member member1_
  780. on bookings0_.registration_member_id=member1_.id
  781. where
  782. bookings0_.paid_video_id=?
  783. 2019-03-02 17:56:57.784 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #10 delete.
  784. Hibernate:
  785. select
  786. shownvideo0_.booking_id as booking_3_11_0_,
  787. shownvideo0_.id as id1_11_0_,
  788. shownvideo0_.id as id1_11_1_,
  789. shownvideo0_.booking_id as booking_3_11_1_,
  790. shownvideo0_.datetime as datetime2_11_1_,
  791. shownvideo0_.device_id as device_i4_11_1_,
  792. device1_.id as id1_4_2_,
  793. device1_.location_id as location3_4_2_,
  794. device1_.uuid as uuid2_4_2_,
  795. location2_.id as id1_7_3_,
  796. location2_.max_device_count as max_devi2_7_3_,
  797. location2_.site_id as site_id4_7_3_,
  798. location2_.title as title3_7_3_,
  799. site3_.id as id1_12_4_,
  800. site3_.organization_id as organiza2_12_4_,
  801. organizati4_.id as id1_9_5_,
  802. organizati4_.registration_date_time as registra2_9_5_,
  803. organizati4_.registration_member_id as registra4_9_5_,
  804. organizati4_.title as title3_9_5_,
  805. member5_.id as id1_8_6_,
  806. member5_.email as email2_8_6_,
  807. member5_.first_name as first_na3_8_6_,
  808. member5_.last_name as last_nam4_8_6_,
  809. member5_.password as password5_8_6_,
  810. member5_.role as role6_8_6_,
  811. advertiser6_.id as id1_0_7_,
  812. advertiser6_.organization_id as organiza2_0_7_
  813. from
  814. webserver.shown_video shownvideo0_
  815. inner join
  816. webserver.device device1_
  817. on shownvideo0_.device_id=device1_.id
  818. inner join
  819. webserver.location location2_
  820. on device1_.location_id=location2_.id
  821. inner join
  822. webserver.site site3_
  823. on location2_.site_id=site3_.id
  824. inner join
  825. webserver.organization organizati4_
  826. on site3_.organization_id=organizati4_.id
  827. inner join
  828. webserver.member member5_
  829. on organizati4_.registration_member_id=member5_.id
  830. left outer join
  831. webserver.advertiser advertiser6_
  832. on organizati4_.id=advertiser6_.organization_id
  833. where
  834. shownvideo0_.booking_id=?
  835. 2019-03-02 17:56:57.788 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #10 delete.
  836. Hibernate:
  837. select
  838. bookings0_.paid_video_id as paid_vid6_2_0_,
  839. bookings0_.id as id1_2_0_,
  840. bookings0_.id as id1_2_1_,
  841. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  842. bookings0_.end_date as end_date3_2_1_,
  843. bookings0_.paid_video_id as paid_vid6_2_1_,
  844. bookings0_.registration_date_time as registra4_2_1_,
  845. bookings0_.registration_member_id as registra7_2_1_,
  846. bookings0_.start_date as start_da5_2_1_,
  847. member1_.id as id1_8_2_,
  848. member1_.email as email2_8_2_,
  849. member1_.first_name as first_na3_8_2_,
  850. member1_.last_name as last_nam4_8_2_,
  851. member1_.password as password5_8_2_,
  852. member1_.role as role6_8_2_
  853. from
  854. webserver.booking bookings0_
  855. inner join
  856. webserver.member member1_
  857. on bookings0_.registration_member_id=member1_.id
  858. where
  859. bookings0_.paid_video_id=?
  860. 2019-03-02 17:56:57.789 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #11 delete.
  861. Hibernate:
  862. select
  863. shownvideo0_.booking_id as booking_3_11_0_,
  864. shownvideo0_.id as id1_11_0_,
  865. shownvideo0_.id as id1_11_1_,
  866. shownvideo0_.booking_id as booking_3_11_1_,
  867. shownvideo0_.datetime as datetime2_11_1_,
  868. shownvideo0_.device_id as device_i4_11_1_,
  869. device1_.id as id1_4_2_,
  870. device1_.location_id as location3_4_2_,
  871. device1_.uuid as uuid2_4_2_,
  872. location2_.id as id1_7_3_,
  873. location2_.max_device_count as max_devi2_7_3_,
  874. location2_.site_id as site_id4_7_3_,
  875. location2_.title as title3_7_3_,
  876. site3_.id as id1_12_4_,
  877. site3_.organization_id as organiza2_12_4_,
  878. organizati4_.id as id1_9_5_,
  879. organizati4_.registration_date_time as registra2_9_5_,
  880. organizati4_.registration_member_id as registra4_9_5_,
  881. organizati4_.title as title3_9_5_,
  882. member5_.id as id1_8_6_,
  883. member5_.email as email2_8_6_,
  884. member5_.first_name as first_na3_8_6_,
  885. member5_.last_name as last_nam4_8_6_,
  886. member5_.password as password5_8_6_,
  887. member5_.role as role6_8_6_,
  888. advertiser6_.id as id1_0_7_,
  889. advertiser6_.organization_id as organiza2_0_7_
  890. from
  891. webserver.shown_video shownvideo0_
  892. inner join
  893. webserver.device device1_
  894. on shownvideo0_.device_id=device1_.id
  895. inner join
  896. webserver.location location2_
  897. on device1_.location_id=location2_.id
  898. inner join
  899. webserver.site site3_
  900. on location2_.site_id=site3_.id
  901. inner join
  902. webserver.organization organizati4_
  903. on site3_.organization_id=organizati4_.id
  904. inner join
  905. webserver.member member5_
  906. on organizati4_.registration_member_id=member5_.id
  907. left outer join
  908. webserver.advertiser advertiser6_
  909. on organizati4_.id=advertiser6_.organization_id
  910. where
  911. shownvideo0_.booking_id=?
  912. 2019-03-02 17:56:57.792 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #11 delete.
  913. Hibernate:
  914. select
  915. bookings0_.paid_video_id as paid_vid6_2_0_,
  916. bookings0_.id as id1_2_0_,
  917. bookings0_.id as id1_2_1_,
  918. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  919. bookings0_.end_date as end_date3_2_1_,
  920. bookings0_.paid_video_id as paid_vid6_2_1_,
  921. bookings0_.registration_date_time as registra4_2_1_,
  922. bookings0_.registration_member_id as registra7_2_1_,
  923. bookings0_.start_date as start_da5_2_1_,
  924. member1_.id as id1_8_2_,
  925. member1_.email as email2_8_2_,
  926. member1_.first_name as first_na3_8_2_,
  927. member1_.last_name as last_nam4_8_2_,
  928. member1_.password as password5_8_2_,
  929. member1_.role as role6_8_2_
  930. from
  931. webserver.booking bookings0_
  932. inner join
  933. webserver.member member1_
  934. on bookings0_.registration_member_id=member1_.id
  935. where
  936. bookings0_.paid_video_id=?
  937. 2019-03-02 17:56:57.793 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #12 delete.
  938. Hibernate:
  939. select
  940. shownvideo0_.booking_id as booking_3_11_0_,
  941. shownvideo0_.id as id1_11_0_,
  942. shownvideo0_.id as id1_11_1_,
  943. shownvideo0_.booking_id as booking_3_11_1_,
  944. shownvideo0_.datetime as datetime2_11_1_,
  945. shownvideo0_.device_id as device_i4_11_1_,
  946. device1_.id as id1_4_2_,
  947. device1_.location_id as location3_4_2_,
  948. device1_.uuid as uuid2_4_2_,
  949. location2_.id as id1_7_3_,
  950. location2_.max_device_count as max_devi2_7_3_,
  951. location2_.site_id as site_id4_7_3_,
  952. location2_.title as title3_7_3_,
  953. site3_.id as id1_12_4_,
  954. site3_.organization_id as organiza2_12_4_,
  955. organizati4_.id as id1_9_5_,
  956. organizati4_.registration_date_time as registra2_9_5_,
  957. organizati4_.registration_member_id as registra4_9_5_,
  958. organizati4_.title as title3_9_5_,
  959. member5_.id as id1_8_6_,
  960. member5_.email as email2_8_6_,
  961. member5_.first_name as first_na3_8_6_,
  962. member5_.last_name as last_nam4_8_6_,
  963. member5_.password as password5_8_6_,
  964. member5_.role as role6_8_6_,
  965. advertiser6_.id as id1_0_7_,
  966. advertiser6_.organization_id as organiza2_0_7_
  967. from
  968. webserver.shown_video shownvideo0_
  969. inner join
  970. webserver.device device1_
  971. on shownvideo0_.device_id=device1_.id
  972. inner join
  973. webserver.location location2_
  974. on device1_.location_id=location2_.id
  975. inner join
  976. webserver.site site3_
  977. on location2_.site_id=site3_.id
  978. inner join
  979. webserver.organization organizati4_
  980. on site3_.organization_id=organizati4_.id
  981. inner join
  982. webserver.member member5_
  983. on organizati4_.registration_member_id=member5_.id
  984. left outer join
  985. webserver.advertiser advertiser6_
  986. on organizati4_.id=advertiser6_.organization_id
  987. where
  988. shownvideo0_.booking_id=?
  989. 2019-03-02 17:56:57.796 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #12 delete.
  990. Hibernate:
  991. select
  992. bookings0_.paid_video_id as paid_vid6_2_0_,
  993. bookings0_.id as id1_2_0_,
  994. bookings0_.id as id1_2_1_,
  995. bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
  996. bookings0_.end_date as end_date3_2_1_,
  997. bookings0_.paid_video_id as paid_vid6_2_1_,
  998. bookings0_.registration_date_time as registra4_2_1_,
  999. bookings0_.registration_member_id as registra7_2_1_,
  1000. bookings0_.start_date as start_da5_2_1_,
  1001. member1_.id as id1_8_2_,
  1002. member1_.email as email2_8_2_,
  1003. member1_.first_name as first_na3_8_2_,
  1004. member1_.last_name as last_nam4_8_2_,
  1005. member1_.password as password5_8_2_,
  1006. member1_.role as role6_8_2_
  1007. from
  1008. webserver.booking bookings0_
  1009. inner join
  1010. webserver.member member1_
  1011. on bookings0_.registration_member_id=member1_.id
  1012. where
  1013. bookings0_.paid_video_id=?
  1014. 2019-03-02 17:56:57.797 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #13 delete.
  1015. Hibernate:
  1016. select
  1017. shownvideo0_.booking_id as booking_3_11_0_,
  1018. shownvideo0_.id as id1_11_0_,
  1019. shownvideo0_.id as id1_11_1_,
  1020. shownvideo0_.booking_id as booking_3_11_1_,
  1021. shownvideo0_.datetime as datetime2_11_1_,
  1022. shownvideo0_.device_id as device_i4_11_1_,
  1023. device1_.id as id1_4_2_,
  1024. device1_.location_id as location3_4_2_,
  1025. device1_.uuid as uuid2_4_2_,
  1026. location2_.id as id1_7_3_,
  1027. location2_.max_device_count as max_devi2_7_3_,
  1028. location2_.site_id as site_id4_7_3_,
  1029. location2_.title as title3_7_3_,
  1030. site3_.id as id1_12_4_,
  1031. site3_.organization_id as organiza2_12_4_,
  1032. organizati4_.id as id1_9_5_,
  1033. organizati4_.registration_date_time as registra2_9_5_,
  1034. organizati4_.registration_member_id as registra4_9_5_,
  1035. organizati4_.title as title3_9_5_,
  1036. member5_.id as id1_8_6_,
  1037. member5_.email as email2_8_6_,
  1038. member5_.first_name as first_na3_8_6_,
  1039. member5_.last_name as last_nam4_8_6_,
  1040. member5_.password as password5_8_6_,
  1041. member5_.role as role6_8_6_,
  1042. advertiser6_.id as id1_0_7_,
  1043. advertiser6_.organization_id as organiza2_0_7_
  1044. from
  1045. webserver.shown_video shownvideo0_
  1046. inner join
  1047. webserver.device device1_
  1048. on shownvideo0_.device_id=device1_.id
  1049. inner join
  1050. webserver.location location2_
  1051. on device1_.location_id=location2_.id
  1052. inner join
  1053. webserver.site site3_
  1054. on location2_.site_id=site3_.id
  1055. inner join
  1056. webserver.organization organizati4_
  1057. on site3_.organization_id=organizati4_.id
  1058. inner join
  1059. webserver.member member5_
  1060. on organizati4_.registration_member_id=member5_.id
  1061. left outer join
  1062. webserver.advertiser advertiser6_
  1063. on organizati4_.id=advertiser6_.organization_id
  1064. where
  1065. shownvideo0_.booking_id=?
  1066. 2019-03-02 17:56:57.800 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #13 delete.
  1067. 2019-03-02 17:56:57.800 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Organizarion #1 delete.
  1068. Hibernate:
  1069. delete
  1070. from
  1071. webserver.advertiser
  1072. where
  1073. id=?
  1074. 2019-03-02 17:56:59.722 ERROR PopovDesktopLinux --- [nio-8080-exec-3] o.h.e.j.s.SqlExceptionHelper : ОШИБКА: UPDATE или DELETE в таблице "advertiser" нарушает ограничение внешнего ключа "fk1bg8w9qnonwguf6u4av8lgl5f" таблицы "paid_video"
  1075. Подробности: На ключ (id)=(1) всё ещё есть ссылки в таблице "paid_video".
  1076. 2019-03-02 17:56:59.724 ERROR PopovDesktopLinux --- [nio-8080-exec-3] o.h.i.ExceptionMapperStandardImpl : HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]
  1077. 2019-03-02 17:56:59.729 ERROR PopovDesktopLinux --- [nio-8080-exec-3] o.a.c.c.C.[.[.[.[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause
  1078. org.postgresql.util.PSQLException: ОШИБКА: UPDATE или DELETE в таблице "advertiser" нарушает ограничение внешнего ключа "fk1bg8w9qnonwguf6u4av8lgl5f" таблицы "paid_video"
  1079. Подробности: На ключ (id)=(1) всё ещё есть ссылки в таблице "paid_video".
  1080. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
  1081. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
  1082. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
  1083. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
  1084. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
  1085. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
  1086. at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120)
  1087. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
  1088. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
  1089. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
  1090. at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
  1091. at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3478)
  1092. at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3735)
  1093. at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:99)
  1094. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
  1095. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)
  1096. at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)
  1097. at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
  1098. at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454)
  1099. at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511)
  1100. at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283)
  1101. at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479)
  1102. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
  1103. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)
  1104. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)
  1105. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)
  1106. at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98)
  1107. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532)
  1108. at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
  1109. at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
  1110. at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:533)
  1111. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)
  1112. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  1113. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  1114. at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
  1115. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  1116. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  1117. at com.helan.adkiosk.backend.controllers.api.OrganizationController$$EnhancerBySpringCGLIB$$e89027d1.delete(<generated>)
  1118. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1119. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1120. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1121. at java.lang.reflect.Method.invoke(Method.java:498)
  1122. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
  1123. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  1124. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
  1125. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  1126. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
  1127. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1128. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
  1129. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  1130. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  1131. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
  1132. at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
  1133. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  1134. at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  1135. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  1136. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1137. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  1138. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1139. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1140. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
  1141. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1142. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1143. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
  1144. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  1145. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  1146. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1147. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
  1148. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1149. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  1150. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1151. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  1152. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1153. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  1154. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1155. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  1156. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1157. at com.helan.adkiosk.backend.security.TokenAuthenticationFilter.doFilterInternal(TokenAuthenticationFilter.java:64)
  1158. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1159. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1160. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  1161. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1162. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
  1163. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1164. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1165. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  1166. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1167. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  1168. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1169. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  1170. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
  1171. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
  1172. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
  1173. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
  1174. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1175. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1176. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  1177. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1178. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1179. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1180. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
  1181. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1182. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1183. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1184. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
  1185. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1186. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1187. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1188. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  1189. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1190. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1191. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1192. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
  1193. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  1194. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  1195. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  1196. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  1197. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  1198. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  1199. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  1200. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  1201. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
  1202. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417)
  1203. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  1204. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1205. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1206. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  1207. at java.lang.Thread.run(Thread.java:748)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement