Skip to content

Console Output

Skipping 634 KB.. Full Log
D','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_report_strategy_entity add constraint FKktfiy86djtvw20h6565fl76bq foreign key (id) references report_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_event_report_strategy_entity add constraint FKsdm20588vdyki7ca5bfpu4ohi foreign key (id) references report_strategy_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FK6jux60r77sw05uia08u9dvsm4 foreign key (reported_user_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKe07325of08t46hkil1uoc038i foreign key (reporter_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists return_report_strategy_entity add constraint FKjsru2p38nruuct0fu1q64p5lu foreign key (id) references report_strategy_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FK4125j8wt2ul4p4dv9f57atjxq foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FKckoo8jnsf7bkp8kceutmrg31h foreign key (user_id) references user_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-03-23T20:06:07.415Z  INFO 71 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T20:06:07.533Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationServiceTest : Started TrialCohabitationServiceTest in 0.365 seconds (process running for 22.135)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.541Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 4
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.549Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.555Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting process to consult trial cohabitation with id = 999
Hibernate: select tce1_0.id,a1_0.id,a2_0.id,a2_1.email,a2_1.name,a2_1.password,a2_1.phone,a2_0.has_children,a2_0.has_other_pets,a2_0.housing_type,a1_0.adoption_date,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,mh1_0.id,mh1_0.description,mh1_0.last_checkout,mh1_0.notes,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament,a1_0.status,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0 left join adoption_entity a1_0 on a1_0.id=tce1_0.adoption_id left join adopter_entity a2_0 on a2_0.id=a1_0.adopter_id left join user_entity a2_1 on a2_0.id=a2_1.id left join pet_entity p1_0 on p1_0.id=a1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id where tce1_0.id=?
2026-03-23T20:06:07.556Z ERROR 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with id 999 not found
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.562Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.569Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 17
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.575Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 21
2026-03-23T20:06:07.576Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with id = 21 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.582Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 22
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.588Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 999
Hibernate: select tce1_0.id,a1_0.id,a2_0.id,a2_1.email,a2_1.name,a2_1.password,a2_1.phone,a2_0.has_children,a2_0.has_other_pets,a2_0.housing_type,a1_0.adoption_date,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,mh1_0.id,mh1_0.description,mh1_0.last_checkout,mh1_0.notes,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament,a1_0.status,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0 left join adoption_entity a1_0 on a1_0.id=tce1_0.adoption_id left join adopter_entity a2_0 on a2_0.id=a1_0.adopter_id left join user_entity a2_1 on a2_0.id=a2_1.id left join pet_entity p1_0 on p1_0.id=a1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id where tce1_0.id=?
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.596Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 31
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.602Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting process to consult all trial cohabitations
Hibernate: select tce1_0.id,tce1_0.adoption_id,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.609Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.615Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting deletion process for trial cohabitation ID: 41
2026-03-23T20:06:07.617Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with ID: 41 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.622Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 42
2026-03-23T20:06:07.623Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with id = 42 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.629Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting deletion process for trial cohabitation ID: 48
2026-03-23T20:06:07.629Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with ID: 48 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.636Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting deletion process for trial cohabitation ID: 52
2026-03-23T20:06:07.636Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with ID: 52 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.643Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.648Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting deletion process for trial cohabitation ID: 59
2026-03-23T20:06:07.649Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with ID: 59 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.655Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 60
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.661Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
2026-03-23T20:06:07.661Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.666Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
2026-03-23T20:06:07.666Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.672Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting deletion process for trial cohabitation ID: 74
2026-03-23T20:06:07.673Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with ID: 74 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.679Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting deletion process for trial cohabitation ID: 78
2026-03-23T20:06:07.679Z  WARN 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Attempted to delete trial cohabitation 78 but it is in progress
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.684Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.689Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting process to consult trial cohabitation with id = 82
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.695Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting deletion process for trial cohabitation ID: 999
Hibernate: select tce1_0.id,a1_0.id,a2_0.id,a2_1.email,a2_1.name,a2_1.password,a2_1.phone,a2_0.has_children,a2_0.has_other_pets,a2_0.housing_type,a1_0.adoption_date,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,mh1_0.id,mh1_0.description,mh1_0.last_checkout,mh1_0.notes,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament,a1_0.status,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0 left join adoption_entity a1_0 on a1_0.id=tce1_0.adoption_id left join adopter_entity a2_0 on a2_0.id=a1_0.adopter_id left join user_entity a2_1 on a2_0.id=a2_1.id left join pet_entity p1_0 on p1_0.id=a1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id where tce1_0.id=?
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.701Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
2026-03-23T20:06:07.701Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.706Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 95
2026-03-23T20:06:07.707Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with id = 95 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.713Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 99
2026-03-23T20:06:07.713Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with id = 99 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.718Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.724Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 106
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T20:06:07.750Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Starting update process for trial cohabitation with id = 107
2026-03-23T20:06:07.751Z  INFO 71 --- [           main] c.e.u.m.p.s.TrialCohabitationService     : Trial cohabitation with id = 107 updated successfully
[INFO] Tests run: 31, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.593 s -- in co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ReportServiceTest
2026-03-23T20:06:07.755Z  INFO 71 --- [           main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.ReportServiceTest]: ReportServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T20:06:07.759Z  INFO 71 --- [           main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.ReportServiceTest

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/

 :: Spring Boot ::               (v3.5.10)

2026-03-23T20:06:07.772Z  INFO 71 --- [           main] c.e.u.m.pets.services.ReportServiceTest  : Starting ReportServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-23T20:06:07.772Z  INFO 71 --- [           main] c.e.u.m.pets.services.ReportServiceTest  : No active profile set, falling back to 1 default profile: "default"
2026-03-23T20:06:07.819Z  INFO 71 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T20:06:07.835Z  INFO 71 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 15 ms. Found 20 JPA repository interfaces.
2026-03-23T20:06:07.846Z  INFO 71 --- [           main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T20:06:07.855Z  INFO 71 --- [           main] o.s.j.d.e.EmbeddedDatabaseFactory        : Starting embedded database: url='jdbc:h2:mem:2adfa132-5b30-4875-94a1-1c4d6f2c9411;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T20:06:07.867Z  INFO 71 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T20:06:07.869Z  INFO 71 --- [           main] o.h.c.internal.RegionFactoryInitiator    : HHH000026: Second-level cache disabled
2026-03-23T20:06:07.875Z  INFO 71 --- [           main] o.s.o.j.p.SpringPersistenceUnitInfo      : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T20:06:07.876Z  WARN 71 --- [           main] org.hibernate.orm.deprecation            : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-23T20:06:07.877Z  INFO 71 --- [           main] org.hibernate.orm.connections.pooling    : HHH10001005: Database info:
	Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@457ca071']
	Database driver: undefined/unknown
	Database version: 2.3.232
	Autocommit mode: undefined/unknown
	Isolation level: undefined/unknown
	Minimum pool size: undefined/unknown
	Maximum pool size: undefined/unknown
Hibernate: create global temporary table HT_report_strategy_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_medical_event_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_return_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-03-23T20:06:07.978Z  INFO 71 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (follow_up_date date, adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_event_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, reported_user_id bigint, reporter_id bigint, shelter_id bigint, strategy_id bigint, reason varchar(255), status enum ('PENDING','RESOLVED','REVIEWED'), primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table return_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table subscription_entity (active boolean, id bigint generated by default as identity, shelter_id bigint, user_id bigint, primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_report_strategy_entity add constraint FKktfiy86djtvw20h6565fl76bq foreign key (id) references report_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_event_report_strategy_entity add constraint FKsdm20588vdyki7ca5bfpu4ohi foreign key (id) references report_strategy_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FK6jux60r77sw05uia08u9dvsm4 foreign key (reported_user_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKe07325of08t46hkil1uoc038i foreign key (reporter_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists return_report_strategy_entity add constraint FKjsru2p38nruuct0fu1q64p5lu foreign key (id) references report_strategy_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FK4125j8wt2ul4p4dv9f57atjxq foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FKckoo8jnsf7bkp8kceutmrg31h foreign key (user_id) references user_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-03-23T20:06:08.000Z  INFO 71 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T20:06:08.113Z  INFO 71 --- [           main] c.e.u.m.pets.services.ReportServiceTest  : Started ReportServiceTest in 0.352 seconds (process running for 22.715)
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_strategy_entity (id) values (default)
Hibernate: insert into medical_event_report_strategy_entity (id) values (?)
2026-03-23T20:06:08.120Z  INFO 71 --- [           main] c.e.u.mdp.pets.services.ReportService    : Creando reporte
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: delete from report_entity re1_0
Hibernate: insert into report_strategy_entity (id) values (default)
Hibernate: insert into return_report_strategy_entity (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0 where re1_0.strategy_id=?
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: select rse1_0.id,case when rse1_1.id is not null then 1 when rse1_2.id is not null then 2 when rse1_3.id is not null then 3 end from report_strategy_entity rse1_0 left join adoption_report_strategy_entity rse1_1 on rse1_0.id=rse1_1.id left join medical_event_report_strategy_entity rse1_2 on rse1_0.id=rse1_2.id left join return_report_strategy_entity rse1_3 on rse1_0.id=rse1_3.id where rse1_0.id=?
Hibernate: delete from report_entity re1_0
2026-03-23T20:06:08.143Z  INFO 71 --- [           main] c.e.u.mdp.pets.services.ReportService    : Creando reporte
2026-03-23T20:06:08.143Z  INFO 71 --- [           main] c.e.u.mdp.pets.services.ReportService    : Creando reporte
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
2026-03-23T20:06:08.144Z  INFO 71 --- [           main] c.e.u.mdp.pets.services.ReportService    : Creando reporte
Hibernate: delete from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
2026-03-23T20:06:08.157Z  INFO 71 --- [           main] c.e.u.mdp.pets.services.ReportService    : Eliminando reporte con id: 5
Hibernate: delete from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,rs1_0.id,case when rs1_1.id is not null then 1 when rs1_2.id is not null then 2 when rs1_3.id is not null then 3 end,ru1_0.id,case when ru1_3.id is not null then 1 when ru1_1.id is not null then 2 when ru1_2.id is not null then 3 end,ru1_0.email,ru1_0.name,ru1_0.password,ru1_0.phone,ru1_1.has_children,ru1_1.has_other_pets,ru1_1.housing_type,ru1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ru1_2.specialty,r1_0.id,case when r1_3.id is not null then 1 when r1_1.id is not null then 2 when r1_2.id is not null then 3 end,r1_0.email,r1_0.name,r1_0.password,r1_0.phone,r1_1.has_children,r1_1.has_other_pets,r1_1.housing_type,r1_2.availability,s2_0.id,s2_0.city,s2_0.description,s2_0.email,s2_0.gallery,s2_0.name,r1_2.specialty,s3_0.id,s3_0.city,s3_0.description,s3_0.email,s3_0.gallery,s3_0.name,re1_0.status from report_entity re1_0 left join report_strategy_entity rs1_0 on rs1_0.id=re1_0.strategy_id left join adoption_report_strategy_entity rs1_1 on rs1_0.id=rs1_1.id left join medical_event_report_strategy_entity rs1_2 on rs1_0.id=rs1_2.id left join return_report_strategy_entity rs1_3 on rs1_0.id=rs1_3.id left join user_entity ru1_0 on ru1_0.id=re1_0.reported_user_id left join adopter_entity ru1_1 on ru1_0.id=ru1_1.id left join veterinarian_entity ru1_2 on ru1_0.id=ru1_2.id left join mock_user ru1_3 on ru1_0.id=ru1_3.id left join shelter_entity s1_0 on s1_0.id=ru1_2.shelter_id left join user_entity r1_0 on r1_0.id=re1_0.reporter_id left join adopter_entity r1_1 on r1_0.id=r1_1.id left join veterinarian_entity r1_2 on r1_0.id=r1_2.id left join mock_user r1_3 on r1_0.id=r1_3.id left join shelter_entity s2_0 on s2_0.id=r1_2.shelter_id left join shelter_entity s3_0 on s3_0.id=re1_0.shelter_id where re1_0.id=?
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: delete from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,rs1_0.id,case when rs1_1.id is not null then 1 when rs1_2.id is not null then 2 when rs1_3.id is not null then 3 end,ru1_0.id,case when ru1_3.id is not null then 1 when ru1_1.id is not null then 2 when ru1_2.id is not null then 3 end,ru1_0.email,ru1_0.name,ru1_0.password,ru1_0.phone,ru1_1.has_children,ru1_1.has_other_pets,ru1_1.housing_type,ru1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ru1_2.specialty,r1_0.id,case when r1_3.id is not null then 1 when r1_1.id is not null then 2 when r1_2.id is not null then 3 end,r1_0.email,r1_0.name,r1_0.password,r1_0.phone,r1_1.has_children,r1_1.has_other_pets,r1_1.housing_type,r1_2.availability,s2_0.id,s2_0.city,s2_0.description,s2_0.email,s2_0.gallery,s2_0.name,r1_2.specialty,s3_0.id,s3_0.city,s3_0.description,s3_0.email,s3_0.gallery,s3_0.name,re1_0.status from report_entity re1_0 left join report_strategy_entity rs1_0 on rs1_0.id=re1_0.strategy_id left join adoption_report_strategy_entity rs1_1 on rs1_0.id=rs1_1.id left join medical_event_report_strategy_entity rs1_2 on rs1_0.id=rs1_2.id left join return_report_strategy_entity rs1_3 on rs1_0.id=rs1_3.id left join user_entity ru1_0 on ru1_0.id=re1_0.reported_user_id left join adopter_entity ru1_1 on ru1_0.id=ru1_1.id left join veterinarian_entity ru1_2 on ru1_0.id=ru1_2.id left join mock_user ru1_3 on ru1_0.id=ru1_3.id left join shelter_entity s1_0 on s1_0.id=ru1_2.shelter_id left join user_entity r1_0 on r1_0.id=re1_0.reporter_id left join adopter_entity r1_1 on r1_0.id=r1_1.id left join veterinarian_entity r1_2 on r1_0.id=r1_2.id left join mock_user r1_3 on r1_0.id=r1_3.id left join shelter_entity s2_0 on s2_0.id=r1_2.shelter_id left join shelter_entity s3_0 on s3_0.id=re1_0.shelter_id where re1_0.id=?
Hibernate: delete from report_entity re1_0
2026-03-23T20:06:08.176Z  INFO 71 --- [           main] c.e.u.mdp.pets.services.ReportService    : Eliminando reporte con id: 999
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,rs1_0.id,case when rs1_1.id is not null then 1 when rs1_2.id is not null then 2 when rs1_3.id is not null then 3 end,ru1_0.id,case when ru1_3.id is not null then 1 when ru1_1.id is not null then 2 when ru1_2.id is not null then 3 end,ru1_0.email,ru1_0.name,ru1_0.password,ru1_0.phone,ru1_1.has_children,ru1_1.has_other_pets,ru1_1.housing_type,ru1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ru1_2.specialty,r1_0.id,case when r1_3.id is not null then 1 when r1_1.id is not null then 2 when r1_2.id is not null then 3 end,r1_0.email,r1_0.name,r1_0.password,r1_0.phone,r1_1.has_children,r1_1.has_other_pets,r1_1.housing_type,r1_2.availability,s2_0.id,s2_0.city,s2_0.description,s2_0.email,s2_0.gallery,s2_0.name,r1_2.specialty,s3_0.id,s3_0.city,s3_0.description,s3_0.email,s3_0.gallery,s3_0.name,re1_0.status from report_entity re1_0 left join report_strategy_entity rs1_0 on rs1_0.id=re1_0.strategy_id left join adoption_report_strategy_entity rs1_1 on rs1_0.id=rs1_1.id left join medical_event_report_strategy_entity rs1_2 on rs1_0.id=rs1_2.id left join return_report_strategy_entity rs1_3 on rs1_0.id=rs1_3.id left join user_entity ru1_0 on ru1_0.id=re1_0.reported_user_id left join adopter_entity ru1_1 on ru1_0.id=ru1_1.id left join veterinarian_entity ru1_2 on ru1_0.id=ru1_2.id left join mock_user ru1_3 on ru1_0.id=ru1_3.id left join shelter_entity s1_0 on s1_0.id=ru1_2.shelter_id left join user_entity r1_0 on r1_0.id=re1_0.reporter_id left join adopter_entity r1_1 on r1_0.id=r1_1.id left join veterinarian_entity r1_2 on r1_0.id=r1_2.id left join mock_user r1_3 on r1_0.id=r1_3.id left join shelter_entity s2_0 on s2_0.id=r1_2.shelter_id left join shelter_entity s3_0 on s3_0.id=re1_0.shelter_id where re1_0.id=?
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: insert into report_strategy_entity (id) values (default)
Hibernate: insert into adoption_report_strategy_entity (id) values (?)
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0 where re1_0.generate_date=?
Hibernate: delete from report_entity re1_0
Hibernate: insert into report_strategy_entity (id) values (default)
Hibernate: insert into return_report_strategy_entity (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
2026-03-23T20:06:08.197Z  INFO 71 --- [           main] c.e.u.mdp.pets.services.ReportService    : Creando reporte
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: delete from report_entity re1_0
Hibernate: delete from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,rs1_0.id,case when rs1_1.id is not null then 1 when rs1_2.id is not null then 2 when rs1_3.id is not null then 3 end,ru1_0.id,case when ru1_3.id is not null then 1 when ru1_1.id is not null then 2 when ru1_2.id is not null then 3 end,ru1_0.email,ru1_0.name,ru1_0.password,ru1_0.phone,ru1_1.has_children,ru1_1.has_other_pets,ru1_1.housing_type,ru1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ru1_2.specialty,r1_0.id,case when r1_3.id is not null then 1 when r1_1.id is not null then 2 when r1_2.id is not null then 3 end,r1_0.email,r1_0.name,r1_0.password,r1_0.phone,r1_1.has_children,r1_1.has_other_pets,r1_1.housing_type,r1_2.availability,s2_0.id,s2_0.city,s2_0.description,s2_0.email,s2_0.gallery,s2_0.name,r1_2.specialty,s3_0.id,s3_0.city,s3_0.description,s3_0.email,s3_0.gallery,s3_0.name,re1_0.status from report_entity re1_0 left join report_strategy_entity rs1_0 on rs1_0.id=re1_0.strategy_id left join adoption_report_strategy_entity rs1_1 on rs1_0.id=rs1_1.id left join medical_event_report_strategy_entity rs1_2 on rs1_0.id=rs1_2.id left join return_report_strategy_entity rs1_3 on rs1_0.id=rs1_3.id left join user_entity ru1_0 on ru1_0.id=re1_0.reported_user_id left join adopter_entity ru1_1 on ru1_0.id=ru1_1.id left join veterinarian_entity ru1_2 on ru1_0.id=ru1_2.id left join mock_user ru1_3 on ru1_0.id=ru1_3.id left join shelter_entity s1_0 on s1_0.id=ru1_2.shelter_id left join user_entity r1_0 on r1_0.id=re1_0.reporter_id left join adopter_entity r1_1 on r1_0.id=r1_1.id left join veterinarian_entity r1_2 on r1_0.id=r1_2.id left join mock_user r1_3 on r1_0.id=r1_3.id left join shelter_entity s2_0 on s2_0.id=r1_2.shelter_id left join shelter_entity s3_0 on s3_0.id=re1_0.shelter_id where re1_0.id=?
[INFO] Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.453 s -- in co.edu.udistrital.mdp.pets.services.ReportServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
2026-03-23T20:06:08.209Z  INFO 71 --- [           main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest]: MedicalHistoryServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T20:06:08.214Z  INFO 71 --- [           main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/

 :: Spring Boot ::               (v3.5.10)

2026-03-23T20:06:08.226Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryServiceTest    : Starting MedicalHistoryServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-23T20:06:08.227Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryServiceTest    : No active profile set, falling back to 1 default profile: "default"
2026-03-23T20:06:08.273Z  INFO 71 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T20:06:08.290Z  INFO 71 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 15 ms. Found 20 JPA repository interfaces.
2026-03-23T20:06:08.300Z  INFO 71 --- [           main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T20:06:08.309Z  INFO 71 --- [           main] o.s.j.d.e.EmbeddedDatabaseFactory        : Starting embedded database: url='jdbc:h2:mem:3da98611-bfd5-43c8-86ff-12c0c34f89e2;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T20:06:08.321Z  INFO 71 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T20:06:08.322Z  INFO 71 --- [           main] o.h.c.internal.RegionFactoryInitiator    : HHH000026: Second-level cache disabled
2026-03-23T20:06:08.329Z  INFO 71 --- [           main] o.s.o.j.p.SpringPersistenceUnitInfo      : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T20:06:08.330Z  WARN 71 --- [           main] org.hibernate.orm.deprecation            : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-23T20:06:08.330Z  INFO 71 --- [           main] org.hibernate.orm.connections.pooling    : HHH10001005: Database info:
	Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@12a0463c']
	Database driver: undefined/unknown
	Database version: 2.3.232
	Autocommit mode: undefined/unknown
	Isolation level: undefined/unknown
	Minimum pool size: undefined/unknown
	Maximum pool size: undefined/unknown
Hibernate: create global temporary table HT_report_strategy_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_medical_event_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_return_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-03-23T20:06:08.429Z  INFO 71 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (follow_up_date date, adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_event_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, reported_user_id bigint, reporter_id bigint, shelter_id bigint, strategy_id bigint, reason varchar(255), status enum ('PENDING','RESOLVED','REVIEWED'), primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table return_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table subscription_entity (active boolean, id bigint generated by default as identity, shelter_id bigint, user_id bigint, primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_report_strategy_entity add constraint FKktfiy86djtvw20h6565fl76bq foreign key (id) references report_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_event_report_strategy_entity add constraint FKsdm20588vdyki7ca5bfpu4ohi foreign key (id) references report_strategy_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FK6jux60r77sw05uia08u9dvsm4 foreign key (reported_user_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKe07325of08t46hkil1uoc038i foreign key (reporter_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists return_report_strategy_entity add constraint FKjsru2p38nruuct0fu1q64p5lu foreign key (id) references report_strategy_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FK4125j8wt2ul4p4dv9f57atjxq foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FKckoo8jnsf7bkp8kceutmrg31h foreign key (user_id) references user_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-03-23T20:06:08.449Z  INFO 71 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T20:06:08.617Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryServiceTest    : Started MedicalHistoryServiceTest in 0.401 seconds (process running for 23.22)
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.638Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando eliminación de la historia clínica ID: 999999
Hibernate: select count(*) from medical_history_entity mhe1_0 where mhe1_0.id=?
2026-03-23T20:06:08.641Z ERROR 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Intento de eliminar historia clínica inexistente con ID: 999999
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.652Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Consultando historia clínica con id = 4
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.662Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando actualización de historia clínica con id = 7
2026-03-23T20:06:08.663Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Historia clínica con id = 7 actualizada exitosamente
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
2026-03-23T20:06:08.674Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando actualización de historia clínica con id = 123456789
Hibernate: select mhe1_0.id,mhe1_0.description,mhe1_0.last_checkout,mhe1_0.notes,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where mhe1_0.id=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
2026-03-23T20:06:08.686Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando la creación de la historia clínica
Hibernate: select mhe1_0.id from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where p1_0.id=? fetch first ? rows only
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.689Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Historia clínica creada exitosamente
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.698Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando eliminación de la historia clínica ID: 19
Hibernate: select count(*) from medical_history_entity mhe1_0 where mhe1_0.id=?
2026-03-23T20:06:08.699Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Historia clínica ID: 19 eliminada exitosamente
2026-03-23T20:06:08.700Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Consultando historia clínica con id = 19
2026-03-23T20:06:08.700Z ERROR 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Historia clínica con id 19 no encontrada
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.710Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando la creación de la historia clínica
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.720Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando la creación de la historia clínica
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.729Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando actualización de historia clínica con id = 27
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T20:06:08.741Z  INFO 71 --- [           main] c.e.u.m.p.s.MedicalHistoryService        : Iniciando la creación de la historia clínica
Hibernate: select mhe1_0.id from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where p1_0.id=? fetch first ? rows only
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.537 s -- in co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VaccineServiceTest
2026-03-23T20:06:08.747Z  INFO 71 --- [           main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.VaccineServiceTest]: VaccineServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T20:06:08.752Z  INFO 71 --- [           main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.VaccineServiceTest

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/

 :: Spring Boot ::               (v3.5.10)

2026-03-23T20:06:08.766Z  INFO 71 --- [           main] c.e.u.m.p.services.VaccineServiceTest    : Starting VaccineServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-23T20:06:08.766Z  INFO 71 --- [           main] c.e.u.m.p.services.VaccineServiceTest    : No active profile set, falling back to 1 default profile: "default"
2026-03-23T20:06:08.840Z  INFO 71 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T20:06:08.860Z  INFO 71 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 18 ms. Found 20 JPA repository interfaces.
2026-03-23T20:06:08.871Z  INFO 71 --- [           main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T20:06:08.881Z  INFO 71 --- [           main] o.s.j.d.e.EmbeddedDatabaseFactory        : Starting embedded database: url='jdbc:h2:mem:a77190b7-2b1e-4cb5-a9ee-aece85314b57;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T20:06:08.896Z  INFO 71 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T20:06:08.897Z  INFO 71 --- [           main] o.h.c.internal.RegionFactoryInitiator    : HHH000026: Second-level cache disabled
2026-03-23T20:06:08.905Z  INFO 71 --- [           main] o.s.o.j.p.SpringPersistenceUnitInfo      : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T20:06:08.906Z  WARN 71 --- [           main] org.hibernate.orm.deprecation            : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-23T20:06:08.907Z  INFO 71 --- [           main] org.hibernate.orm.connections.pooling    : HHH10001005: Database info:
	Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@1003c98']
	Database driver: undefined/unknown
	Database version: 2.3.232
	Autocommit mode: undefined/unknown
	Isolation level: undefined/unknown
	Minimum pool size: undefined/unknown
	Maximum pool size: undefined/unknown
Hibernate: create global temporary table HT_report_strategy_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_medical_event_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_return_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-03-23T20:06:09.011Z  INFO 71 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (follow_up_date date, adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_event_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, reported_user_id bigint, reporter_id bigint, shelter_id bigint, strategy_id bigint, reason varchar(255), status enum ('PENDING','RESOLVED','REVIEWED'), primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table return_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table subscription_entity (active boolean, id bigint generated by default as identity, shelter_id bigint, user_id bigint, primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_report_strategy_entity add constraint FKktfiy86djtvw20h6565fl76bq foreign key (id) references report_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_event_report_strategy_entity add constraint FKsdm20588vdyki7ca5bfpu4ohi foreign key (id) references report_strategy_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FK6jux60r77sw05uia08u9dvsm4 foreign key (reported_user_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKe07325of08t46hkil1uoc038i foreign key (reporter_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists return_report_strategy_entity add constraint FKjsru2p38nruuct0fu1q64p5lu foreign key (id) references report_strategy_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FK4125j8wt2ul4p4dv9f57atjxq foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FKckoo8jnsf7bkp8kceutmrg31h foreign key (user_id) references user_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-03-23T20:06:09.031Z  INFO 71 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T20:06:09.171Z  INFO 71 --- [           main] c.e.u.m.p.services.VaccineServiceTest    : Started VaccineServiceTest in 0.417 seconds (process running for 23.774)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select ve1_0.id,ve1_0.description,ve1_0.name,ve1_0.validity_months from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.494 s -- in co.edu.udistrital.mdp.pets.services.VaccineServiceTest
2026-03-23T20:06:09.255Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.411Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.418Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.424Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.429Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.433Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.437Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.442Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.446Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.450Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.454Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.459Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.463Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.467Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.472Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.476Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.480Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
Hibernate: drop table if exists medical_event_report_strategy_entity cascade 
Hibernate: drop table if exists medical_history_entity cascade 
Hibernate: drop table if exists message_entity cascade 
Hibernate: drop table if exists mock_user cascade 
Hibernate: drop table if exists notification_entity cascade 
Hibernate: drop table if exists notification_strategy_entity cascade 
Hibernate: drop table if exists pet_entity cascade 
Hibernate: drop table if exists report_entity cascade 
Hibernate: drop table if exists report_strategy_entity cascade 
Hibernate: drop table if exists return_report_strategy_entity cascade 
Hibernate: drop table if exists review_entity cascade 
Hibernate: drop table if exists shelter_entity cascade 
Hibernate: drop table if exists shelter_event_entity cascade 
Hibernate: drop table if exists subscription_entity cascade 
Hibernate: drop table if exists trial_cohabitation_entity cascade 
Hibernate: drop table if exists user_entity cascade 
Hibernate: drop table if exists vaccination_record_entity cascade 
Hibernate: drop table if exists vaccine_entity cascade 
Hibernate: drop table if exists veterinarian_entity cascade 
2026-03-23T20:06:09.484Z  INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade 
Hibernate: drop table if exists adoption_entity cascade 
Hibernate: drop table if exists adoption_follow_up_entity cascade 
Hibernate: drop table if exists adoption_report_strategy_entity cascade 
Hibernate: drop table if exists adoption_request_entity cascade 
Hibernate: drop table if exists approval_strategy_entity cascade 
Hibernate: drop table if exists medical_event_entity cascade 
[INFO] 
[INFO] Results:
[INFO] 
[INFO] Tests run: 388, Failures: 0, Errors: 0, Skipped: 0
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  25.670 s
[INFO] Finished at: 2026-03-23T20:06:09Z
[INFO] ------------------------------------------------------------------------