Console Output
Skipping 96 KB..
Full Log(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, 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, id bigint generated by default as identity, medical_history_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 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-21T13:52:49.814Z INFO 109 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T13:52:50.140Z INFO 109 --- [ main] c.e.u.m.p.services.AdoptionServiceTest : Started AdoptionServiceTest in 0.904 seconds (process running for 11.455)
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.182Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting update process for adoption with id = 1
2026-03-21T13:52:50.185Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Adoption with id = 1 updated successfully
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.213Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting process to consult all adoptions
Hibernate: select ae1_0.id,ae1_0.adopter_id,ae1_0.adoption_date,ae1_0.pet_id,ae1_0.status from adoption_entity ae1_0
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.245Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting creation process for adoption
2026-03-21T13:52:50.246Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Adoption created successfully
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.278Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting update process for adoption with id = 999
Hibernate: select ae1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone,a1_0.has_children,a1_0.has_other_pets,a1_0.housing_type,ae1_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,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,ae1_0.status,tc1_0.id,tc1_0.end_date,tc1_0.pet_id,tc1_0.result,tc1_0.start_date,tc1_0.status from adoption_entity ae1_0 left join adopter_entity a1_0 on a1_0.id=ae1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ae1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join trial_cohabitation_entity tc1_0 on ae1_0.id=tc1_0.adoption_id where ae1_0.id=?
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_follow_up_entity (adoption_id,frequency,notes,pet_id,veterinarian_id,id) values (?,?,?,?,?,default)
2026-03-21T13:52:50.323Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting deletion process for adoption ID: 14
2026-03-21T13:52:50.324Z WARN 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Attempted to delete adoption 14 but it has follow-ups
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.345Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting creation process for adoption
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.368Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting process to consult adoption with id = 999
Hibernate: select ae1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone,a1_0.has_children,a1_0.has_other_pets,a1_0.housing_type,ae1_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,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,ae1_0.status,tc1_0.id,tc1_0.end_date,tc1_0.pet_id,tc1_0.result,tc1_0.start_date,tc1_0.status from adoption_entity ae1_0 left join adopter_entity a1_0 on a1_0.id=ae1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ae1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join trial_cohabitation_entity tc1_0 on ae1_0.id=tc1_0.adoption_id where ae1_0.id=?
2026-03-21T13:52:50.373Z ERROR 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Adoption with id 999 not found
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.391Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting deletion process for adoption ID: 23
2026-03-21T13:52:50.392Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Adoption with ID: 23 deleted successfully
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.406Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting process to consult adoption with id = 26
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.420Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting deletion process for adoption ID: 999
Hibernate: select ae1_0.id,a1_0.id,a1_1.email,a1_1.name,a1_1.password,a1_1.phone,a1_0.has_children,a1_0.has_other_pets,a1_0.housing_type,ae1_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,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,ae1_0.status,tc1_0.id,tc1_0.end_date,tc1_0.pet_id,tc1_0.result,tc1_0.start_date,tc1_0.status from adoption_entity ae1_0 left join adopter_entity a1_0 on a1_0.id=ae1_0.adopter_id left join user_entity a1_1 on a1_0.id=a1_1.id left join pet_entity p1_0 on p1_0.id=ae1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id left join trial_cohabitation_entity tc1_0 on ae1_0.id=tc1_0.adoption_id where ae1_0.id=?
Hibernate: delete from adoption_follow_up_entity afue1_0
Hibernate: delete from adoption_entity ae1_0
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
Hibernate: insert into adoption_entity (adopter_id,adoption_date,pet_id,status,id) values (?,?,?,?,default)
2026-03-21T13:52:50.435Z INFO 109 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting update process for adoption with id = 32
[INFO] Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.227 s -- in co.edu.udistrital.mdp.pets.services.AdoptionServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ShelterServiceTest
2026-03-21T13:52:50.448Z INFO 109 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.ShelterServiceTest]: ShelterServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-21T13:52:50.463Z INFO 109 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.ShelterServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-03-21T13:52:50.488Z INFO 109 --- [ main] c.e.u.m.p.services.ShelterServiceTest : Starting ShelterServiceTest using Java 21.0.4 with PID 109 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T13:52:50.489Z INFO 109 --- [ main] c.e.u.m.p.services.ShelterServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T13:52:50.569Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T13:52:50.614Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 43 ms. Found 19 JPA repository interfaces.
2026-03-21T13:52:50.637Z INFO 109 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T13:52:50.653Z INFO 109 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:425d0370-d189-4886-bc5e-9e253698603b;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T13:52:50.678Z INFO 109 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T13:52:50.680Z INFO 109 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T13:52:50.689Z INFO 109 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T13:52:50.691Z WARN 109 --- [ 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-21T13:52:50.691Z INFO 109 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@32b2f9a4']
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_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
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
2026-03-21T13:52:50.879Z INFO 109 --- [ 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, diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (id bigint generated by default as identity, pet_id bigint unique, 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, 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, id bigint generated by default as identity, medical_history_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 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-21T13:52:50.938Z INFO 109 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T13:52:51.137Z INFO 109 --- [ main] c.e.u.m.p.services.ShelterServiceTest : Started ShelterServiceTest in 0.671 seconds (process running for 12.452)
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
2026-03-21T13:52:51.156Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting process to consult shelter with id = 1
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
2026-03-21T13:52:51.171Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting update process for shelter with id = 4
Hibernate: select se1_0.id from shelter_entity se1_0 where se1_0.name=? fetch first ? rows only
Hibernate: select se1_0.id from shelter_entity se1_0 where se1_0.email=? fetch first ? rows only
2026-03-21T13:52:51.179Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Shelter with id = 4 updated successfully
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
2026-03-21T13:52:51.194Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting creation process for shelter: tpaJ6RBFPX
Hibernate: select se1_0.id from shelter_entity se1_0 where se1_0.name=? fetch first ? rows only
Hibernate: select se1_0.id from shelter_entity se1_0 where se1_0.email=? fetch first ? rows only
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_event_entity (date,description,location,shelter_id,status,title,id) values (?,?,?,?,?,?,default)
2026-03-21T13:52:51.221Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting deletion process for shelter ID: 13
2026-03-21T13:52:51.221Z WARN 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Attempted to delete shelter 13 but it has active events
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
2026-03-21T13:52:51.235Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting process to consult shelter with id = 999
Hibernate: select se1_0.id,se1_0.city,se1_0.description,se1_0.email,se1_0.gallery,se1_0.name from shelter_entity se1_0 where se1_0.id=?
2026-03-21T13:52:51.236Z ERROR 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Shelter with id 999 not found
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
2026-03-21T13:52:51.249Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting deletion process for shelter ID: 17
2026-03-21T13:52:51.250Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Shelter with ID: 17 deleted successfully
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,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-21T13:52:51.269Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting deletion process for shelter ID: 20
2026-03-21T13:52:51.270Z WARN 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Attempted to delete shelter 20 but it has pets
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
2026-03-21T13:52:51.285Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting creation process for shelter: Shelter 0
Hibernate: select se1_0.id from shelter_entity se1_0 where se1_0.name=? fetch first ? rows only
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
2026-03-21T13:52:51.301Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting process to consult all shelters
Hibernate: select se1_0.id,se1_0.city,se1_0.description,se1_0.email,se1_0.gallery,se1_0.name from shelter_entity se1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: delete from shelter_event_entity see1_0
Hibernate: delete from shelter_entity se1_0
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
2026-03-21T13:52:51.316Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting creation process for shelter: New Unique Shelter
Hibernate: select se1_0.id from shelter_entity se1_0 where se1_0.name=? fetch first ? rows only
Hibernate: select se1_0.id from shelter_entity se1_0 where se1_0.email=? fetch first ? rows only
2026-03-21T13:52:51.320Z INFO 109 --- [ main] c.e.u.mdp.pets.services.ShelterService : Shelter created successfully: New Unique Shelter
Hibernate: insert into shelter_entity (city,description,email,gallery,name,id) values (?,?,?,?,?,default)
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.882 s -- in co.edu.udistrital.mdp.pets.services.ShelterServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.PetServiceTest
2026-03-21T13:52:51.330Z INFO 109 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.PetServiceTest]: PetServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-21T13:52:51.342Z INFO 109 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.PetServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-03-21T13:52:51.363Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : Starting PetServiceTest using Java 21.0.4 with PID 109 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T13:52:51.363Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T13:52:51.433Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T13:52:51.456Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 21 ms. Found 19 JPA repository interfaces.
2026-03-21T13:52:51.475Z INFO 109 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T13:52:51.487Z INFO 109 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:3bd92576-615a-47dd-bb30-e3155a7e15bc;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T13:52:51.506Z INFO 109 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T13:52:51.508Z INFO 109 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T13:52:51.516Z INFO 109 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T13:52:51.517Z WARN 109 --- [ 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-21T13:52:51.518Z INFO 109 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@6fd384a5']
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_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
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
2026-03-21T13:52:51.687Z INFO 109 --- [ 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, diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (id bigint generated by default as identity, pet_id bigint unique, 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, 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, id bigint generated by default as identity, medical_history_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 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-21T13:52:51.734Z INFO 109 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T13:52:51.900Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : Started PetServiceTest in 0.556 seconds (process running for 13.215)
Hibernate: delete from trial_cohabitation_entity tce1_0
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 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 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-21T13:52:51.921Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetService : Creating pet: pDgo6dNXFL
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,pet_id,id) values (?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
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 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 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 trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-21T13:52:51.941Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetService : Deleting pet with id = 6
Hibernate: delete from trial_cohabitation_entity tce1_0
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 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 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-21T13:52:51.957Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetService : Processing return for pet with id = 8
Hibernate: delete from trial_cohabitation_entity tce1_0
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 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 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-21T13:52:51.973Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetService : Creating pet: PRBupQUKE1
Hibernate: delete from trial_cohabitation_entity tce1_0
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 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 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: update pet_entity set 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=? where id=?
2026-03-21T13:52:52.000Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetService : Processing return for pet with id = 14
2026-03-21T13:52:52.000Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetService : Pet with id = 14 is now available for adoption again
Hibernate: delete from trial_cohabitation_entity tce1_0
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 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 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 trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-03-21T13:52:52.019Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetService : Updating pet with id = 17
Hibernate: delete from trial_cohabitation_entity tce1_0
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 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 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-21T13:52:52.035Z INFO 109 --- [ main] c.e.u.mdp.pets.services.PetService : Updating pet with id = 20
[INFO] Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.711 s -- in co.edu.udistrital.mdp.pets.services.PetServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
2026-03-21T13:52:52.043Z INFO 109 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest]: VeterinarianServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-03-21T13:52:52.046Z INFO 109 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-03-21T13:52:52.066Z INFO 109 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : Starting VeterinarianServiceTest using Java 21.0.4 with PID 109 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T13:52:52.066Z INFO 109 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T13:52:52.131Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T13:52:52.152Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 19 JPA repository interfaces.
2026-03-21T13:52:52.169Z INFO 109 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T13:52:52.181Z INFO 109 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:ac6fe6c9-6e43-4522-9c85-1794380256ef;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T13:52:52.198Z INFO 109 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T13:52:52.200Z INFO 109 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T13:52:52.208Z INFO 109 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T13:52:52.209Z WARN 109 --- [ 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-21T13:52:52.210Z INFO 109 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@468581d2']
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_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
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
2026-03-21T13:52:52.342Z INFO 109 --- [ 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, diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (id bigint generated by default as identity, pet_id bigint unique, 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, 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, id bigint generated by default as identity, medical_history_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 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-21T13:52:52.381Z INFO 109 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T13:52:52.552Z INFO 109 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : Started VeterinarianServiceTest in 0.504 seconds (process running for 13.867)
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 (?,?,?,?)
Hibernate: insert into medical_event_entity (diagnosis,event_date,event_type,medical_history_id,treatment,veterinarian_id,id) values (?,?,?,?,?,?,default)
2026-03-21T13:52:52.576Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 1
2026-03-21T13:52:52.577Z WARN 109 --- [ main] c.e.u.m.p.services.VeterinarianService : Attempted to delete veterinarian 1 with medical history records
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-21T13:52:52.591Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 4
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-21T13:52:52.606Z INFO 109 --- [ main] c.e.u.m.p.services.VeterinarianService : Starting creation process for veterinarian: nuevo_vet@test.com
2026-03-21T13:52:52.606Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: nuevo_vet@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 veterinarian_entity (availability,shelter_id,specialty,id) values (?,?,?,?)
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 (?,?,?,?)
Hibernate: insert into adoption_follow_up_entity (adoption_id,frequency,notes,pet_id,veterinarian_id,id) values (?,?,?,?,?,default)
2026-03-21T13:52:52.626Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 12
2026-03-21T13:52:52.627Z WARN 109 --- [ main] c.e.u.m.p.services.VeterinarianService : Attempted to delete veterinarian 12 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-21T13:52:52.642Z INFO 109 --- [ main] c.e.u.m.p.services.VeterinarianService : Starting creation process for veterinarian: 4uTlHqbUKQ
[INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.603 s -- in co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.UserServiceTest
2026-03-21T13:52:52.647Z INFO 109 --- [ 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-21T13:52:52.649Z INFO 109 --- [ 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-21T13:52:52.668Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : Starting UserServiceTest using Java 21.0.4 with PID 109 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T13:52:52.668Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T13:52:52.726Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T13:52:52.746Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 19 JPA repository interfaces.
2026-03-21T13:52:52.762Z INFO 109 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T13:52:52.773Z INFO 109 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:15ef3fd4-838e-4549-a039-ab8c93f05a0e;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T13:52:52.788Z INFO 109 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T13:52:52.790Z INFO 109 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T13:52:52.798Z INFO 109 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T13:52:52.800Z WARN 109 --- [ 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-21T13:52:52.800Z INFO 109 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@7fd0e8ca']
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_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
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
2026-03-21T13:52:52.929Z INFO 109 --- [ 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, diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (id bigint generated by default as identity, pet_id bigint unique, 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, 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, id bigint generated by default as identity, medical_history_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 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-21T13:52:52.967Z INFO 109 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T13:52:53.114Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : Started UserServiceTest in 0.462 seconds (process running for 14.429)
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 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-21T13:52:53.151Z INFO 109 --- [ 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 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 (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into mock_user (id) values (?)
2026-03-21T13:52:53.193Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Updating user with id = 10
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 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-21T13:52:53.208Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 13
Hibernate: select count(ae1_0.id) from adoption_entity ae1_0 where ae1_0.adopter_id=?
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-21T13:52:53.305Z INFO 109 --- [ 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 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-21T13:52:53.324Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 23
Hibernate: select count(ae1_0.id) from adoption_entity ae1_0 where ae1_0.adopter_id=?
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-21T13:52:53.340Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: correo-sin-arroba.com
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-21T13:52:53.352Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: utLQVcB81C
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-21T13:52:53.363Z INFO 109 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: user0@test.com
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.720 s -- in co.edu.udistrital.mdp.pets.services.UserServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
2026-03-21T13:52:53.369Z INFO 109 --- [ 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-21T13:52:53.374Z INFO 109 --- [ 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-21T13:52:53.393Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : Starting TrialCohabitationServiceTest using Java 21.0.4 with PID 109 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T13:52:53.393Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T13:52:53.448Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T13:52:53.468Z INFO 109 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 18 ms. Found 19 JPA repository interfaces.
2026-03-21T13:52:53.484Z INFO 109 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T13:52:53.494Z INFO 109 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:e5a39d41-b3d5-4fb0-a2a4-33e92ae91461;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T13:52:53.510Z INFO 109 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T13:52:53.512Z INFO 109 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T13:52:53.519Z INFO 109 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T13:52:53.520Z WARN 109 --- [ 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-21T13:52:53.520Z INFO 109 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@61642f8d']
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_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
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
2026-03-21T13:52:53.639Z INFO 109 --- [ 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, diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_history_entity (id bigint generated by default as identity, pet_id bigint unique, 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, 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, id bigint generated by default as identity, medical_history_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 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-21T13:52:53.672Z INFO 109 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T13:52:53.814Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : Started TrialCohabitationServiceTest in 0.437 seconds (process running for 15.129)
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-21T13:52:53.827Z INFO 109 --- [ 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-21T13:52:53.837Z INFO 109 --- [ 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,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-21T13:52:53.840Z ERROR 109 --- [ 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-21T13:52:53.850Z INFO 109 --- [ 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-21T13:52:53.860Z INFO 109 --- [ 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,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-21T13:52:53.871Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 13
2026-03-21T13:52:53.873Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 13 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-21T13:52:53.897Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 19
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-21T13:52:53.907Z INFO 109 --- [ 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-21T13:52:53.920Z INFO 109 --- [ 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-21T13:52:53.931Z INFO 109 --- [ 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-21T13:52:53.941Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 29
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-21T13:52:53.953Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-03-21T13:52:53.953Z INFO 109 --- [ 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-21T13:52:53.965Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 39
2026-03-21T13:52:53.965Z WARN 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Attempted to delete trial cohabitation 39 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-21T13:52:53.974Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting process to consult trial cohabitation with id = 40
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-21T13:52:53.984Z INFO 109 --- [ 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,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-21T13:52:53.995Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-03-21T13:52:53.995Z INFO 109 --- [ 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-21T13:52:54.006Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 50
2026-03-21T13:52:54.006Z INFO 109 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 50 updated successfully
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.641 s -- in co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
[INFO]
[INFO] Results:
[INFO]
[INFO] Tests run: 74, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO]
[INFO] --- jar:3.4.2:jar (default-jar) @ MP_202610_G81_E1_Back ---
[INFO] Building jar: /home/cecaduser/workspace/MP_202610_G81_E1_Back/target/MP_202610_G81_E1_Back-0.0.1-SNAPSHOT.jar
[INFO]
[INFO] --- spring-boot:3.5.10:repackage (repackage) @ MP_202610_G81_E1_Back ---
[INFO] Replacing main artifact /home/cecaduser/workspace/MP_202610_G81_E1_Back/target/MP_202610_G81_E1_Back-0.0.1-SNAPSHOT.jar with repackaged archive, adding nested dependencies in BOOT-INF/.
[INFO] The original artifact has been renamed to /home/cecaduser/workspace/MP_202610_G81_E1_Back/target/MP_202610_G81_E1_Back-0.0.1-SNAPSHOT.jar.original
[INFO]
[INFO] --- jacoco:0.8.11:report (jacoco-site) @ MP_202610_G81_E1_Back ---
[INFO] Loading execution data file /home/cecaduser/workspace/MP_202610_G81_E1_Back/target/jacoco.exec
[INFO] Analyzed bundle 'MP_202610_G81_E1_Back' with 21 classes
[INFO]
[INFO] --- spring-boot:3.5.10:start (pre-integration-test) @ MP_202610_G81_E1_Back ---
[INFO] Attaching agents: []
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-03-21T13:52:56.729Z INFO 192 --- [ main] c.e.udistrital.mdp.pets.MainApplication : Starting MainApplication using Java 21.0.4 with PID 192 (/home/cecaduser/workspace/MP_202610_G81_E1_Back/target/classes started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T13:52:56.734Z INFO 192 --- [ main] c.e.udistrital.mdp.pets.MainApplication : The following 1 profile is active: "integration-tests"
2026-03-21T13:52:57.531Z INFO 192 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T13:52:57.635Z INFO 192 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 94 ms. Found 19 JPA repository interfaces.
2026-03-21T13:52:58.171Z INFO 192 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8999 (http)
2026-03-21T13:52:58.186Z INFO 192 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2026-03-21T13:52:58.187Z INFO 192 --- [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.50]
2026-03-21T13:52:58.235Z INFO 192 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/api] : Initializing Spring embedded WebApplicationContext
2026-03-21T13:52:58.235Z INFO 192 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1426 ms
2026-03-21T13:52:58.410Z INFO 192 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T13:52:58.464Z INFO 192 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.6.41.Final
2026-03-21T13:52:58.494Z INFO 192 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T13:52:58.777Z INFO 192 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T13:52:58.807Z INFO 192 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2026-03-21T13:52:58.988Z INFO 192 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection conn0: url=jdbc:h2:mem:pets user=SA
2026-03-21T13:52:58.992Z INFO 192 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2026-03-21T13:52:59.027Z WARN 192 --- [ 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-21T13:52:59.049Z INFO 192 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'HikariDataSource (HikariPool-1)']
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
2026-03-21T13:53:00.351Z INFO 192 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2026-03-21T13:53:00.452Z INFO 192 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T13:53:01.419Z INFO 192 --- [ main] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:pets'
2026-03-21T13:53:01.490Z INFO 192 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8999 (http) with context path '/api'
2026-03-21T13:53:01.499Z INFO 192 --- [ main] c.e.udistrital.mdp.pets.MainApplication : Started MainApplication in 5.263 seconds (process running for 6.101)
[INFO]
[INFO] --- exec:1.6.0:exec (combine-collection) @ MP_202610_G81_E1_Back ---
Collection 'Default Tests' was successfully added.
Combined collection is saved to 'it/composed.collection.json'
[INFO]
[INFO] --- spring-boot:3.5.10:stop (post-integration-test) @ MP_202610_G81_E1_Back ---
[INFO] Stopping application...
2026-03-21T13:53:02.170Z INFO 192 --- [on(2)-127.0.0.1] inMXBeanRegistrar$SpringApplicationAdmin : Application shutdown requested.
2026-03-21T13:53:02.173Z INFO 192 --- [on(2)-127.0.0.1] o.s.b.w.e.tomcat.GracefulShutdown : Commencing graceful shutdown. Waiting for active requests to complete
2026-03-21T13:53:02.177Z INFO 192 --- [tomcat-shutdown] o.s.b.w.e.tomcat.GracefulShutdown : Graceful shutdown complete
2026-03-21T13:53:02.183Z INFO 192 --- [on(2)-127.0.0.1] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T13:53:02.200Z INFO 192 --- [on(2)-127.0.0.1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2026-03-21T13:53:02.209Z INFO 192 --- [on(2)-127.0.0.1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
[INFO]
[INFO] --- install:3.1.4:install (default-install) @ MP_202610_G81_E1_Back ---
[INFO] Installing /home/cecaduser/workspace/MP_202610_G81_E1_Back/pom.xml to /root/.m2/repository/co/edu/udistrital/mdp/MP_202610_G81_E1_Back/0.0.1-SNAPSHOT/MP_202610_G81_E1_Back-0.0.1-SNAPSHOT.pom
[INFO] Installing /home/cecaduser/workspace/MP_202610_G81_E1_Back/target/MP_202610_G81_E1_Back-0.0.1-SNAPSHOT.jar to /root/.m2/repository/co/edu/udistrital/mdp/MP_202610_G81_E1_Back/0.0.1-SNAPSHOT/MP_202610_G81_E1_Back-0.0.1-SNAPSHOT.jar
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 36.288 s
[INFO] Finished at: 2026-03-21T13:53:02Z
[INFO] ------------------------------------------------------------------------
![[Jenkins]](/jenkins/static/1229cee1/images/svgs/logo.svg){kind=logo}
