Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Hibernate:
- select
- organizati0_.id as id1_9_0_,
- organizati0_.registration_date_time as registra2_9_0_,
- organizati0_.registration_member_id as registra4_9_0_,
- organizati0_.title as title3_9_0_,
- member1_.id as id1_8_1_,
- member1_.email as email2_8_1_,
- member1_.first_name as first_na3_8_1_,
- member1_.last_name as last_nam4_8_1_,
- member1_.password as password5_8_1_,
- member1_.role as role6_8_1_,
- advertiser2_.id as id1_0_2_,
- advertiser2_.organization_id as organiza2_0_2_,
- site3_.id as id1_12_3_,
- site3_.organization_id as organiza2_12_3_
- from
- webserver.organization organizati0_
- inner join
- webserver.member member1_
- on organizati0_.registration_member_id=member1_.id
- left outer join
- webserver.advertiser advertiser2_
- on organizati0_.id=advertiser2_.organization_id
- left outer join
- webserver.site site3_
- on organizati0_.id=site3_.organization_id
- where
- organizati0_.id=?
- Hibernate:
- select
- paidvideos0_.advertiser as advertis2_10_0_,
- paidvideos0_.id as id1_10_0_,
- paidvideos0_.id as id1_10_1_,
- paidvideos0_.advertiser as advertis2_10_1_,
- paidvideos0_.video_id as video_id3_10_1_,
- video1_.id as id1_14_2_,
- video1_.duration as duration2_14_2_,
- video1_.extension as extensio3_14_2_,
- video1_.md5sum as md4_14_2_,
- video1_.size as size5_14_2_,
- video1_.title as title6_14_2_,
- video1_.uploaded_date_time as uploaded7_14_2_,
- video1_.uploaded_member_id as uploaded8_14_2_,
- member2_.id as id1_8_3_,
- member2_.email as email2_8_3_,
- member2_.first_name as first_na3_8_3_,
- member2_.last_name as last_nam4_8_3_,
- member2_.password as password5_8_3_,
- member2_.role as role6_8_3_,
- freevideo3_.id as id1_6_4_,
- freevideo3_.video_id as video_id2_6_4_
- from
- webserver.paid_video paidvideos0_
- inner join
- webserver.video video1_
- on paidvideos0_.video_id=video1_.id
- inner join
- webserver.member member2_
- on video1_.uploaded_member_id=member2_.id
- left outer join
- webserver.free_video freevideo3_
- on video1_.id=freevideo3_.video_id
- where
- paidvideos0_.advertiser=?
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.696 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #1 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.717 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #1 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.720 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #2 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.728 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #2 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.731 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #3 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.738 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #3 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.740 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #4 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.745 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #4 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.748 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #5 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.753 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #5 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.757 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #6 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.762 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #6 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.764 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #7 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.769 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #7 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.771 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #8 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.775 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #8 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.778 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #9 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.782 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #9 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.784 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #10 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.788 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #10 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.789 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #11 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.792 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #11 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.793 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #12 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.796 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #12 delete.
- Hibernate:
- select
- bookings0_.paid_video_id as paid_vid6_2_0_,
- bookings0_.id as id1_2_0_,
- bookings0_.id as id1_2_1_,
- bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
- bookings0_.end_date as end_date3_2_1_,
- bookings0_.paid_video_id as paid_vid6_2_1_,
- bookings0_.registration_date_time as registra4_2_1_,
- bookings0_.registration_member_id as registra7_2_1_,
- bookings0_.start_date as start_da5_2_1_,
- member1_.id as id1_8_2_,
- member1_.email as email2_8_2_,
- member1_.first_name as first_na3_8_2_,
- member1_.last_name as last_nam4_8_2_,
- member1_.password as password5_8_2_,
- member1_.role as role6_8_2_
- from
- webserver.booking bookings0_
- inner join
- webserver.member member1_
- on bookings0_.registration_member_id=member1_.id
- where
- bookings0_.paid_video_id=?
- 2019-03-02 17:56:57.797 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Booking #13 delete.
- Hibernate:
- select
- shownvideo0_.booking_id as booking_3_11_0_,
- shownvideo0_.id as id1_11_0_,
- shownvideo0_.id as id1_11_1_,
- shownvideo0_.booking_id as booking_3_11_1_,
- shownvideo0_.datetime as datetime2_11_1_,
- shownvideo0_.device_id as device_i4_11_1_,
- device1_.id as id1_4_2_,
- device1_.location_id as location3_4_2_,
- device1_.uuid as uuid2_4_2_,
- location2_.id as id1_7_3_,
- location2_.max_device_count as max_devi2_7_3_,
- location2_.site_id as site_id4_7_3_,
- location2_.title as title3_7_3_,
- site3_.id as id1_12_4_,
- site3_.organization_id as organiza2_12_4_,
- organizati4_.id as id1_9_5_,
- organizati4_.registration_date_time as registra2_9_5_,
- organizati4_.registration_member_id as registra4_9_5_,
- organizati4_.title as title3_9_5_,
- member5_.id as id1_8_6_,
- member5_.email as email2_8_6_,
- member5_.first_name as first_na3_8_6_,
- member5_.last_name as last_nam4_8_6_,
- member5_.password as password5_8_6_,
- member5_.role as role6_8_6_,
- advertiser6_.id as id1_0_7_,
- advertiser6_.organization_id as organiza2_0_7_
- from
- webserver.shown_video shownvideo0_
- inner join
- webserver.device device1_
- on shownvideo0_.device_id=device1_.id
- inner join
- webserver.location location2_
- on device1_.location_id=location2_.id
- inner join
- webserver.site site3_
- on location2_.site_id=site3_.id
- inner join
- webserver.organization organizati4_
- on site3_.organization_id=organizati4_.id
- inner join
- webserver.member member5_
- on organizati4_.registration_member_id=member5_.id
- left outer join
- webserver.advertiser advertiser6_
- on organizati4_.id=advertiser6_.organization_id
- where
- shownvideo0_.booking_id=?
- 2019-03-02 17:56:57.800 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : PaidVideo #13 delete.
- 2019-03-02 17:56:57.800 DEBUG PopovDesktopLinux --- [nio-8080-exec-3] c.h.a.b.c.a.OrganizationController : Organizarion #1 delete.
- Hibernate:
- delete
- from
- webserver.advertiser
- where
- id=?
- 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"
- Подробности: На ключ (id)=(1) всё ещё есть ссылки в таблице "paid_video".
- 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]
- 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
- org.postgresql.util.PSQLException: ОШИБКА: UPDATE или DELETE в таблице "advertiser" нарушает ограничение внешнего ключа "fk1bg8w9qnonwguf6u4av8lgl5f" таблицы "paid_video"
- Подробности: На ключ (id)=(1) всё ещё есть ссылки в таблице "paid_video".
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
- at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120)
- at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
- at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
- at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
- at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
- at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3478)
- at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3735)
- at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:99)
- at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
- at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)
- at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)
- at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
- at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454)
- at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511)
- at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283)
- at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479)
- at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
- at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)
- at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)
- at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)
- at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98)
- at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532)
- at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
- at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
- at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:533)
- at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)
- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
- at com.helan.adkiosk.backend.controllers.api.OrganizationController$$EnhancerBySpringCGLIB$$e89027d1.delete(<generated>)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
- at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
- at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
- at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at com.helan.adkiosk.backend.security.TokenAuthenticationFilter.doFilterInternal(TokenAuthenticationFilter.java:64)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
- at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
- at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
- at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
- at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement