Console Output
Skipping 468 KB..
Full Log_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into adoption_follow_up_entity (adoption_id,frequency,notes,pet_id,veterinarian_id,id) values (?,?,?,?,?,default)
2026-03-23T04:06:40.438Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 30
2026-03-23T04:06:40.438Z WARN 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Attempted to delete veterinarian 30 with active adoption follow-ups
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.447Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Updating veterinarian with id = 32
2026-03-23T04:06:40.447Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Updating user with id = 32
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,ue1_2.shelter_id,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id where ue1_0.email=?
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.458Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Starting creation process for veterinarian: M0s3oQ5mWS
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.469Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Updating veterinarian with id = 38
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.478Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Updating veterinarian with id = 41
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.486Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Updating veterinarian with id = 44
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.496Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Updating veterinarian with id = 47
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.505Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Updating veterinarian with id = 50
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.513Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Updating veterinarian with id = 53
Hibernate: delete from medical_event_entity mee1_0
Hibernate: delete from vaccination_record_entity vre1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: insert into HT_user_entity(id) select ve1_0.id from veterinarian_entity ve1_0
Hibernate: delete from veterinarian_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from user_entity to_delete_ where to_delete_.id in (select temptable_.id from HT_user_entity temptable_)
Hibernate: delete from HT_user_entity
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
2026-03-23T04:06:40.520Z INFO 71 --- [ main] c.e.u.m.p.services.VeterinarianService : Updating veterinarian with id = 999
2026-03-23T04:06:40.521Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Updating user with id = 999
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id left join shelter_entity s1_0 on s1_0.id=ue1_2.shelter_id where ue1_0.id=?
[INFO] Tests run: 19, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.598 s -- in co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.UserServiceTest
2026-03-23T04:06:40.527Z INFO 71 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.UserServiceTest]: UserServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T04:06:40.545Z INFO 71 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.UserServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-03-23T04:06:40.559Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : Starting UserServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-23T04:06:40.559Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-23T04:06:40.611Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T04:06:40.628Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 16 ms. Found 19 JPA repository interfaces.
2026-03-23T04:06:40.640Z INFO 71 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T04:06:40.649Z INFO 71 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:09904bed-1818-4621-a5d5-d81bf602827d;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T04:06:40.661Z INFO 71 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T04:06:40.663Z INFO 71 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-23T04:06:40.670Z INFO 71 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T04:06:40.671Z WARN 71 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-23T04:06:40.671Z INFO 71 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@6e066af']
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_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-03-23T04:06:40.774Z INFO 71 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, shelter_id bigint, strategy_id bigint, primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-03-23T04:06:40.798Z INFO 71 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T04:06:40.922Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : Started UserServiceTest in 0.375 seconds (process running for 19.981)
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id left join shelter_entity s1_0 on s1_0.id=ue1_2.shelter_id where ue1_0.id=?
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:40.944Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Updating user with id = 4
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,ue1_2.shelter_id,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id where ue1_0.email=?
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:40.955Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Updating user with id = 999
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id left join shelter_entity s1_0 on s1_0.id=ue1_2.shelter_id where ue1_0.id=?
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:40.964Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: valid@email.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,ue1_2.shelter_id,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:40.982Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: duplicate@test.com
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,ue1_2.shelter_id,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id where ue1_0.email=?
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:40.992Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: user0@test.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.000Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user:
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.007Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: valid@email.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.014Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: null
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.024Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: valid@email.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.041Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Updating user with id = 38
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.048Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Updating user with id = 41
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,ue1_2.shelter_id,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id where ue1_0.email=?
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.058Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 44
Hibernate: select count(ae1_0.id) from adoption_entity ae1_0 where ae1_0.adopter_id=?
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.080Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: valid@email.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.091Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Updating user with id = 53
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id left join shelter_entity s1_0 on s1_0.id=ue1_2.shelter_id where ue1_0.id=?
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,ue1_2.shelter_id,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id where ue1_0.email=?
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.110Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: newunique@test.com
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,ue1_2.shelter_id,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id where ue1_0.email=?
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.120Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: email_sin_arroba.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.128Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: nuevo@correo.com
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,ue1_2.shelter_id,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id where ue1_0.email=?
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-23T04:06:41.140Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 69
Hibernate: select count(ae1_0.id) from adoption_entity ae1_0 where ae1_0.adopter_id=?
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.149Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: correo-sin-arroba.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.156Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: ot7OkcmBbK
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.163Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: valid@email.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.178Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: valid@email.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.185Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: user0@test.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.192Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: valido@test.com
Hibernate: delete from adoption_entity ae1_0
Hibernate: delete from mock_user to_delete_
Hibernate: delete from veterinarian_entity to_delete_
Hibernate: delete from adopter_entity to_delete_
Hibernate: delete from user_entity ue1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-23T04:06:41.232Z INFO 71 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 999
Hibernate: select ue1_0.id,case when ue1_1.id is not null then 1 when ue1_2.id is not null then 2 when ue1_3.id is not null then 3 end,ue1_0.email,ue1_0.name,ue1_0.password,ue1_0.phone,ue1_1.has_children,ue1_1.has_other_pets,ue1_1.housing_type,ue1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ue1_2.specialty from user_entity ue1_0 left join adopter_entity ue1_1 on ue1_0.id=ue1_1.id left join veterinarian_entity ue1_2 on ue1_0.id=ue1_2.id left join mock_user ue1_3 on ue1_0.id=ue1_3.id left join shelter_entity s1_0 on s1_0.id=ue1_2.shelter_id where ue1_0.id=?
[INFO] Tests run: 29, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.710 s -- in co.edu.udistrital.mdp.pets.services.UserServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
2026-03-23T04:06:41.238Z INFO 71 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest]: TrialCohabitationServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T04:06:41.243Z INFO 71 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-03-23T04:06:41.257Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : Starting TrialCohabitationServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-23T04:06:41.257Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-23T04:06:41.312Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T04:06:41.332Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 17 ms. Found 19 JPA repository interfaces.
2026-03-23T04:06:41.354Z INFO 71 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T04:06:41.368Z INFO 71 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:dbe5b873-0fa4-4c4c-a8d4-f14321ca0c3f;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T04:06:41.381Z INFO 71 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T04:06:41.383Z INFO 71 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-23T04:06:41.391Z INFO 71 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T04:06:41.392Z WARN 71 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-23T04:06:41.392Z INFO 71 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@3ac79d4c']
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_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-03-23T04:06:41.515Z INFO 71 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, shelter_id bigint, strategy_id bigint, primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-03-23T04:06:41.538Z INFO 71 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T04:06:41.657Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : Started TrialCohabitationServiceTest in 0.412 seconds (process running for 20.716)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.665Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 4
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.672Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.678Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting process to consult trial cohabitation with id = 999
Hibernate: select tce1_0.id,a1_0.id,a2_0.id,a2_1.email,a2_1.name,a2_1.password,a2_1.phone,a2_0.has_children,a2_0.has_other_pets,a2_0.housing_type,a1_0.adoption_date,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,mh1_0.id,mh1_0.description,mh1_0.last_checkout,mh1_0.notes,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament,a1_0.status,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0 left join adoption_entity a1_0 on a1_0.id=tce1_0.adoption_id left join adopter_entity a2_0 on a2_0.id=a1_0.adopter_id left join user_entity a2_1 on a2_0.id=a2_1.id left join pet_entity p1_0 on p1_0.id=a1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id where tce1_0.id=?
2026-03-23T04:06:41.680Z ERROR 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id 999 not found
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.687Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.694Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 17
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.701Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 21
2026-03-23T04:06:41.701Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 21 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.707Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 22
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.713Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 999
Hibernate: select tce1_0.id,a1_0.id,a2_0.id,a2_1.email,a2_1.name,a2_1.password,a2_1.phone,a2_0.has_children,a2_0.has_other_pets,a2_0.housing_type,a1_0.adoption_date,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,mh1_0.id,mh1_0.description,mh1_0.last_checkout,mh1_0.notes,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament,a1_0.status,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0 left join adoption_entity a1_0 on a1_0.id=tce1_0.adoption_id left join adopter_entity a2_0 on a2_0.id=a1_0.adopter_id left join user_entity a2_1 on a2_0.id=a2_1.id left join pet_entity p1_0 on p1_0.id=a1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id where tce1_0.id=?
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.720Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 31
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.726Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting process to consult all trial cohabitations
Hibernate: select tce1_0.id,tce1_0.adoption_id,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.734Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.740Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 41
2026-03-23T04:06:41.742Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 41 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.747Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 42
2026-03-23T04:06:41.748Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 42 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.753Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 48
2026-03-23T04:06:41.754Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 48 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.760Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 52
2026-03-23T04:06:41.760Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 52 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.766Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.772Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 59
2026-03-23T04:06:41.773Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 59 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.779Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 60
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.785Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-03-23T04:06:41.785Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.791Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-03-23T04:06:41.791Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.796Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 74
2026-03-23T04:06:41.797Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 74 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.803Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 78
2026-03-23T04:06:41.803Z WARN 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Attempted to delete trial cohabitation 78 but it is in progress
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.809Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.814Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting process to consult trial cohabitation with id = 82
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.819Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 999
Hibernate: select tce1_0.id,a1_0.id,a2_0.id,a2_1.email,a2_1.name,a2_1.password,a2_1.phone,a2_0.has_children,a2_0.has_other_pets,a2_0.housing_type,a1_0.adoption_date,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,mh1_0.id,mh1_0.description,mh1_0.last_checkout,mh1_0.notes,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament,a1_0.status,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0 left join adoption_entity a1_0 on a1_0.id=tce1_0.adoption_id left join adopter_entity a2_0 on a2_0.id=a1_0.adopter_id left join user_entity a2_1 on a2_0.id=a2_1.id left join pet_entity p1_0 on p1_0.id=a1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id where tce1_0.id=?
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.825Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-03-23T04:06:41.826Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.832Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 95
2026-03-23T04:06:41.832Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 95 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.880Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 99
2026-03-23T04:06:41.880Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 99 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.890Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.897Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 106
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-23T04:06:41.904Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 107
2026-03-23T04:06:41.904Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 107 updated successfully
[INFO] Tests run: 31, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.669 s -- in co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
2026-03-23T04:06:41.910Z INFO 71 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest]: MedicalHistoryServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T04:06:41.917Z INFO 71 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-03-23T04:06:41.935Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : Starting MedicalHistoryServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-23T04:06:41.935Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-23T04:06:42.003Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T04:06:42.024Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 19 JPA repository interfaces.
2026-03-23T04:06:42.039Z INFO 71 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T04:06:42.050Z INFO 71 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:df0e4d73-a84b-4bb7-9d06-4d5b510360a3;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T04:06:42.066Z INFO 71 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T04:06:42.068Z INFO 71 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-23T04:06:42.076Z INFO 71 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T04:06:42.078Z WARN 71 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-23T04:06:42.078Z INFO 71 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@155acba5']
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_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-03-23T04:06:42.228Z INFO 71 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, shelter_id bigint, strategy_id bigint, primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-03-23T04:06:42.262Z INFO 71 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T04:06:42.399Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : Started MedicalHistoryServiceTest in 0.48 seconds (process running for 21.458)
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.417Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando eliminación de la historia clínica ID: 999999
Hibernate: select count(*) from medical_history_entity mhe1_0 where mhe1_0.id=?
2026-03-23T04:06:42.420Z ERROR 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Intento de eliminar historia clínica inexistente con ID: 999999
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.431Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Consultando historia clínica con id = 4
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.442Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando actualización de historia clínica con id = 7
2026-03-23T04:06:42.443Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Historia clínica con id = 7 actualizada exitosamente
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
2026-03-23T04:06:42.454Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando actualización de historia clínica con id = 123456789
Hibernate: select mhe1_0.id,mhe1_0.description,mhe1_0.last_checkout,mhe1_0.notes,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where mhe1_0.id=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
2026-03-23T04:06:42.467Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando la creación de la historia clínica
Hibernate: select mhe1_0.id from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where p1_0.id=? fetch first ? rows only
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.470Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Historia clínica creada exitosamente
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.479Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando eliminación de la historia clínica ID: 19
Hibernate: select count(*) from medical_history_entity mhe1_0 where mhe1_0.id=?
2026-03-23T04:06:42.481Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Historia clínica ID: 19 eliminada exitosamente
2026-03-23T04:06:42.482Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Consultando historia clínica con id = 19
2026-03-23T04:06:42.482Z ERROR 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Historia clínica con id 19 no encontrada
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.493Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando la creación de la historia clínica
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.502Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando la creación de la historia clínica
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.511Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando actualización de historia clínica con id = 27
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-03-23T04:06:42.520Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando la creación de la historia clínica
Hibernate: select mhe1_0.id from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where p1_0.id=? fetch first ? rows only
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.616 s -- in co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VaccineServiceTest
2026-03-23T04:06:42.527Z INFO 71 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.VaccineServiceTest]: VaccineServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-23T04:06:42.531Z INFO 71 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.VaccineServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-03-23T04:06:42.546Z INFO 71 --- [ main] c.e.u.m.p.services.VaccineServiceTest : Starting VaccineServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-23T04:06:42.546Z INFO 71 --- [ main] c.e.u.m.p.services.VaccineServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-23T04:06:42.593Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-23T04:06:42.610Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 15 ms. Found 19 JPA repository interfaces.
2026-03-23T04:06:42.621Z INFO 71 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-23T04:06:42.630Z INFO 71 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:7ffc89a8-0a25-46f8-8c3f-f9efa8228287;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-23T04:06:42.645Z INFO 71 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-23T04:06:42.647Z INFO 71 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-23T04:06:42.654Z INFO 71 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-23T04:06:42.655Z WARN 71 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-23T04:06:42.656Z INFO 71 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@64cf29bb']
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_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-03-23T04:06:42.778Z INFO 71 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, shelter_id bigint, strategy_id bigint, primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-03-23T04:06:42.805Z INFO 71 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-23T04:06:42.927Z INFO 71 --- [ main] c.e.u.m.p.services.VaccineServiceTest : Started VaccineServiceTest in 0.394 seconds (process running for 21.986)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select ve1_0.id,ve1_0.description,ve1_0.name,ve1_0.validity_months from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.468 s -- in co.edu.udistrital.mdp.pets.services.VaccineServiceTest
[INFO]
[INFO] Results:
[INFO]
[INFO] Tests run: 344, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 23.810 s
[INFO] Finished at: 2026-03-23T04:06:43Z
[INFO] ------------------------------------------------------------------------
![[Jenkins]](/jenkins/static/1229cee1/images/svgs/logo.svg){kind=logo}
