Console Output
Skipping 686 KB..
Full Logues (?,?,?,?,?)
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-22T21:50:43.577Z INFO 92 --- [ 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-22T21:50:43.590Z INFO 92 --- [ 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-22T21:50:43.604Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Create trial cohabitation
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.514 s -- in co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ReturnCaseServiceTest
2026-03-22T21:50:43.619Z INFO 92 --- [ 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-22T21:50:43.622Z INFO 92 --- [ 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-22T21:50:43.646Z INFO 92 --- [ main] c.e.u.m.p.s.ReturnCaseServiceTest : Starting ReturnCaseServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E2_Back)
2026-03-22T21:50:43.646Z INFO 92 --- [ main] c.e.u.m.p.s.ReturnCaseServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-22T21:50:43.704Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-22T21:50:43.719Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14 ms. Found 18 JPA repository interfaces.
2026-03-22T21:50:43.729Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-22T21:50:43.736Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:f5e74d77-f4e9-4cb7-8a94-5cd24d95744d;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-22T21:50:43.748Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-22T21:50:43.749Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-22T21:50:43.755Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-22T21:50:43.756Z WARN 92 --- [ 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-22T21:50:43.757Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@30f9a92f']
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-22T21:50:43.869Z INFO 92 --- [ 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-22T21:50:43.895Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-22T21:50:44.012Z INFO 92 --- [ main] c.e.u.m.p.s.ReturnCaseServiceTest : Started ReturnCaseServiceTest in 0.386 seconds (process running for 29.865)
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-22T21:50:44.020Z INFO 92 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de consultar el caso de devolución con id = 1
2026-03-22T21:50:44.021Z INFO 92 --- [ 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-22T21:50:44.028Z INFO 92 --- [ 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-22T21:50:44.050Z INFO 92 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de borrar el caso de devolución con id = 8
2026-03-22T21:50:44.051Z INFO 92 --- [ 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-22T21:50:44.057Z INFO 92 --- [ 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-22T21:50:44.065Z INFO 92 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de actualizar el caso de devolución con id = 13
2026-03-22T21:50:44.065Z INFO 92 --- [ 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-22T21:50:44.072Z INFO 92 --- [ 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-22T21:50:44.078Z INFO 92 --- [ 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-22T21:50:44.086Z INFO 92 --- [ 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-22T21:50:44.101Z INFO 92 --- [ 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-22T21:50:44.108Z INFO 92 --- [ main] c.e.u.m.pets.services.ReturnCaseService : Inicia proceso de creación del caso de devolución
2026-03-22T21:50:44.108Z INFO 92 --- [ 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.497 s -- in co.edu.udistrital.mdp.pets.services.ReturnCaseServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.AdoptionProcessServiceTest
2026-03-22T21:50:44.113Z INFO 92 --- [ 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-22T21:50:44.117Z INFO 92 --- [ 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-22T21:50:44.129Z INFO 92 --- [ main] c.e.u.m.p.s.AdoptionProcessServiceTest : Starting AdoptionProcessServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E2_Back)
2026-03-22T21:50:44.129Z INFO 92 --- [ main] c.e.u.m.p.s.AdoptionProcessServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-22T21:50:44.200Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-22T21:50:44.224Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 23 ms. Found 18 JPA repository interfaces.
2026-03-22T21:50:44.234Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-22T21:50:44.242Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:99eaf874-05f3-4f32-b7d6-7a95f0019d95;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-22T21:50:44.253Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-22T21:50:44.255Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-22T21:50:44.263Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-22T21:50:44.264Z WARN 92 --- [ 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-22T21:50:44.265Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@41b6fc97']
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-22T21:50:44.357Z INFO 92 --- [ 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-22T21:50:44.388Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-22T21:50:44.585Z INFO 92 --- [ main] c.e.u.m.p.s.AdoptionProcessServiceTest : Started AdoptionProcessServiceTest in 0.466 seconds (process running for 30.439)
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-22T21:50:44.617Z INFO 92 --- [ 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-22T21:50:44.636Z INFO 92 --- [ 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-22T21:50:44.649Z INFO 92 --- [ 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-22T21:50:44.660Z INFO 92 --- [ 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-22T21:50:44.673Z INFO 92 --- [ 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-22T21:50:44.687Z INFO 92 --- [ 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-22T21:50:44.703Z INFO 92 --- [ 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-22T21:50:44.717Z INFO 92 --- [ 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-22T21:50:44.733Z INFO 92 --- [ 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-22T21:50:44.761Z INFO 92 --- [ 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-22T21:50:44.776Z INFO 92 --- [ 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-22T21:50:44.789Z INFO 92 --- [ 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.681 s -- in co.edu.udistrital.mdp.pets.services.AdoptionProcessServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
2026-03-22T21:50:44.795Z INFO 92 --- [ 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-22T21:50:44.799Z INFO 92 --- [ 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-22T21:50:44.811Z INFO 92 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : Starting MedicalHistoryServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E2_Back)
2026-03-22T21:50:44.811Z INFO 92 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-22T21:50:44.857Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-22T21:50:44.873Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 15 ms. Found 18 JPA repository interfaces.
2026-03-22T21:50:44.883Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-22T21:50:44.890Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:7719e3c2-bb1f-4ce9-8869-4c797138c843;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-22T21:50:44.901Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-22T21:50:44.903Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-22T21:50:44.910Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-22T21:50:44.911Z WARN 92 --- [ 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-22T21:50:44.911Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@40bc74be']
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-22T21:50:44.993Z INFO 92 --- [ 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-22T21:50:45.008Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-22T21:50:45.099Z INFO 92 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : Started MedicalHistoryServiceTest in 0.298 seconds (process running for 30.952)
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.478 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] --- jar:3.4.2:jar (default-jar) @ MP_202610_G81_E2_Back ---
[INFO] Building jar: /home/cecaduser/workspace/MP_202610_G81_E2_Back/target/MP_202610_G81_E2_Back-0.0.1-SNAPSHOT.jar
[INFO]
[INFO] --- spring-boot:3.5.11:repackage (repackage) @ MP_202610_G81_E2_Back ---
[INFO] Replacing main artifact /home/cecaduser/workspace/MP_202610_G81_E2_Back/target/MP_202610_G81_E2_Back-0.0.1-SNAPSHOT.jar with repackaged archive, adding nested dependencies in BOOT-INF/.
[INFO] The original artifact has been renamed to /home/cecaduser/workspace/MP_202610_G81_E2_Back/target/MP_202610_G81_E2_Back-0.0.1-SNAPSHOT.jar.original
[INFO]
[INFO] --- jacoco:0.8.11:report (jacoco-site) @ MP_202610_G81_E2_Back ---
[INFO] Loading execution data file /home/cecaduser/workspace/MP_202610_G81_E2_Back/target/jacoco.exec
[INFO] Analyzed bundle 'MP_202610_G81_E2_Back' with 27 classes
[INFO]
[INFO] --- install:3.1.4:install (default-install) @ MP_202610_G81_E2_Back ---
[INFO] Installing /home/cecaduser/workspace/MP_202610_G81_E2_Back/pom.xml to /root/.m2/repository/co/edu/udistrital/mdp/MP_202610_G81_E2_Back/0.0.1-SNAPSHOT/MP_202610_G81_E2_Back-0.0.1-SNAPSHOT.pom
[INFO] Installing /home/cecaduser/workspace/MP_202610_G81_E2_Back/target/MP_202610_G81_E2_Back-0.0.1-SNAPSHOT.jar to /root/.m2/repository/co/edu/udistrital/mdp/MP_202610_G81_E2_Back/0.0.1-SNAPSHOT/MP_202610_G81_E2_Back-0.0.1-SNAPSHOT.jar
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 39.243 s
[INFO] Finished at: 2026-03-22T21:50:47Z
[INFO] ------------------------------------------------------------------------
![[Jenkins]](/jenkins/static/1229cee1/images/svgs/logo.svg){kind=logo}
