API tools faq
paste
ronaldkwandy

Untitled

ronaldkwandy
Jul 21st, 2020
226
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.04 KB | None | 0 0
raw download clone embed print report
  1. 2020-07-21 12:01:40,220 6641860 [http-nio-8844-exec-2] DEBUG org.hibernate.SQL - create temporary table temp_hm_oat035_benar (
  2. hm_oat035_id varchar(100),
  3. total_benar int
  4. ) on commit drop
  5.  
  6. 2020-07-21 12:01:40,246 6641886 [http-nio-8844-exec-2] DEBUG org.hibernate.SQL - insert into temp_hm_oat035_benar
  7. select a.id, count(b.id)
  8. from hm_oat035 a
  9. left join hm_oat036 b on a.id = b.hm_oat035_id and b.error = false
  10. where 1 = 1
  11. group by a.id;
  12.  
  13. 2020-07-21 12:01:40,269 6641909 [http-nio-8844-exec-2] DEBUG org.hibernate.SQL - SELECT * FROM (
  14. SELECT COUNT(1) OVER (ORDER BY 1) AS DATA_COUNT,
  15. ROW_NUMBER() OVER (
  16. ORDER BY a.timestamp_transfer DESC) AS ROW_NUMBER,
  17. A.ID AS HM_OAT035_ID, B.NAMA AS NAMA_MESIN_ABSENSI, A.TIMESTAMP_TRANSFER, COUNT(C.ID) AS TOTAL_DATA, D.TOTAL_BENAR, (COUNT(C.ID) - D.TOTAL_BENAR) AS TOTAL_SALAH
  18. FROM HM_OAT035 A
  19. LEFT JOIN HM_MAT016 B ON A.HM_MAT016_MESIN_ABSENSI_ID = B.ID
  20. LEFT JOIN HM_OAT036 C ON A.ID = C.HM_OAT035_ID
  21. LEFT JOIN TEMP_HM_OAT035_BENAR D ON A.ID = D.HM_OAT035_ID
  22. WHERE 1 = 1
  23. GROUP BY A.ID, B.NAMA, A.TIMESTAMP_TRANSFER, D.TOTAL_BENAR
  24.  
  25. ORDER BY A.TIMESTAMP_TRANSFER DESC) X
  26. WHERE X.ROW_NUMBER BETWEEN ((? - 1) * ?) + 1 AND ? * ?
  27. 2020-07-21 12:01:40,294 6641934 [http-nio-8844-exec-2] DEBUG org.hibernate.loader.Loader - Result set row: 0
  28. 2020-07-21 12:01:40,294 6641934 [http-nio-8844-exec-2] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.domain.hris.attendance.data.hasiltransferotomatisdarimesinabsensi.entities.HasilTransferOtomatisDariMesinAbsensi#hm_oat035.001]
  29. 2020-07-21 12:01:40,294 6641934 [http-nio-8844-exec-2] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.domain.hris.attendance.data.hasiltransferotomatisdarimesinabsensi.entities.HasilTransferOtomatisDariMesinAbsensi#hm_oat035.001]
  30. 2020-07-21 12:01:40,294 6641934 [http-nio-8844-exec-2] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.domain.hris.attendance.data.hasiltransferotomatisdarimesinabsensi.entities.HasilTransferOtomatisDariMesinAbsensi#hm_oat035.001]
  31. 2020-07-21 12:01:40,295 6641935 [http-nio-8844-exec-2] DEBUG o.h.e.t.internal.TransactionImpl - committing
  32. 2020-07-21 12:01:40,295 6641935 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Processing flush-time cascades
  33. 2020-07-21 12:01:40,295 6641935 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Dirty checking collections
  34. 2020-07-21 12:01:40,295 6641935 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
  35. 2020-07-21 12:01:40,296 6641936 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
  36. 2020-07-21 12:01:40,296 6641936 [http-nio-8844-exec-2] DEBUG o.h.internal.util.EntityPrinter - Listing entities:
  37. 2020-07-21 12:01:40,296 6641936 [http-nio-8844-exec-2] DEBUG o.h.internal.util.EntityPrinter - id.co.sofcograha.gajiidapi.domain.hris.attendance.data.hasiltransferotomatisdarimesinabsensi.entities.HasilTransferOtomatisDariMesinAbsensi{totalData=2, totalSalah=0, timestampTransfer=2020-02-12 16:46:40.442218, namaMesinAbsensi=mesin 1, id=hm_oat035.001, totalBenar=2, dataCount=3}
  38. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.e.t.internal.TransactionImpl - begin
  39. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.e.t.internal.TransactionImpl - committing
  40. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Processing flush-time cascades
  41. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Dirty checking collections
  42. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
  43. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
  44. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.internal.util.EntityPrinter - Listing entities:
  45. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.internal.util.EntityPrinter - id.co.sofcograha.gajiidapi.domain.hris.attendance.data.hasiltransferotomatisdarimesinabsensi.entities.HasilTransferOtomatisDariMesinAbsensi{totalData=2, totalSalah=0, timestampTransfer=2020-02-12 16:46:40.442218, namaMesinAbsensi=mesin 1, id=hm_oat035.001, totalBenar=2, dataCount=3}
  46. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.e.t.internal.TransactionImpl - begin
  47. 2020-07-21 12:01:40,331 6641971 [http-nio-8844-exec-2] DEBUG o.h.e.t.internal.TransactionImpl - committing
  48. 2020-07-21 12:01:40,332 6641972 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Processing flush-time cascades
  49. 2020-07-21 12:01:40,332 6641972 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Dirty checking collections
  50. 2020-07-21 12:01:40,332 6641972 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
  51. 2020-07-21 12:01:40,332 6641972 [http-nio-8844-exec-2] DEBUG o.h.e.i.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
  52. 2020-07-21 12:01:40,332 6641972 [http-nio-8844-exec-2] DEBUG o.h.internal.util.EntityPrinter - Listing entities:
  53. 2020-07-21 12:01:40,332 6641972 [http-nio-8844-exec-2] DEBUG o.h.internal.util.EntityPrinter - id.co.sofcograha.gajiidapi.domain.hris.attendance.data.hasiltransferotomatisdarimesinabsensi.entities.HasilTransferOtomatisDariMesinAbsensi{totalData=2, totalSalah=0, timestampTransfer=2020-02-12 16:46:40.442218, namaMesinAbsensi=mesin 1, id=hm_oat035.001, totalBenar=2, dataCount=3}
  54. 2020-07-21 12:01:40,356 6641996 [http-nio-8844-exec-2] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Release connection with schema: c0000000|1576643790
  55. 2020-07-21 12:01:40,405 6642045 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.a.f.TokenAuthenticationFilter - Request is to process authentication
  56. 2020-07-21 12:01:40,432 6642072 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Get/Created connection with schema: c0000000|2026535091
  57. 2020-07-21 12:01:40,432 6642072 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Set Current schema to: C0000000
  58. 2020-07-21 12:01:40,479 6642119 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
  59. 2020-07-21 12:01:40,479 6642119 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - begin
  60. 2020-07-21 12:01:40,480 6642120 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select user0_.id as id1_42_, user0_.creation_time as creation2_42_, user0_.modification_time as modifica3_42_, user0_.user_create as user_cre4_42_, user0_.user_modify as user_mod5_42_, user0_.version as version6_42_, user0_.access_level as access_l7_42_, user0_.active as active8_42_, user0_.admin as admin9_42_, user0_.hm_msy002_id as hm_msy16_42_, user0_.email as email10_42_, user0_.locked as locked11_42_, user0_.name as name12_42_, user0_.password as passwor13_42_, user0_.phone_number as phone_n14_42_, user0_.username as usernam15_42_ from public.hm_msy004 user0_ where user0_.username=?
  61. 2020-07-21 12:01:40,506 6642146 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result set row: 0
  62. 2020-07-21 12:01:40,506 6642146 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f]
  63. 2020-07-21 12:01:40,506 6642146 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f]
  64. 2020-07-21 12:01:40,506 6642146 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select company0_.id as id1_40_0_, company0_.creation_time as creation2_40_0_, company0_.modification_time as modifica3_40_0_, company0_.user_create as user_cre4_40_0_, company0_.user_modify as user_mod5_40_0_, company0_.version as version6_40_0_, company0_.active as active7_40_0_, company0_.active_end_month as active_e8_40_0_, company0_.active_start_month as active_s9_40_0_, company0_.address as address10_40_0_, company0_.city as city11_40_0_, company0_.code as code12_40_0_, company0_.hm_msy001_id as hm_msy20_40_0_, company0_.email as email13_40_0_, company0_.name as name14_40_0_, company0_.note as note15_40_0_, company0_.phone_number as phone_n16_40_0_, company0_.pic_email as pic_ema17_40_0_, company0_.pic_name as pic_nam18_40_0_, company0_.pic_position as pic_pos19_40_0_, customer1_.id as id1_39_1_, customer1_.creation_time as creation2_39_1_, customer1_.modification_time as modifica3_39_1_, customer1_.user_create as user_cre4_39_1_, customer1_.user_modify as user_mod5_39_1_, customer1_.version as version6_39_1_, customer1_.active as active7_39_1_, customer1_.alamat as alamat8_39_1_, customer1_.batas_hari_jatuh_tempo as batas_ha9_39_1_, customer1_.code as code10_39_1_, customer1_.flag_jatuh_tempo as flag_ja11_39_1_, customer1_.name as name12_39_1_, customer1_.nomor_virtual_account as nomor_v13_39_1_, customer1_.pic as pic14_39_1_ from public.hm_msy002 company0_ left outer join public.hm_msy001 customer1_ on company0_.hm_msy001_id=customer1_.id where company0_.id=?
  65. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.ResultSetProcessorImpl - Starting ResultSet row #0
  66. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.EntityReferenceInitializerImpl - On call to EntityIdentifierReaderImpl#resolve, EntityKey was already known; should only happen on root returns with an optional identifier specified
  67. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  68. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  69. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  70. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  71. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.r.j.i.ResourceRegistryStandardImpl - HHH000387: ResultSet's statement was not registered
  72. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.l.e.p.AbstractLoadPlanBasedEntityLoader - Done entity load : id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99
  73. 2020-07-21 12:01:40,530 6642170 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f]
  74. 2020-07-21 12:01:40,531 6642171 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - committing
  75. 2020-07-21 12:01:40,832 6642472 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Release connection with schema: c0000000|2026535091
  76. 2020-07-21 12:01:40,862 6642502 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Get/Created connection with schema: c0000000|1822324588
  77. 2020-07-21 12:01:40,862 6642502 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Set Current schema to: C0000000
  78. 2020-07-21 12:01:40,916 6642556 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
  79. 2020-07-21 12:01:40,916 6642556 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - begin
  80. 2020-07-21 12:01:40,916 6642556 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select company0_.id as id1_40_, company0_.creation_time as creation2_40_, company0_.modification_time as modifica3_40_, company0_.user_create as user_cre4_40_, company0_.user_modify as user_mod5_40_, company0_.version as version6_40_, company0_.active as active7_40_, company0_.active_end_month as active_e8_40_, company0_.active_start_month as active_s9_40_, company0_.address as address10_40_, company0_.city as city11_40_, company0_.code as code12_40_, company0_.hm_msy001_id as hm_msy20_40_, company0_.email as email13_40_, company0_.name as name14_40_, company0_.note as note15_40_, company0_.phone_number as phone_n16_40_, company0_.pic_email as pic_ema17_40_, company0_.pic_name as pic_nam18_40_, company0_.pic_position as pic_pos19_40_ from public.hm_msy002 company0_ where company0_.code=?
  81. 2020-07-21 12:01:40,944 6642584 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result set row: 0
  82. 2020-07-21 12:01:40,944 6642584 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  83. 2020-07-21 12:01:40,944 6642584 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  84. 2020-07-21 12:01:40,944 6642584 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select customer0_.id as id1_39_0_, customer0_.creation_time as creation2_39_0_, customer0_.modification_time as modifica3_39_0_, customer0_.user_create as user_cre4_39_0_, customer0_.user_modify as user_mod5_39_0_, customer0_.version as version6_39_0_, customer0_.active as active7_39_0_, customer0_.alamat as alamat8_39_0_, customer0_.batas_hari_jatuh_tempo as batas_ha9_39_0_, customer0_.code as code10_39_0_, customer0_.flag_jatuh_tempo as flag_ja11_39_0_, customer0_.name as name12_39_0_, customer0_.nomor_virtual_account as nomor_v13_39_0_, customer0_.pic as pic14_39_0_ from public.hm_msy001 customer0_ where customer0_.id=?
  85. 2020-07-21 12:01:40,971 6642611 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.ResultSetProcessorImpl - Starting ResultSet row #0
  86. 2020-07-21 12:01:40,971 6642611 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.EntityReferenceInitializerImpl - On call to EntityIdentifierReaderImpl#resolve, EntityKey was already known; should only happen on root returns with an optional identifier specified
  87. 2020-07-21 12:01:40,971 6642611 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  88. 2020-07-21 12:01:40,971 6642611 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  89. 2020-07-21 12:01:40,971 6642611 [http-nio-8844-exec-7] DEBUG o.h.r.j.i.ResourceRegistryStandardImpl - HHH000387: ResultSet's statement was not registered
  90. 2020-07-21 12:01:40,971 6642611 [http-nio-8844-exec-7] DEBUG o.h.l.e.p.AbstractLoadPlanBasedEntityLoader - Done entity load : id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5
  91. 2020-07-21 12:01:40,971 6642611 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  92. 2020-07-21 12:01:40,972 6642612 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - committing
  93. 2020-07-21 12:01:41,057 6642697 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Release connection with schema: c0000000|1822324588
  94. 2020-07-21 12:01:41,087 6642727 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Get/Created connection with schema: c0000000|501481716
  95. 2020-07-21 12:01:41,087 6642727 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Set Current schema to: C0000000
  96. 2020-07-21 12:01:41,145 6642785 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
  97. 2020-07-21 12:01:41,145 6642785 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - begin
  98. 2020-07-21 12:01:41,145 6642785 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select usercompan0_.id as id1_43_, usercompan0_.creation_time as creation2_43_, usercompan0_.modification_time as modifica3_43_, usercompan0_.user_create as user_cre4_43_, usercompan0_.user_modify as user_mod5_43_, usercompan0_.version as version6_43_, usercompan0_.hm_msy002_id as hm_msy10_43_, usercompan0_.end_date as end_date7_43_, usercompan0_.start_date as start_da8_43_, usercompan0_.super_user as super_us9_43_, usercompan0_.hm_msy004_id as hm_msy11_43_ from public.hm_msy005 usercompan0_ cross join public.hm_msy002 company1_ where usercompan0_.hm_msy002_id=company1_.id and usercompan0_.hm_msy004_id=? and company1_.active=true and (? between usercompan0_.start_date and usercompan0_.end_date)
  99. 2020-07-21 12:01:41,201 6642841 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result set row: 0
  100. 2020-07-21 12:01:41,201 6642841 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#67263be6-6287-4e69-b74d-fb2d4c5c4506]
  101. 2020-07-21 12:01:41,202 6642842 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result set row: 1
  102. 2020-07-21 12:01:41,202 6642842 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#9864837d-8163-452f-b071-d833e7e39775]
  103. 2020-07-21 12:01:41,202 6642842 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result set row: 2
  104. 2020-07-21 12:01:41,202 6642842 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#a782418e-4a17-48f4-88be-0ec5e0dce062]
  105. 2020-07-21 12:01:41,202 6642842 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#67263be6-6287-4e69-b74d-fb2d4c5c4506]
  106. 2020-07-21 12:01:41,202 6642842 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select company0_.id as id1_40_0_, company0_.creation_time as creation2_40_0_, company0_.modification_time as modifica3_40_0_, company0_.user_create as user_cre4_40_0_, company0_.user_modify as user_mod5_40_0_, company0_.version as version6_40_0_, company0_.active as active7_40_0_, company0_.active_end_month as active_e8_40_0_, company0_.active_start_month as active_s9_40_0_, company0_.address as address10_40_0_, company0_.city as city11_40_0_, company0_.code as code12_40_0_, company0_.hm_msy001_id as hm_msy20_40_0_, company0_.email as email13_40_0_, company0_.name as name14_40_0_, company0_.note as note15_40_0_, company0_.phone_number as phone_n16_40_0_, company0_.pic_email as pic_ema17_40_0_, company0_.pic_name as pic_nam18_40_0_, company0_.pic_position as pic_pos19_40_0_, customer1_.id as id1_39_1_, customer1_.creation_time as creation2_39_1_, customer1_.modification_time as modifica3_39_1_, customer1_.user_create as user_cre4_39_1_, customer1_.user_modify as user_mod5_39_1_, customer1_.version as version6_39_1_, customer1_.active as active7_39_1_, customer1_.alamat as alamat8_39_1_, customer1_.batas_hari_jatuh_tempo as batas_ha9_39_1_, customer1_.code as code10_39_1_, customer1_.flag_jatuh_tempo as flag_ja11_39_1_, customer1_.name as name12_39_1_, customer1_.nomor_virtual_account as nomor_v13_39_1_, customer1_.pic as pic14_39_1_ from public.hm_msy002 company0_ left outer join public.hm_msy001 customer1_ on company0_.hm_msy001_id=customer1_.id where company0_.id=?
  107. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.ResultSetProcessorImpl - Starting ResultSet row #0
  108. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.EntityReferenceInitializerImpl - On call to EntityIdentifierReaderImpl#resolve, EntityKey was already known; should only happen on root returns with an optional identifier specified
  109. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#f8e46c4f-6cfc-42b0-89ad-e0679f445bd4]
  110. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#f8e46c4f-6cfc-42b0-89ad-e0679f445bd4]
  111. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  112. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  113. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG o.h.r.j.i.ResourceRegistryStandardImpl - HHH000387: ResultSet's statement was not registered
  114. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG o.h.l.e.p.AbstractLoadPlanBasedEntityLoader - Done entity load : id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#f8e46c4f-6cfc-42b0-89ad-e0679f445bd4
  115. 2020-07-21 12:01:41,232 6642872 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select user0_.id as id1_42_0_, user0_.creation_time as creation2_42_0_, user0_.modification_time as modifica3_42_0_, user0_.user_create as user_cre4_42_0_, user0_.user_modify as user_mod5_42_0_, user0_.version as version6_42_0_, user0_.access_level as access_l7_42_0_, user0_.active as active8_42_0_, user0_.admin as admin9_42_0_, user0_.hm_msy002_id as hm_msy16_42_0_, user0_.email as email10_42_0_, user0_.locked as locked11_42_0_, user0_.name as name12_42_0_, user0_.password as passwor13_42_0_, user0_.phone_number as phone_n14_42_0_, user0_.username as usernam15_42_0_, company1_.id as id1_40_1_, company1_.creation_time as creation2_40_1_, company1_.modification_time as modifica3_40_1_, company1_.user_create as user_cre4_40_1_, company1_.user_modify as user_mod5_40_1_, company1_.version as version6_40_1_, company1_.active as active7_40_1_, company1_.active_end_month as active_e8_40_1_, company1_.active_start_month as active_s9_40_1_, company1_.address as address10_40_1_, company1_.city as city11_40_1_, company1_.code as code12_40_1_, company1_.hm_msy001_id as hm_msy20_40_1_, company1_.email as email13_40_1_, company1_.name as name14_40_1_, company1_.note as note15_40_1_, company1_.phone_number as phone_n16_40_1_, company1_.pic_email as pic_ema17_40_1_, company1_.pic_name as pic_nam18_40_1_, company1_.pic_position as pic_pos19_40_1_, customer2_.id as id1_39_2_, customer2_.creation_time as creation2_39_2_, customer2_.modification_time as modifica3_39_2_, customer2_.user_create as user_cre4_39_2_, customer2_.user_modify as user_mod5_39_2_, customer2_.version as version6_39_2_, customer2_.active as active7_39_2_, customer2_.alamat as alamat8_39_2_, customer2_.batas_hari_jatuh_tempo as batas_ha9_39_2_, customer2_.code as code10_39_2_, customer2_.flag_jatuh_tempo as flag_ja11_39_2_, customer2_.name as name12_39_2_, customer2_.nomor_virtual_account as nomor_v13_39_2_, customer2_.pic as pic14_39_2_ from public.hm_msy004 user0_ left outer join public.hm_msy002 company1_ on user0_.hm_msy002_id=company1_.id left outer join public.hm_msy001 customer2_ on company1_.hm_msy001_id=customer2_.id where user0_.id=?
  116. 2020-07-21 12:01:41,265 6642905 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.ResultSetProcessorImpl - Starting ResultSet row #0
  117. 2020-07-21 12:01:41,265 6642905 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.EntityReferenceInitializerImpl - On call to EntityIdentifierReaderImpl#resolve, EntityKey was already known; should only happen on root returns with an optional identifier specified
  118. 2020-07-21 12:01:41,265 6642905 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f]
  119. 2020-07-21 12:01:41,266 6642906 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f]
  120. 2020-07-21 12:01:41,266 6642906 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  121. 2020-07-21 12:01:41,266 6642906 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  122. 2020-07-21 12:01:41,266 6642906 [http-nio-8844-exec-7] DEBUG o.h.r.j.i.ResourceRegistryStandardImpl - HHH000387: ResultSet's statement was not registered
  123. 2020-07-21 12:01:41,266 6642906 [http-nio-8844-exec-7] DEBUG o.h.l.e.p.AbstractLoadPlanBasedEntityLoader - Done entity load : id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f
  124. 2020-07-21 12:01:41,266 6642906 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#67263be6-6287-4e69-b74d-fb2d4c5c4506]
  125. 2020-07-21 12:01:41,266 6642906 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#9864837d-8163-452f-b071-d833e7e39775]
  126. 2020-07-21 12:01:41,266 6642906 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select company0_.id as id1_40_0_, company0_.creation_time as creation2_40_0_, company0_.modification_time as modifica3_40_0_, company0_.user_create as user_cre4_40_0_, company0_.user_modify as user_mod5_40_0_, company0_.version as version6_40_0_, company0_.active as active7_40_0_, company0_.active_end_month as active_e8_40_0_, company0_.active_start_month as active_s9_40_0_, company0_.address as address10_40_0_, company0_.city as city11_40_0_, company0_.code as code12_40_0_, company0_.hm_msy001_id as hm_msy20_40_0_, company0_.email as email13_40_0_, company0_.name as name14_40_0_, company0_.note as note15_40_0_, company0_.phone_number as phone_n16_40_0_, company0_.pic_email as pic_ema17_40_0_, company0_.pic_name as pic_nam18_40_0_, company0_.pic_position as pic_pos19_40_0_, customer1_.id as id1_39_1_, customer1_.creation_time as creation2_39_1_, customer1_.modification_time as modifica3_39_1_, customer1_.user_create as user_cre4_39_1_, customer1_.user_modify as user_mod5_39_1_, customer1_.version as version6_39_1_, customer1_.active as active7_39_1_, customer1_.alamat as alamat8_39_1_, customer1_.batas_hari_jatuh_tempo as batas_ha9_39_1_, customer1_.code as code10_39_1_, customer1_.flag_jatuh_tempo as flag_ja11_39_1_, customer1_.name as name12_39_1_, customer1_.nomor_virtual_account as nomor_v13_39_1_, customer1_.pic as pic14_39_1_ from public.hm_msy002 company0_ left outer join public.hm_msy001 customer1_ on company0_.hm_msy001_id=customer1_.id where company0_.id=?
  127. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.ResultSetProcessorImpl - Starting ResultSet row #0
  128. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.EntityReferenceInitializerImpl - On call to EntityIdentifierReaderImpl#resolve, EntityKey was already known; should only happen on root returns with an optional identifier specified
  129. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#6329744c-39c9-4c00-98f1-27aeeab3c7d5]
  130. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#6329744c-39c9-4c00-98f1-27aeeab3c7d5]
  131. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#4167e7e9-a950-41e7-b699-55551d400a45]
  132. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#4167e7e9-a950-41e7-b699-55551d400a45]
  133. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.r.j.i.ResourceRegistryStandardImpl - HHH000387: ResultSet's statement was not registered
  134. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.l.e.p.AbstractLoadPlanBasedEntityLoader - Done entity load : id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#6329744c-39c9-4c00-98f1-27aeeab3c7d5
  135. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#9864837d-8163-452f-b071-d833e7e39775]
  136. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#a782418e-4a17-48f4-88be-0ec5e0dce062]
  137. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.usercompany.entities.UserCompany#a782418e-4a17-48f4-88be-0ec5e0dce062]
  138. 2020-07-21 12:01:41,296 6642936 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - committing
  139. 2020-07-21 12:01:41,385 6643025 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Release connection with schema: c0000000|501481716
  140. 2020-07-21 12:01:41,385 6643025 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.TenantContext - Setting ACTIVE companyCode to (C0000000)
  141. 2020-07-21 12:01:41,422 6643062 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Get/Created connection with schema: c0000000|839074071
  142. 2020-07-21 12:01:41,422 6643062 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Set Current schema to: C0000000
  143. 2020-07-21 12:01:41,490 6643130 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
  144. 2020-07-21 12:01:41,490 6643130 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - begin
  145. 2020-07-21 12:01:41,490 6643130 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select functionac0_.id as id1_44_, functionac0_.creation_time as creation2_44_, functionac0_.modification_time as modifica3_44_, functionac0_.user_create as user_cre4_44_, functionac0_.user_modify as user_mod5_44_, functionac0_.version as version6_44_, functionac0_.active as active7_44_, functionac0_.admin as admin8_44_, functionac0_.code as code9_44_, functionac0_.description as descrip10_44_ from public.hm_msy007 functionac0_ where functionac0_.code=? and functionac0_.active=true
  146. 2020-07-21 12:01:41,527 6643167 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result set row: 0
  147. 2020-07-21 12:01:41,528 6643168 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.base.mst.functionaccess.entities.FunctionAccess#8ceedcf9-24ca-476a-aeda-8a87d54f5db9]
  148. 2020-07-21 12:01:41,528 6643168 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.functionaccess.entities.FunctionAccess#8ceedcf9-24ca-476a-aeda-8a87d54f5db9]
  149. 2020-07-21 12:01:41,528 6643168 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.functionaccess.entities.FunctionAccess#8ceedcf9-24ca-476a-aeda-8a87d54f5db9]
  150. 2020-07-21 12:01:41,528 6643168 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - committing
  151. 2020-07-21 12:01:41,639 6643279 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Release connection with schema: c0000000|839074071
  152. 2020-07-21 12:01:41,673 6643313 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Get/Created connection with schema: c0000000|207425999
  153. 2020-07-21 12:01:41,673 6643313 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Set Current schema to: C0000000
  154. 2020-07-21 12:01:41,740 6643380 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
  155. 2020-07-21 12:01:41,740 6643380 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - begin
  156. 2020-07-21 12:01:41,740 6643380 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select user0_.id as id1_42_0_, user0_.creation_time as creation2_42_0_, user0_.modification_time as modifica3_42_0_, user0_.user_create as user_cre4_42_0_, user0_.user_modify as user_mod5_42_0_, user0_.version as version6_42_0_, user0_.access_level as access_l7_42_0_, user0_.active as active8_42_0_, user0_.admin as admin9_42_0_, user0_.hm_msy002_id as hm_msy16_42_0_, user0_.email as email10_42_0_, user0_.locked as locked11_42_0_, user0_.name as name12_42_0_, user0_.password as passwor13_42_0_, user0_.phone_number as phone_n14_42_0_, user0_.username as usernam15_42_0_, company1_.id as id1_40_1_, company1_.creation_time as creation2_40_1_, company1_.modification_time as modifica3_40_1_, company1_.user_create as user_cre4_40_1_, company1_.user_modify as user_mod5_40_1_, company1_.version as version6_40_1_, company1_.active as active7_40_1_, company1_.active_end_month as active_e8_40_1_, company1_.active_start_month as active_s9_40_1_, company1_.address as address10_40_1_, company1_.city as city11_40_1_, company1_.code as code12_40_1_, company1_.hm_msy001_id as hm_msy20_40_1_, company1_.email as email13_40_1_, company1_.name as name14_40_1_, company1_.note as note15_40_1_, company1_.phone_number as phone_n16_40_1_, company1_.pic_email as pic_ema17_40_1_, company1_.pic_name as pic_nam18_40_1_, company1_.pic_position as pic_pos19_40_1_, customer2_.id as id1_39_2_, customer2_.creation_time as creation2_39_2_, customer2_.modification_time as modifica3_39_2_, customer2_.user_create as user_cre4_39_2_, customer2_.user_modify as user_mod5_39_2_, customer2_.version as version6_39_2_, customer2_.active as active7_39_2_, customer2_.alamat as alamat8_39_2_, customer2_.batas_hari_jatuh_tempo as batas_ha9_39_2_, customer2_.code as code10_39_2_, customer2_.flag_jatuh_tempo as flag_ja11_39_2_, customer2_.name as name12_39_2_, customer2_.nomor_virtual_account as nomor_v13_39_2_, customer2_.pic as pic14_39_2_ from public.hm_msy004 user0_ left outer join public.hm_msy002 company1_ on user0_.hm_msy002_id=company1_.id left outer join public.hm_msy001 customer2_ on company1_.hm_msy001_id=customer2_.id where user0_.id=?
  157. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.ResultSetProcessorImpl - Starting ResultSet row #0
  158. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.EntityReferenceInitializerImpl - On call to EntityIdentifierReaderImpl#resolve, EntityKey was already known; should only happen on root returns with an optional identifier specified
  159. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f]
  160. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f]
  161. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  162. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  163. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  164. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  165. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.r.j.i.ResourceRegistryStandardImpl - HHH000387: ResultSet's statement was not registered
  166. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.l.e.p.AbstractLoadPlanBasedEntityLoader - Done entity load : id.co.sofcograha.gajiidapi.base.mst.user.entities.User#a60e51c5-40fa-4663-bff4-f3314225665f
  167. 2020-07-21 12:01:41,774 6643414 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - committing
  168. 2020-07-21 12:01:41,871 6643511 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Release connection with schema: c0000000|207425999
  169. 2020-07-21 12:01:41,903 6643543 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Get/Created connection with schema: c0000000|1389809563
  170. 2020-07-21 12:01:41,903 6643543 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Set Current schema to: C0000000
  171. 2020-07-21 12:01:41,973 6643613 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
  172. 2020-07-21 12:01:41,973 6643613 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - begin
  173. 2020-07-21 12:01:41,973 6643613 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select company0_.id as id1_40_0_, company0_.creation_time as creation2_40_0_, company0_.modification_time as modifica3_40_0_, company0_.user_create as user_cre4_40_0_, company0_.user_modify as user_mod5_40_0_, company0_.version as version6_40_0_, company0_.active as active7_40_0_, company0_.active_end_month as active_e8_40_0_, company0_.active_start_month as active_s9_40_0_, company0_.address as address10_40_0_, company0_.city as city11_40_0_, company0_.code as code12_40_0_, company0_.hm_msy001_id as hm_msy20_40_0_, company0_.email as email13_40_0_, company0_.name as name14_40_0_, company0_.note as note15_40_0_, company0_.phone_number as phone_n16_40_0_, company0_.pic_email as pic_ema17_40_0_, company0_.pic_name as pic_nam18_40_0_, company0_.pic_position as pic_pos19_40_0_, customer1_.id as id1_39_1_, customer1_.creation_time as creation2_39_1_, customer1_.modification_time as modifica3_39_1_, customer1_.user_create as user_cre4_39_1_, customer1_.user_modify as user_mod5_39_1_, customer1_.version as version6_39_1_, customer1_.active as active7_39_1_, customer1_.alamat as alamat8_39_1_, customer1_.batas_hari_jatuh_tempo as batas_ha9_39_1_, customer1_.code as code10_39_1_, customer1_.flag_jatuh_tempo as flag_ja11_39_1_, customer1_.name as name12_39_1_, customer1_.nomor_virtual_account as nomor_v13_39_1_, customer1_.pic as pic14_39_1_ from public.hm_msy002 company0_ left outer join public.hm_msy001 customer1_ on company0_.hm_msy001_id=customer1_.id where company0_.id=?
  174. 2020-07-21 12:01:42,009 6643649 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.ResultSetProcessorImpl - Starting ResultSet row #0
  175. 2020-07-21 12:01:42,009 6643649 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.EntityReferenceInitializerImpl - On call to EntityIdentifierReaderImpl#resolve, EntityKey was already known; should only happen on root returns with an optional identifier specified
  176. 2020-07-21 12:01:42,009 6643649 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  177. 2020-07-21 12:01:42,010 6643650 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99]
  178. 2020-07-21 12:01:42,010 6643650 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  179. 2020-07-21 12:01:42,010 6643650 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.customer.entities.Customer#7d6ec653-10bd-41ca-ab91-0c91334d66e5]
  180. 2020-07-21 12:01:42,011 6643651 [http-nio-8844-exec-7] DEBUG o.h.r.j.i.ResourceRegistryStandardImpl - HHH000387: ResultSet's statement was not registered
  181. 2020-07-21 12:01:42,011 6643651 [http-nio-8844-exec-7] DEBUG o.h.l.e.p.AbstractLoadPlanBasedEntityLoader - Done entity load : id.co.sofcograha.gajiidapi.base.mst.company.entities.Company#705bce29-9b6e-4e10-a52a-e7dcfe4bcc99
  182. 2020-07-21 12:01:42,011 6643651 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - committing
  183. 2020-07-21 12:01:42,121 6643761 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Release connection with schema: c0000000|1389809563
  184. 2020-07-21 12:01:42,160 6643800 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Get/Created connection with schema: c0000000|1082171015
  185. 2020-07-21 12:01:42,161 6643801 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Set Current schema to: C0000000
  186. 2020-07-21 12:01:42,240 6643880 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
  187. 2020-07-21 12:01:42,240 6643880 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - begin
  188. 2020-07-21 12:01:42,240 6643880 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select companyfun0_.id as id1_45_, companyfun0_.creation_time as creation2_45_, companyfun0_.modification_time as modifica3_45_, companyfun0_.user_create as user_cre4_45_, companyfun0_.user_modify as user_mod5_45_, companyfun0_.version as version6_45_, companyfun0_.hm_msy002_id as hm_msy7_45_, companyfun0_.hm_msy007_id as hm_msy8_45_ from public.hm_msy008 companyfun0_ where (companyfun0_.hm_msy002_id=? or companyfun0_.hm_msy002_id is null) and companyfun0_.hm_msy007_id=?
  189. 2020-07-21 12:01:42,278 6643918 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result set row: 0
  190. 2020-07-21 12:01:42,279 6643919 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.base.mst.companyfunctionaccess.entities.CompanyFunctionAccess#78f66d7d-9233-402a-b435-45cacfe2f346]
  191. 2020-07-21 12:01:42,279 6643919 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result set row: 1
  192. 2020-07-21 12:01:42,279 6643919 [http-nio-8844-exec-7] DEBUG org.hibernate.loader.Loader - Result row: EntityKey[id.co.sofcograha.gajiidapi.base.mst.companyfunctionaccess.entities.CompanyFunctionAccess#c875f7b6-e46a-433f-9840-71a9af4dd9b5]
  193. 2020-07-21 12:01:42,279 6643919 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.companyfunctionaccess.entities.CompanyFunctionAccess#78f66d7d-9233-402a-b435-45cacfe2f346]
  194. 2020-07-21 12:01:42,279 6643919 [http-nio-8844-exec-7] DEBUG org.hibernate.SQL - select functionac0_.id as id1_44_0_, functionac0_.creation_time as creation2_44_0_, functionac0_.modification_time as modifica3_44_0_, functionac0_.user_create as user_cre4_44_0_, functionac0_.user_modify as user_mod5_44_0_, functionac0_.version as version6_44_0_, functionac0_.active as active7_44_0_, functionac0_.admin as admin8_44_0_, functionac0_.code as code9_44_0_, functionac0_.description as descrip10_44_0_ from public.hm_msy007 functionac0_ where functionac0_.id=?
  195. 2020-07-21 12:01:42,317 6643957 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.ResultSetProcessorImpl - Starting ResultSet row #0
  196. 2020-07-21 12:01:42,317 6643957 [http-nio-8844-exec-7] DEBUG o.h.l.p.e.p.i.EntityReferenceInitializerImpl - On call to EntityIdentifierReaderImpl#resolve, EntityKey was already known; should only happen on root returns with an optional identifier specified
  197. 2020-07-21 12:01:42,317 6643957 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.functionaccess.entities.FunctionAccess#8ceedcf9-24ca-476a-aeda-8a87d54f5db9]
  198. 2020-07-21 12:01:42,317 6643957 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.functionaccess.entities.FunctionAccess#8ceedcf9-24ca-476a-aeda-8a87d54f5db9]
  199. 2020-07-21 12:01:42,317 6643957 [http-nio-8844-exec-7] DEBUG o.h.r.j.i.ResourceRegistryStandardImpl - HHH000387: ResultSet's statement was not registered
  200. 2020-07-21 12:01:42,317 6643957 [http-nio-8844-exec-7] DEBUG o.h.l.e.p.AbstractLoadPlanBasedEntityLoader - Done entity load : id.co.sofcograha.gajiidapi.base.mst.functionaccess.entities.FunctionAccess#8ceedcf9-24ca-476a-aeda-8a87d54f5db9
  201. 2020-07-21 12:01:42,318 6643958 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.companyfunctionaccess.entities.CompanyFunctionAccess#78f66d7d-9233-402a-b435-45cacfe2f346]
  202. 2020-07-21 12:01:42,318 6643958 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Resolving associations for [id.co.sofcograha.gajiidapi.base.mst.companyfunctionaccess.entities.CompanyFunctionAccess#c875f7b6-e46a-433f-9840-71a9af4dd9b5]
  203. 2020-07-21 12:01:42,318 6643958 [http-nio-8844-exec-7] DEBUG o.h.engine.internal.TwoPhaseLoad - Done materializing entity [id.co.sofcograha.gajiidapi.base.mst.companyfunctionaccess.entities.CompanyFunctionAccess#c875f7b6-e46a-433f-9840-71a9af4dd9b5]
  204. 2020-07-21 12:01:42,319 6643959 [http-nio-8844-exec-7] DEBUG o.h.e.t.internal.TransactionImpl - rolling back
  205. 2020-07-21 12:01:42,425 6644065 [http-nio-8844-exec-7] DEBUG i.c.s.g.b.m.MultiTenantConnectionProviderImpl - Release connection with schema: c0000000|1082171015
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!