Console Output
Skipping 683 KB..
Full Logrom HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:15.949Z INFO 73 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Create trial cohabitation
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:15.962Z INFO 73 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Updating trial cohabitation
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:15.976Z INFO 73 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Create trial cohabitation
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.476 s -- in co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ReturnCaseServiceTest
2026-03-23T03:16:15.981Z INFO 73 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.ReturnCaseServiceTest]: ReturnCaseServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T03:16:15.985Z INFO 73 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.ReturnCaseServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.11)
2026-03-23T03:16:15.997Z INFO 73 --- [ main] c.e.u.m.p.s.ReturnCaseServiceTest : Starting ReturnCaseServiceTest using Java 21.0.4 with PID 73 (started by root in /home/cecaduser/workspace/MP_202610_G81_E2_Back)
2026-03-23T03:16:15.997Z INFO 73 --- [ main] c.e.u.m.p.s.ReturnCaseServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-23T03:16:16.045Z INFO 73 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T03:16:16.061Z INFO 73 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14 ms. Found 18 JPA repository interfaces.
2026-03-23T03:16:16.071Z INFO 73 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T03:16:16.079Z INFO 73 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:4992eb4a-003e-4336-b5f5-e2ab577c533b;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T03:16:16.091Z INFO 73 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T03:16:16.092Z INFO 73 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-23T03:16:16.099Z INFO 73 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T03:16:16.100Z WARN 73 --- [ 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-23T03:16:16.101Z INFO 73 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@5618151e']
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_adoption_process_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_process_entity(approved boolean, creation_date date, end_date date, start_date date, HTE_IDENTITY bigint generated by default as identity, adoption_request_id bigint, id bigint, pet_id bigint, notes varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_trial_cohabitation_entity(approved boolean, creation_date date, end_date date, start_date date, HTE_IDENTITY bigint generated by default as identity, adoption_request_id bigint, id bigint, pet_id bigint, notes varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), shelter_id bigint, address varchar(255), availability_schedule varchar(255), city varchar(255), email varchar(255), housing_type varchar(255), license_number varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_veterinarian_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), shelter_id bigint, availability_schedule varchar(255), email varchar(255), license_number varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_adopter_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), address varchar(255), city varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
2026-03-23T03:16:16.211Z INFO 73 --- [ 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_process_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists medical_event_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 pet_entity cascade
Hibernate: drop table if exists return_case_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_media_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccine_entry_entity cascade
Hibernate: drop table if exists vet_speciality_relation cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: drop table if exists vet_speciality_entity cascade
Hibernate: create table adopter_entity (id bigint not null, address varchar(255), city varchar(255), housing_type varchar(255), status varchar(255), primary key (id))
Hibernate: create table adoption_entity (contract_signed boolean, official_date date, id bigint generated by default as identity, pet_id bigint, trial_cohabitation_id bigint unique, primary key (id))
Hibernate: create table adoption_process_entity (creation_date date, adoption_request_id bigint unique, id bigint generated by default as identity, pet_id bigint, status varchar(255), 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, comments varchar(255), status varchar(255), 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), event_type varchar(255), primary key (id))
Hibernate: create table medical_history_entity (created_date date, last_updated date, id bigint generated by default as identity, pet_id bigint unique, veterinarian_id bigint, primary key (id))
Hibernate: create table message_entity (active boolean, is_read boolean, id bigint generated by default as identity, receiver_id bigint, sender_id bigint, sent_at timestamp(6), content varchar(255), primary key (id))
Hibernate: create table notification_entity (is_read boolean, created_at timestamp(6), id bigint generated by default as identity, user_id bigint, content varchar(255), title varchar(255), primary key (id))
Hibernate: create table pet_entity (born_date date, is_rescued boolean, id bigint generated by default as identity, shelter_id bigint, breed varchar(255), name varchar(255), sex varchar(255), size varchar(255), specific_needs varchar(255), status varchar(255), temperament varchar(255), primary key (id))
Hibernate: create table return_case_entity (return_date date, adoption_process_id bigint unique, id bigint generated by default as identity, details varchar(255), reason varchar(255), primary key (id))
Hibernate: create table review_entity (is_success_story boolean, rating integer, adopter_id bigint, adoption_process_id bigint, id bigint generated by default as identity, shelter_id bigint, comment varchar(255), primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, address varchar(255), city varchar(255), description varchar(255), location_details varchar(255), nit varchar(255), phone_number varchar(255), shelter_name varchar(255), status varchar(255), website_url varchar(255), primary key (id))
Hibernate: create table shelter_media_entity (id bigint generated by default as identity, shelter_id bigint, description varchar(255), media_type varchar(255), media_url varchar(255), primary key (id))
Hibernate: create table trial_cohabitation_entity (approved boolean, end_date date, start_date date, id bigint not null, notes varchar(255), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, register_date timestamp(6), email varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), primary key (id))
Hibernate: create table vaccine_entry_entity (admin_date date, next_due_date date, id bigint generated by default as identity, medical_history_id bigint, vaccine_name varchar(255), primary key (id))
Hibernate: create table vet_speciality_relation (speciality_id bigint not null, vet_id bigint not null)
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability_schedule varchar(255), license_number varchar(255), primary key (id))
Hibernate: create table vet_speciality_entity (id bigint generated by default as identity, description varchar(255), name 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 FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_entity add constraint FK8x0rs5b3npfj9w92mh30nhdd5 foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists adoption_process_entity add constraint FK1wpy6iv96dq7w9my6g9bl77gi foreign key (adoption_request_id) references adoption_request_entity
Hibernate: alter table if exists adoption_process_entity add constraint FK72me1bmmr6kq9uqkueiybt921 foreign key (pet_id) references pet_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 FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_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_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists medical_history_entity add constraint FKnur7g43m7dj3kc7bq5q33v0eo foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists message_entity add constraint FKf1eboma4d9p0wlj48qwpd2ban foreign key (receiver_id) references user_entity
Hibernate: alter table if exists message_entity add constraint FKchngvnhlot2wncosjrnmd1qjp foreign key (sender_id) references user_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 return_case_entity add constraint FKq5oky202hvs0kv9upfkolmn88 foreign key (adoption_process_id) references adoption_process_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 FKg0jyjvg2qkjrywc3aib0r7iqq foreign key (adoption_process_id) references adoption_process_entity
Hibernate: alter table if exists review_entity add constraint FKrt9pkjnacboa4fc7ug82wm7cw foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists shelter_media_entity add constraint FK6couwlbflod3yxf2r9yu7augk foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK15m52vl1kqpw9j5fsv1osa8jx foreign key (id) references adoption_process_entity
Hibernate: alter table if exists vaccine_entry_entity add constraint FKiljjk4cjlbiilp7fohur5nf5g foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vet_speciality_relation add constraint FK6hx84a5ij49rxm81pmx8t6mq7 foreign key (speciality_id) references vet_speciality_entity
Hibernate: alter table if exists vet_speciality_relation add constraint FKco5ttqfls718a193w5l2np2oe foreign key (vet_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-23T03:16:16.227Z INFO 73 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T03:16:16.326Z INFO 73 --- [ main] c.e.u.m.p.s.ReturnCaseServiceTest : Started ReturnCaseServiceTest in 0.339 seconds (process running for 29.119)
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.334Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de consultar el caso de devolución con id = 1
2026-03-23T03:16:16.335Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Termina proceso de consultar el caso de devolución con id = 1
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.342Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de borrar el caso de devolución con id = 0
Hibernate: select rce1_0.id,ap1_0.id,case when ap1_1.id is not null then 1 end,ar1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone_number,a1_1.profile_image_url,a1_1.register_date,a1_0.address,a1_0.city,a1_0.housing_type,a1_0.status,ar1_0.comments,p1_0.id,p1_0.born_date,p1_0.breed,p1_0.is_rescued,mh1_0.id,mh1_0.created_date,mh1_0.last_updated,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,p1_0.name,p1_0.sex,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url,p1_0.size,p1_0.specific_needs,p1_0.status,p1_0.temperament,ar1_0.request_date,ar1_0.status,ap1_0.creation_date,p2_0.id,p2_0.born_date,p2_0.breed,p2_0.is_rescued,mh2_0.id,mh2_0.created_date,mh2_0.last_updated,v2_0.id,v2_1.email,v2_1.name,v2_1.password,v2_1.phone_number,v2_1.profile_image_url,v2_1.register_date,v2_0.availability_schedule,v2_0.license_number,s3_0.id,s3_0.address,s3_0.city,s3_0.description,s3_0.location_details,s3_0.nit,s3_0.phone_number,s3_0.shelter_name,s3_0.status,s3_0.website_url,p2_0.name,p2_0.sex,s4_0.id,s4_0.address,s4_0.city,s4_0.description,s4_0.location_details,s4_0.nit,s4_0.phone_number,s4_0.shelter_name,s4_0.status,s4_0.website_url,p2_0.size,p2_0.specific_needs,p2_0.status,p2_0.temperament,ap1_0.status,ap1_1.approved,ap1_1.end_date,ap1_1.notes,ap1_1.start_date,rce1_0.details,rce1_0.reason,rce1_0.return_date from return_case_entity rce1_0 left join adoption_process_entity ap1_0 on ap1_0.id=rce1_0.adoption_process_id left join trial_cohabitation_entity ap1_1 on ap1_0.id=ap1_1.id left join adoption_request_entity ar1_0 on ar1_0.id=ap1_0.adoption_request_id left join adopter_entity a1_0 on a1_0.id=ar1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ar1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join veterinarian_entity v1_0 on v1_0.id=mh1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s1_0 on s1_0.id=v1_0.shelter_id left join shelter_entity s2_0 on s2_0.id=p1_0.shelter_id left join pet_entity p2_0 on p2_0.id=ap1_0.pet_id left join medical_history_entity mh2_0 on p2_0.id=mh2_0.pet_id left join veterinarian_entity v2_0 on v2_0.id=mh2_0.veterinarian_id left join user_entity v2_1 on v2_0.id=v2_1.id left join shelter_entity s3_0 on s3_0.id=v2_0.shelter_id left join shelter_entity s4_0 on s4_0.id=p2_0.shelter_id where rce1_0.id=?
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.350Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de borrar el caso de devolución con id = 8
2026-03-23T03:16:16.351Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Termina proceso de borrar el caso de devolución con id = 8
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.357Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de consultar todos los casos de devolución
Hibernate: select rce1_0.id,rce1_0.adoption_process_id,rce1_0.details,rce1_0.reason,rce1_0.return_date from return_case_entity rce1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.365Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de actualizar el caso de devolución con id = 13
2026-03-23T03:16:16.366Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Termina proceso de actualizar el caso de devolución con id = 13
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
2026-03-23T03:16:16.374Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de borrar el caso de devolución con id = 16
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.381Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de creación del caso de devolución
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.387Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de actualizar el caso de devolución con id = 0
Hibernate: select rce1_0.id,ap1_0.id,case when ap1_1.id is not null then 1 end,ar1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone_number,a1_1.profile_image_url,a1_1.register_date,a1_0.address,a1_0.city,a1_0.housing_type,a1_0.status,ar1_0.comments,p1_0.id,p1_0.born_date,p1_0.breed,p1_0.is_rescued,mh1_0.id,mh1_0.created_date,mh1_0.last_updated,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,p1_0.name,p1_0.sex,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url,p1_0.size,p1_0.specific_needs,p1_0.status,p1_0.temperament,ar1_0.request_date,ar1_0.status,ap1_0.creation_date,p2_0.id,p2_0.born_date,p2_0.breed,p2_0.is_rescued,mh2_0.id,mh2_0.created_date,mh2_0.last_updated,v2_0.id,v2_1.email,v2_1.name,v2_1.password,v2_1.phone_number,v2_1.profile_image_url,v2_1.register_date,v2_0.availability_schedule,v2_0.license_number,s3_0.id,s3_0.address,s3_0.city,s3_0.description,s3_0.location_details,s3_0.nit,s3_0.phone_number,s3_0.shelter_name,s3_0.status,s3_0.website_url,p2_0.name,p2_0.sex,s4_0.id,s4_0.address,s4_0.city,s4_0.description,s4_0.location_details,s4_0.nit,s4_0.phone_number,s4_0.shelter_name,s4_0.status,s4_0.website_url,p2_0.size,p2_0.specific_needs,p2_0.status,p2_0.temperament,ap1_0.status,ap1_1.approved,ap1_1.end_date,ap1_1.notes,ap1_1.start_date,rce1_0.details,rce1_0.reason,rce1_0.return_date from return_case_entity rce1_0 left join adoption_process_entity ap1_0 on ap1_0.id=rce1_0.adoption_process_id left join trial_cohabitation_entity ap1_1 on ap1_0.id=ap1_1.id left join adoption_request_entity ar1_0 on ar1_0.id=ap1_0.adoption_request_id left join adopter_entity a1_0 on a1_0.id=ar1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ar1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join veterinarian_entity v1_0 on v1_0.id=mh1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s1_0 on s1_0.id=v1_0.shelter_id left join shelter_entity s2_0 on s2_0.id=p1_0.shelter_id left join pet_entity p2_0 on p2_0.id=ap1_0.pet_id left join medical_history_entity mh2_0 on p2_0.id=mh2_0.pet_id left join veterinarian_entity v2_0 on v2_0.id=mh2_0.veterinarian_id left join user_entity v2_1 on v2_0.id=v2_1.id left join shelter_entity s3_0 on s3_0.id=v2_0.shelter_id left join shelter_entity s4_0 on s4_0.id=p2_0.shelter_id where rce1_0.id=?
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.395Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de consultar el caso de devolución con id = 0
Hibernate: select rce1_0.id,ap1_0.id,case when ap1_1.id is not null then 1 end,ar1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone_number,a1_1.profile_image_url,a1_1.register_date,a1_0.address,a1_0.city,a1_0.housing_type,a1_0.status,ar1_0.comments,p1_0.id,p1_0.born_date,p1_0.breed,p1_0.is_rescued,mh1_0.id,mh1_0.created_date,mh1_0.last_updated,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,p1_0.name,p1_0.sex,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url,p1_0.size,p1_0.specific_needs,p1_0.status,p1_0.temperament,ar1_0.request_date,ar1_0.status,ap1_0.creation_date,p2_0.id,p2_0.born_date,p2_0.breed,p2_0.is_rescued,mh2_0.id,mh2_0.created_date,mh2_0.last_updated,v2_0.id,v2_1.email,v2_1.name,v2_1.password,v2_1.phone_number,v2_1.profile_image_url,v2_1.register_date,v2_0.availability_schedule,v2_0.license_number,s3_0.id,s3_0.address,s3_0.city,s3_0.description,s3_0.location_details,s3_0.nit,s3_0.phone_number,s3_0.shelter_name,s3_0.status,s3_0.website_url,p2_0.name,p2_0.sex,s4_0.id,s4_0.address,s4_0.city,s4_0.description,s4_0.location_details,s4_0.nit,s4_0.phone_number,s4_0.shelter_name,s4_0.status,s4_0.website_url,p2_0.size,p2_0.specific_needs,p2_0.status,p2_0.temperament,ap1_0.status,ap1_1.approved,ap1_1.end_date,ap1_1.notes,ap1_1.start_date,rce1_0.details,rce1_0.reason,rce1_0.return_date from return_case_entity rce1_0 left join adoption_process_entity ap1_0 on ap1_0.id=rce1_0.adoption_process_id left join trial_cohabitation_entity ap1_1 on ap1_0.id=ap1_1.id left join adoption_request_entity ar1_0 on ar1_0.id=ap1_0.adoption_request_id left join adopter_entity a1_0 on a1_0.id=ar1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ar1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join veterinarian_entity v1_0 on v1_0.id=mh1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s1_0 on s1_0.id=v1_0.shelter_id left join shelter_entity s2_0 on s2_0.id=p1_0.shelter_id left join pet_entity p2_0 on p2_0.id=ap1_0.pet_id left join medical_history_entity mh2_0 on p2_0.id=mh2_0.pet_id left join veterinarian_entity v2_0 on v2_0.id=mh2_0.veterinarian_id left join user_entity v2_1 on v2_0.id=v2_1.id left join shelter_entity s3_0 on s3_0.id=v2_0.shelter_id left join shelter_entity s4_0 on s4_0.id=p2_0.shelter_id where rce1_0.id=?
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.403Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de creación del caso de devolución
2026-03-23T03:16:16.403Z INFO 73 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Termina proceso de creación del caso de devolución
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.426 s -- in co.edu.udistrital.mdp.pets.services.ReturnCaseServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.AdoptionProcessServiceTest
2026-03-23T03:16:16.408Z INFO 73 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.AdoptionProcessServiceTest]: AdoptionProcessServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T03:16:16.412Z INFO 73 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.AdoptionProcessServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.11)
2026-03-23T03:16:16.425Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessServiceTest : Starting AdoptionProcessServiceTest using Java 21.0.4 with PID 73 (started by root in /home/cecaduser/workspace/MP_202610_G81_E2_Back)
2026-03-23T03:16:16.425Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-23T03:16:16.476Z INFO 73 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T03:16:16.491Z INFO 73 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14 ms. Found 18 JPA repository interfaces.
2026-03-23T03:16:16.501Z INFO 73 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T03:16:16.509Z INFO 73 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:63045c5c-a388-42f6-8084-8edf9fb01b63;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T03:16:16.521Z INFO 73 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T03:16:16.525Z INFO 73 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-23T03:16:16.531Z INFO 73 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T03:16:16.533Z WARN 73 --- [ 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-23T03:16:16.533Z INFO 73 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@7b32a57e']
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_adoption_process_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_process_entity(approved boolean, creation_date date, end_date date, start_date date, HTE_IDENTITY bigint generated by default as identity, adoption_request_id bigint, id bigint, pet_id bigint, notes varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_trial_cohabitation_entity(approved boolean, creation_date date, end_date date, start_date date, HTE_IDENTITY bigint generated by default as identity, adoption_request_id bigint, id bigint, pet_id bigint, notes varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), shelter_id bigint, address varchar(255), availability_schedule varchar(255), city varchar(255), email varchar(255), housing_type varchar(255), license_number varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_veterinarian_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), shelter_id bigint, availability_schedule varchar(255), email varchar(255), license_number varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_adopter_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), address varchar(255), city varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
2026-03-23T03:16:16.614Z INFO 73 --- [ 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_process_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists medical_event_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 pet_entity cascade
Hibernate: drop table if exists return_case_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_media_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccine_entry_entity cascade
Hibernate: drop table if exists vet_speciality_relation cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: drop table if exists vet_speciality_entity cascade
Hibernate: create table adopter_entity (id bigint not null, address varchar(255), city varchar(255), housing_type varchar(255), status varchar(255), primary key (id))
Hibernate: create table adoption_entity (contract_signed boolean, official_date date, id bigint generated by default as identity, pet_id bigint, trial_cohabitation_id bigint unique, primary key (id))
Hibernate: create table adoption_process_entity (creation_date date, adoption_request_id bigint unique, id bigint generated by default as identity, pet_id bigint, status varchar(255), 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, comments varchar(255), status varchar(255), 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), event_type varchar(255), primary key (id))
Hibernate: create table medical_history_entity (created_date date, last_updated date, id bigint generated by default as identity, pet_id bigint unique, veterinarian_id bigint, primary key (id))
Hibernate: create table message_entity (active boolean, is_read boolean, id bigint generated by default as identity, receiver_id bigint, sender_id bigint, sent_at timestamp(6), content varchar(255), primary key (id))
Hibernate: create table notification_entity (is_read boolean, created_at timestamp(6), id bigint generated by default as identity, user_id bigint, content varchar(255), title varchar(255), primary key (id))
Hibernate: create table pet_entity (born_date date, is_rescued boolean, id bigint generated by default as identity, shelter_id bigint, breed varchar(255), name varchar(255), sex varchar(255), size varchar(255), specific_needs varchar(255), status varchar(255), temperament varchar(255), primary key (id))
Hibernate: create table return_case_entity (return_date date, adoption_process_id bigint unique, id bigint generated by default as identity, details varchar(255), reason varchar(255), primary key (id))
Hibernate: create table review_entity (is_success_story boolean, rating integer, adopter_id bigint, adoption_process_id bigint, id bigint generated by default as identity, shelter_id bigint, comment varchar(255), primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, address varchar(255), city varchar(255), description varchar(255), location_details varchar(255), nit varchar(255), phone_number varchar(255), shelter_name varchar(255), status varchar(255), website_url varchar(255), primary key (id))
Hibernate: create table shelter_media_entity (id bigint generated by default as identity, shelter_id bigint, description varchar(255), media_type varchar(255), media_url varchar(255), primary key (id))
Hibernate: create table trial_cohabitation_entity (approved boolean, end_date date, start_date date, id bigint not null, notes varchar(255), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, register_date timestamp(6), email varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), primary key (id))
Hibernate: create table vaccine_entry_entity (admin_date date, next_due_date date, id bigint generated by default as identity, medical_history_id bigint, vaccine_name varchar(255), primary key (id))
Hibernate: create table vet_speciality_relation (speciality_id bigint not null, vet_id bigint not null)
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability_schedule varchar(255), license_number varchar(255), primary key (id))
Hibernate: create table vet_speciality_entity (id bigint generated by default as identity, description varchar(255), name 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 FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_entity add constraint FK8x0rs5b3npfj9w92mh30nhdd5 foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists adoption_process_entity add constraint FK1wpy6iv96dq7w9my6g9bl77gi foreign key (adoption_request_id) references adoption_request_entity
Hibernate: alter table if exists adoption_process_entity add constraint FK72me1bmmr6kq9uqkueiybt921 foreign key (pet_id) references pet_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 FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_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_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists medical_history_entity add constraint FKnur7g43m7dj3kc7bq5q33v0eo foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists message_entity add constraint FKf1eboma4d9p0wlj48qwpd2ban foreign key (receiver_id) references user_entity
Hibernate: alter table if exists message_entity add constraint FKchngvnhlot2wncosjrnmd1qjp foreign key (sender_id) references user_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 return_case_entity add constraint FKq5oky202hvs0kv9upfkolmn88 foreign key (adoption_process_id) references adoption_process_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 FKg0jyjvg2qkjrywc3aib0r7iqq foreign key (adoption_process_id) references adoption_process_entity
Hibernate: alter table if exists review_entity add constraint FKrt9pkjnacboa4fc7ug82wm7cw foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists shelter_media_entity add constraint FK6couwlbflod3yxf2r9yu7augk foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK15m52vl1kqpw9j5fsv1osa8jx foreign key (id) references adoption_process_entity
Hibernate: alter table if exists vaccine_entry_entity add constraint FKiljjk4cjlbiilp7fohur5nf5g foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vet_speciality_relation add constraint FK6hx84a5ij49rxm81pmx8t6mq7 foreign key (speciality_id) references vet_speciality_entity
Hibernate: alter table if exists vet_speciality_relation add constraint FKco5ttqfls718a193w5l2np2oe foreign key (vet_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-23T03:16:16.631Z INFO 73 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T03:16:16.733Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessServiceTest : Started AdoptionProcessServiceTest in 0.319 seconds (process running for 29.525)
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into return_case_entity (adoption_process_id,details,reason,return_date,id) values (?,?,?,?,default)
2026-03-23T03:16:16.750Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Delete adoption process
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.765Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Create adoption process
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.778Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Create adoption process
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.791Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Delete adoption process
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.805Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Create adoption process
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.819Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Search all adoption processes
Hibernate: select ape1_0.id,case when ape1_1.id is not null then 1 end,ape1_0.adoption_request_id,ape1_0.creation_date,ape1_0.pet_id,ape1_0.status,ape1_1.approved,ape1_1.end_date,ape1_1.notes,ape1_1.start_date from adoption_process_entity ape1_0 left join trial_cohabitation_entity ape1_1 on ape1_0.id=ape1_1.id
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.836Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Delete adoption process
Hibernate: select ape1_0.id,case when ape1_1.id is not null then 1 end,ar1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone_number,a1_1.profile_image_url,a1_1.register_date,a1_0.address,a1_0.city,a1_0.housing_type,a1_0.status,ar1_0.comments,p1_0.id,p1_0.born_date,p1_0.breed,p1_0.is_rescued,mh1_0.id,mh1_0.created_date,mh1_0.last_updated,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,p1_0.name,p1_0.sex,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url,p1_0.size,p1_0.specific_needs,p1_0.status,p1_0.temperament,ar1_0.request_date,ar1_0.status,ape1_0.creation_date,p2_0.id,p2_0.born_date,p2_0.breed,p2_0.is_rescued,mh2_0.id,mh2_0.created_date,mh2_0.last_updated,v2_0.id,v2_1.email,v2_1.name,v2_1.password,v2_1.phone_number,v2_1.profile_image_url,v2_1.register_date,v2_0.availability_schedule,v2_0.license_number,s3_0.id,s3_0.address,s3_0.city,s3_0.description,s3_0.location_details,s3_0.nit,s3_0.phone_number,s3_0.shelter_name,s3_0.status,s3_0.website_url,p2_0.name,p2_0.sex,s4_0.id,s4_0.address,s4_0.city,s4_0.description,s4_0.location_details,s4_0.nit,s4_0.phone_number,s4_0.shelter_name,s4_0.status,s4_0.website_url,p2_0.size,p2_0.specific_needs,p2_0.status,p2_0.temperament,rc1_0.id,rc1_0.details,rc1_0.reason,rc1_0.return_date,ape1_0.status,ape1_1.approved,ape1_1.end_date,ape1_1.notes,ape1_1.start_date from adoption_process_entity ape1_0 left join trial_cohabitation_entity ape1_1 on ape1_0.id=ape1_1.id left join adoption_request_entity ar1_0 on ar1_0.id=ape1_0.adoption_request_id left join adopter_entity a1_0 on a1_0.id=ar1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ar1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join veterinarian_entity v1_0 on v1_0.id=mh1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s1_0 on s1_0.id=v1_0.shelter_id left join shelter_entity s2_0 on s2_0.id=p1_0.shelter_id left join pet_entity p2_0 on p2_0.id=ape1_0.pet_id left join medical_history_entity mh2_0 on p2_0.id=mh2_0.pet_id left join veterinarian_entity v2_0 on v2_0.id=mh2_0.veterinarian_id left join user_entity v2_1 on v2_0.id=v2_1.id left join shelter_entity s3_0 on s3_0.id=v2_0.shelter_id left join shelter_entity s4_0 on s4_0.id=p2_0.shelter_id left join return_case_entity rc1_0 on ape1_0.id=rc1_0.adoption_process_id where ape1_0.id=?
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.851Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Search adoption process with id = 23
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.865Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Updating adoption process
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.880Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Search adoption process with id = 0
Hibernate: select ape1_0.id,case when ape1_1.id is not null then 1 end,ar1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone_number,a1_1.profile_image_url,a1_1.register_date,a1_0.address,a1_0.city,a1_0.housing_type,a1_0.status,ar1_0.comments,p1_0.id,p1_0.born_date,p1_0.breed,p1_0.is_rescued,mh1_0.id,mh1_0.created_date,mh1_0.last_updated,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,p1_0.name,p1_0.sex,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url,p1_0.size,p1_0.specific_needs,p1_0.status,p1_0.temperament,ar1_0.request_date,ar1_0.status,ape1_0.creation_date,p2_0.id,p2_0.born_date,p2_0.breed,p2_0.is_rescued,mh2_0.id,mh2_0.created_date,mh2_0.last_updated,v2_0.id,v2_1.email,v2_1.name,v2_1.password,v2_1.phone_number,v2_1.profile_image_url,v2_1.register_date,v2_0.availability_schedule,v2_0.license_number,s3_0.id,s3_0.address,s3_0.city,s3_0.description,s3_0.location_details,s3_0.nit,s3_0.phone_number,s3_0.shelter_name,s3_0.status,s3_0.website_url,p2_0.name,p2_0.sex,s4_0.id,s4_0.address,s4_0.city,s4_0.description,s4_0.location_details,s4_0.nit,s4_0.phone_number,s4_0.shelter_name,s4_0.status,s4_0.website_url,p2_0.size,p2_0.specific_needs,p2_0.status,p2_0.temperament,rc1_0.id,rc1_0.details,rc1_0.reason,rc1_0.return_date,ape1_0.status,ape1_1.approved,ape1_1.end_date,ape1_1.notes,ape1_1.start_date from adoption_process_entity ape1_0 left join trial_cohabitation_entity ape1_1 on ape1_0.id=ape1_1.id left join adoption_request_entity ar1_0 on ar1_0.id=ape1_0.adoption_request_id left join adopter_entity a1_0 on a1_0.id=ar1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ar1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join veterinarian_entity v1_0 on v1_0.id=mh1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s1_0 on s1_0.id=v1_0.shelter_id left join shelter_entity s2_0 on s2_0.id=p1_0.shelter_id left join pet_entity p2_0 on p2_0.id=ape1_0.pet_id left join medical_history_entity mh2_0 on p2_0.id=mh2_0.pet_id left join veterinarian_entity v2_0 on v2_0.id=mh2_0.veterinarian_id left join user_entity v2_1 on v2_0.id=v2_1.id left join shelter_entity s3_0 on s3_0.id=v2_0.shelter_id left join shelter_entity s4_0 on s4_0.id=p2_0.shelter_id left join return_case_entity rc1_0 on ape1_0.id=rc1_0.adoption_process_id where ape1_0.id=?
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.895Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Create adoption process
Hibernate: insert into HT_adoption_process_entity(id) select tce1_0.id from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from adoption_process_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adoption_process_entity temptable_)
Hibernate: delete from HT_adoption_process_entity
Hibernate: delete from trial_cohabitation_entity to_delete_
Hibernate: delete from adoption_process_entity ape1_0
Hibernate: delete from adoption_request_entity are1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_adopter_entity(id) select ae1_0.id from adopter_entity ae1_0
Hibernate: delete from adopter_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_adopter_entity temptable_)
Hibernate: delete from HT_adopter_entity
Hibernate: delete from shelter_entity se1_0
Hibernate: delete from return_case_entity rce1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adopter_entity (address,city,housing_type,status,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
Hibernate: insert into adoption_process_entity (adoption_request_id,creation_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (approved,end_date,notes,start_date,id) values (?,?,?,?,?)
Hibernate: insert into adoption_request_entity (adopter_id,comments,pet_id,request_date,status,id) values (?,?,?,?,?,default)
2026-03-23T03:16:16.909Z INFO 73 --- [ main] c.e.u.m.p.s.AdoptionProcessService : Updating adoption process
Hibernate: select ape1_0.id,case when ape1_1.id is not null then 1 end,ar1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone_number,a1_1.profile_image_url,a1_1.register_date,a1_0.address,a1_0.city,a1_0.housing_type,a1_0.status,ar1_0.comments,p1_0.id,p1_0.born_date,p1_0.breed,p1_0.is_rescued,mh1_0.id,mh1_0.created_date,mh1_0.last_updated,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,p1_0.name,p1_0.sex,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url,p1_0.size,p1_0.specific_needs,p1_0.status,p1_0.temperament,ar1_0.request_date,ar1_0.status,ape1_0.creation_date,p2_0.id,p2_0.born_date,p2_0.breed,p2_0.is_rescued,mh2_0.id,mh2_0.created_date,mh2_0.last_updated,v2_0.id,v2_1.email,v2_1.name,v2_1.password,v2_1.phone_number,v2_1.profile_image_url,v2_1.register_date,v2_0.availability_schedule,v2_0.license_number,s3_0.id,s3_0.address,s3_0.city,s3_0.description,s3_0.location_details,s3_0.nit,s3_0.phone_number,s3_0.shelter_name,s3_0.status,s3_0.website_url,p2_0.name,p2_0.sex,s4_0.id,s4_0.address,s4_0.city,s4_0.description,s4_0.location_details,s4_0.nit,s4_0.phone_number,s4_0.shelter_name,s4_0.status,s4_0.website_url,p2_0.size,p2_0.specific_needs,p2_0.status,p2_0.temperament,rc1_0.id,rc1_0.details,rc1_0.reason,rc1_0.return_date,ape1_0.status,ape1_1.approved,ape1_1.end_date,ape1_1.notes,ape1_1.start_date from adoption_process_entity ape1_0 left join trial_cohabitation_entity ape1_1 on ape1_0.id=ape1_1.id left join adoption_request_entity ar1_0 on ar1_0.id=ape1_0.adoption_request_id left join adopter_entity a1_0 on a1_0.id=ar1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ar1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join veterinarian_entity v1_0 on v1_0.id=mh1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s1_0 on s1_0.id=v1_0.shelter_id left join shelter_entity s2_0 on s2_0.id=p1_0.shelter_id left join pet_entity p2_0 on p2_0.id=ape1_0.pet_id left join medical_history_entity mh2_0 on p2_0.id=mh2_0.pet_id left join veterinarian_entity v2_0 on v2_0.id=mh2_0.veterinarian_id left join user_entity v2_1 on v2_0.id=v2_1.id left join shelter_entity s3_0 on s3_0.id=v2_0.shelter_id left join shelter_entity s4_0 on s4_0.id=p2_0.shelter_id left join return_case_entity rc1_0 on ape1_0.id=rc1_0.adoption_process_id where ape1_0.id=?
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.506 s -- in co.edu.udistrital.mdp.pets.services.AdoptionProcessServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
2026-03-23T03:16:16.915Z INFO 73 --- [ 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-23T03:16:16.919Z INFO 73 --- [ 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.11)
2026-03-23T03:16:16.931Z INFO 73 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : Starting MedicalHistoryServiceTest using Java 21.0.4 with PID 73 (started by root in /home/cecaduser/workspace/MP_202610_G81_E2_Back)
2026-03-23T03:16:16.931Z INFO 73 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-23T03:16:16.979Z INFO 73 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T03:16:16.994Z INFO 73 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14 ms. Found 18 JPA repository interfaces.
2026-03-23T03:16:17.004Z INFO 73 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T03:16:17.012Z INFO 73 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:a8c498d9-3ffe-4628-8d94-f8b984e41e0c;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T03:16:17.024Z INFO 73 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T03:16:17.025Z INFO 73 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-23T03:16:17.033Z INFO 73 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T03:16:17.034Z WARN 73 --- [ 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-23T03:16:17.034Z INFO 73 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@310cf6a0']
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_adoption_process_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_process_entity(approved boolean, creation_date date, end_date date, start_date date, HTE_IDENTITY bigint generated by default as identity, adoption_request_id bigint, id bigint, pet_id bigint, notes varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_trial_cohabitation_entity(approved boolean, creation_date date, end_date date, start_date date, HTE_IDENTITY bigint generated by default as identity, adoption_request_id bigint, id bigint, pet_id bigint, notes varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), shelter_id bigint, address varchar(255), availability_schedule varchar(255), city varchar(255), email varchar(255), housing_type varchar(255), license_number varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_veterinarian_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), shelter_id bigint, availability_schedule varchar(255), email varchar(255), license_number varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_adopter_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, register_date timestamp(6), address varchar(255), city varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), status varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
2026-03-23T03:16:17.113Z INFO 73 --- [ 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_process_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists medical_event_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 pet_entity cascade
Hibernate: drop table if exists return_case_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_media_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccine_entry_entity cascade
Hibernate: drop table if exists vet_speciality_relation cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: drop table if exists vet_speciality_entity cascade
Hibernate: create table adopter_entity (id bigint not null, address varchar(255), city varchar(255), housing_type varchar(255), status varchar(255), primary key (id))
Hibernate: create table adoption_entity (contract_signed boolean, official_date date, id bigint generated by default as identity, pet_id bigint, trial_cohabitation_id bigint unique, primary key (id))
Hibernate: create table adoption_process_entity (creation_date date, adoption_request_id bigint unique, id bigint generated by default as identity, pet_id bigint, status varchar(255), 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, comments varchar(255), status varchar(255), 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), event_type varchar(255), primary key (id))
Hibernate: create table medical_history_entity (created_date date, last_updated date, id bigint generated by default as identity, pet_id bigint unique, veterinarian_id bigint, primary key (id))
Hibernate: create table message_entity (active boolean, is_read boolean, id bigint generated by default as identity, receiver_id bigint, sender_id bigint, sent_at timestamp(6), content varchar(255), primary key (id))
Hibernate: create table notification_entity (is_read boolean, created_at timestamp(6), id bigint generated by default as identity, user_id bigint, content varchar(255), title varchar(255), primary key (id))
Hibernate: create table pet_entity (born_date date, is_rescued boolean, id bigint generated by default as identity, shelter_id bigint, breed varchar(255), name varchar(255), sex varchar(255), size varchar(255), specific_needs varchar(255), status varchar(255), temperament varchar(255), primary key (id))
Hibernate: create table return_case_entity (return_date date, adoption_process_id bigint unique, id bigint generated by default as identity, details varchar(255), reason varchar(255), primary key (id))
Hibernate: create table review_entity (is_success_story boolean, rating integer, adopter_id bigint, adoption_process_id bigint, id bigint generated by default as identity, shelter_id bigint, comment varchar(255), primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, address varchar(255), city varchar(255), description varchar(255), location_details varchar(255), nit varchar(255), phone_number varchar(255), shelter_name varchar(255), status varchar(255), website_url varchar(255), primary key (id))
Hibernate: create table shelter_media_entity (id bigint generated by default as identity, shelter_id bigint, description varchar(255), media_type varchar(255), media_url varchar(255), primary key (id))
Hibernate: create table trial_cohabitation_entity (approved boolean, end_date date, start_date date, id bigint not null, notes varchar(255), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, register_date timestamp(6), email varchar(255), name varchar(255), password varchar(255), phone_number varchar(255), profile_image_url varchar(255), primary key (id))
Hibernate: create table vaccine_entry_entity (admin_date date, next_due_date date, id bigint generated by default as identity, medical_history_id bigint, vaccine_name varchar(255), primary key (id))
Hibernate: create table vet_speciality_relation (speciality_id bigint not null, vet_id bigint not null)
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability_schedule varchar(255), license_number varchar(255), primary key (id))
Hibernate: create table vet_speciality_entity (id bigint generated by default as identity, description varchar(255), name 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 FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_entity add constraint FK8x0rs5b3npfj9w92mh30nhdd5 foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists adoption_process_entity add constraint FK1wpy6iv96dq7w9my6g9bl77gi foreign key (adoption_request_id) references adoption_request_entity
Hibernate: alter table if exists adoption_process_entity add constraint FK72me1bmmr6kq9uqkueiybt921 foreign key (pet_id) references pet_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 FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_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_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists medical_history_entity add constraint FKnur7g43m7dj3kc7bq5q33v0eo foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists message_entity add constraint FKf1eboma4d9p0wlj48qwpd2ban foreign key (receiver_id) references user_entity
Hibernate: alter table if exists message_entity add constraint FKchngvnhlot2wncosjrnmd1qjp foreign key (sender_id) references user_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 return_case_entity add constraint FKq5oky202hvs0kv9upfkolmn88 foreign key (adoption_process_id) references adoption_process_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 FKg0jyjvg2qkjrywc3aib0r7iqq foreign key (adoption_process_id) references adoption_process_entity
Hibernate: alter table if exists review_entity add constraint FKrt9pkjnacboa4fc7ug82wm7cw foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists shelter_media_entity add constraint FK6couwlbflod3yxf2r9yu7augk foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK15m52vl1kqpw9j5fsv1osa8jx foreign key (id) references adoption_process_entity
Hibernate: alter table if exists vaccine_entry_entity add constraint FKiljjk4cjlbiilp7fohur5nf5g foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vet_speciality_relation add constraint FK6hx84a5ij49rxm81pmx8t6mq7 foreign key (speciality_id) references vet_speciality_entity
Hibernate: alter table if exists vet_speciality_relation add constraint FKco5ttqfls718a193w5l2np2oe foreign key (vet_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-23T03:16:17.128Z INFO 73 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T03:16:17.225Z INFO 73 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : Started MedicalHistoryServiceTest in 0.304 seconds (process running for 30.017)
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: select mhe1_0.id,mhe1_0.created_date,mhe1_0.last_updated,p1_0.id,p1_0.born_date,p1_0.breed,p1_0.is_rescued,p1_0.name,p1_0.sex,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,p1_0.size,p1_0.specific_needs,p1_0.status,p1_0.temperament,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id left join shelter_entity s1_0 on s1_0.id=p1_0.shelter_id left join veterinarian_entity v1_0 on v1_0.id=mhe1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s2_0 on s2_0.id=v1_0.shelter_id where mhe1_0.id=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: select ve1_0.id,ve1_1.email,ve1_1.name,ve1_1.password,ve1_1.phone_number,ve1_1.profile_image_url,ve1_1.register_date,ve1_0.availability_schedule,ve1_0.license_number,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url from veterinarian_entity ve1_0 join user_entity ve1_1 on ve1_0.id=ve1_1.id left join shelter_entity s1_0 on s1_0.id=ve1_0.shelter_id where ve1_0.id=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: select mhe1_0.id,mhe1_0.created_date,mhe1_0.last_updated,mhe1_0.pet_id,mhe1_0.veterinarian_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=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: select mhe1_0.id,mhe1_0.created_date,mhe1_0.last_updated,mhe1_0.pet_id,mhe1_0.veterinarian_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=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: select mhe1_0.id,mhe1_0.created_date,mhe1_0.last_updated,mhe1_0.pet_id,mhe1_0.veterinarian_id from medical_history_entity mhe1_0
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: select mhe1_0.id,mhe1_0.created_date,mhe1_0.last_updated,p1_0.id,p1_0.born_date,p1_0.breed,p1_0.is_rescued,p1_0.name,p1_0.sex,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,p1_0.size,p1_0.specific_needs,p1_0.status,p1_0.temperament,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id left join shelter_entity s1_0 on s1_0.id=p1_0.shelter_id left join veterinarian_entity v1_0 on v1_0.id=mhe1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s2_0 on s2_0.id=v1_0.shelter_id where mhe1_0.id=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: select pe1_0.id,pe1_0.born_date,pe1_0.breed,pe1_0.is_rescued,mh1_0.id,mh1_0.created_date,mh1_0.last_updated,v1_0.id,v1_1.email,v1_1.name,v1_1.password,v1_1.phone_number,v1_1.profile_image_url,v1_1.register_date,v1_0.availability_schedule,v1_0.license_number,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.location_details,s1_0.nit,s1_0.phone_number,s1_0.shelter_name,s1_0.status,s1_0.website_url,pe1_0.name,pe1_0.sex,s2_0.id,s2_0.address,s2_0.city,s2_0.description,s2_0.location_details,s2_0.nit,s2_0.phone_number,s2_0.shelter_name,s2_0.status,s2_0.website_url,pe1_0.size,pe1_0.specific_needs,pe1_0.status,pe1_0.temperament from pet_entity pe1_0 left join medical_history_entity mh1_0 on pe1_0.id=mh1_0.pet_id left join veterinarian_entity v1_0 on v1_0.id=mh1_0.veterinarian_id left join user_entity v1_1 on v1_0.id=v1_1.id left join shelter_entity s1_0 on s1_0.id=v1_0.shelter_id left join shelter_entity s2_0 on s2_0.id=pe1_0.shelter_id where pe1_0.id=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into HT_veterinarian_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from vet_speciality_relation to_delete_ where to_delete_.vet_id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_veterinarian_entity temptable_)
Hibernate: delete from HT_veterinarian_entity
Hibernate: delete from vet_speciality_relation to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (address,city,description,location_details,nit,phone_number,shelter_name,status,website_url,id) values (?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone_number,profile_image_url,register_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability_schedule,license_number,shelter_id,id) values (?,?,?,?)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (born_date,breed,is_rescued,name,sex,shelter_id,size,specific_needs,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
Hibernate: insert into medical_history_entity (created_date,last_updated,pet_id,veterinarian_id,id) values (?,?,?,?,default)
[INFO] Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.495 s -- in co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
[INFO]
[INFO] Results:
[INFO]
[INFO] Tests run: 280, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 32.107 s
[INFO] Finished at: 2026-03-23T03:16:17Z
[INFO] ------------------------------------------------------------------------
![[Jenkins]](/jenkins/static/1229cee1/images/svgs/logo.svg){kind=logo}
