Console Output
Skipping 48 KB..
Full Loggint, 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-21T14:24:51.717Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T14:24:51.957Z INFO 92 --- [ main] c.e.u.m.p.services.AdoptionServiceTest : Started AdoptionServiceTest in 0.787 seconds (process running for 11.156)
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-21T14:24:51.975Z INFO 92 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting update process for adoption with id = 1
2026-03-21T14:24:51.976Z INFO 92 --- [ 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-21T14:24:51.990Z INFO 92 --- [ 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-21T14:24:52.007Z INFO 92 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting creation process for adoption
2026-03-21T14:24:52.007Z INFO 92 --- [ 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-21T14:24:52.026Z INFO 92 --- [ 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-21T14:24:52.049Z INFO 92 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting deletion process for adoption ID: 14
2026-03-21T14:24:52.050Z WARN 92 --- [ 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-21T14:24:52.063Z INFO 92 --- [ 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-21T14:24:52.076Z INFO 92 --- [ 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-21T14:24:52.078Z ERROR 92 --- [ 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-21T14:24:52.091Z INFO 92 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Starting deletion process for adoption ID: 23
2026-03-21T14:24:52.092Z INFO 92 --- [ 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-21T14:24:52.104Z INFO 92 --- [ 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-21T14:24:52.115Z INFO 92 --- [ 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-21T14:24:52.129Z INFO 92 --- [ 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: 0.982 s -- in co.edu.udistrital.mdp.pets.services.AdoptionServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ShelterServiceTest
2026-03-21T14:24:52.141Z INFO 92 --- [ 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-21T14:24:52.148Z INFO 92 --- [ 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-21T14:24:52.172Z INFO 92 --- [ main] c.e.u.m.p.services.ShelterServiceTest : Starting ShelterServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T14:24:52.172Z INFO 92 --- [ main] c.e.u.m.p.services.ShelterServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T14:24:52.249Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T14:24:52.275Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 24 ms. Found 19 JPA repository interfaces.
2026-03-21T14:24:52.296Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T14:24:52.310Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:6b2bd68a-2644-442e-996e-6cfcb4181110;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T14:24:52.330Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T14:24:52.332Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T14:24:52.340Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T14:24:52.342Z WARN 92 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-21T14:24:52.342Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@74e04a55']
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-21T14:24:52.505Z INFO 92 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_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-21T14:24:52.557Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T14:24:52.759Z INFO 92 --- [ main] c.e.u.m.p.services.ShelterServiceTest : Started ShelterServiceTest in 0.608 seconds (process running for 11.958)
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-21T14:24:52.777Z INFO 92 --- [ 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-21T14:24:52.791Z INFO 92 --- [ 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-21T14:24:52.799Z INFO 92 --- [ 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-21T14:24:52.813Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting creation process for shelter: AZOzD2JNwl
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-21T14:24:52.837Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting deletion process for shelter ID: 13
2026-03-21T14:24:52.839Z WARN 92 --- [ 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-21T14:24:52.851Z INFO 92 --- [ 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-21T14:24:52.853Z ERROR 92 --- [ 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-21T14:24:52.864Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting deletion process for shelter ID: 17
2026-03-21T14:24:52.865Z INFO 92 --- [ 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-21T14:24:52.882Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Starting deletion process for shelter ID: 20
2026-03-21T14:24:52.883Z WARN 92 --- [ 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-21T14:24:52.895Z INFO 92 --- [ 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-21T14:24:52.911Z INFO 92 --- [ 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-21T14:24:52.926Z INFO 92 --- [ 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-21T14:24:52.930Z INFO 92 --- [ 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.801 s -- in co.edu.udistrital.mdp.pets.services.ShelterServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.PetServiceTest
2026-03-21T14:24:52.937Z INFO 92 --- [ 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-21T14:24:52.951Z INFO 92 --- [ 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-21T14:24:52.975Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : Starting PetServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T14:24:52.975Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T14:24:53.044Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T14:24:53.066Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 21 ms. Found 19 JPA repository interfaces.
2026-03-21T14:24:53.085Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T14:24:53.098Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:56f283a7-b8a3-47c8-a768-9f62991e1403;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T14:24:53.117Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T14:24:53.119Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T14:24:53.126Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T14:24:53.128Z WARN 92 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-21T14:24:53.128Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@31e49aec']
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-21T14:24:53.270Z INFO 92 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_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-21T14:24:53.319Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T14:24:53.502Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : Started PetServiceTest in 0.547 seconds (process running for 12.701)
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-21T14:24:53.522Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Creating pet: buydwgnX8g
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-21T14:24:53.542Z INFO 92 --- [ 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-21T14:24:53.558Z INFO 92 --- [ 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-21T14:24:53.574Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Creating pet: 7Af1hSYOuQ
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-21T14:24:53.601Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Processing return for pet with id = 14
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-21T14:24:53.620Z INFO 92 --- [ 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-21T14:24:53.636Z INFO 92 --- [ 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.704 s -- in co.edu.udistrital.mdp.pets.services.PetServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
2026-03-21T14:24:53.642Z INFO 92 --- [ 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-21T14:24:53.645Z INFO 92 --- [ 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-21T14:24:53.670Z INFO 92 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : Starting VeterinarianServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T14:24:53.670Z INFO 92 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T14:24:53.735Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T14:24:53.757Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 20 ms. Found 19 JPA repository interfaces.
2026-03-21T14:24:53.774Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T14:24:53.786Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:90bb272c-8c90-48fd-800e-3019c0e1578f;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T14:24:53.803Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T14:24:53.805Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T14:24:53.814Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T14:24:53.815Z WARN 92 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-21T14:24:53.816Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@6100c41']
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-21T14:24:53.950Z INFO 92 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_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-21T14:24:53.991Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T14:24:54.160Z INFO 92 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : Started VeterinarianServiceTest in 0.512 seconds (process running for 13.359)
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-21T14:24:54.182Z INFO 92 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 1
2026-03-21T14:24:54.183Z WARN 92 --- [ 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-21T14:24:54.197Z INFO 92 --- [ 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-21T14:24:54.213Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Starting creation process for veterinarian: nuevo_vet@test.com
2026-03-21T14:24:54.213Z INFO 92 --- [ 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-21T14:24:54.234Z INFO 92 --- [ main] c.e.u.mdp.pets.services.UserService : Deleting user with id = 12
2026-03-21T14:24:54.234Z WARN 92 --- [ 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-21T14:24:54.253Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Starting creation process for veterinarian: MfLb3ZDk6l
[INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.615 s -- in co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.UserServiceTest
2026-03-21T14:24:54.259Z INFO 92 --- [ 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-21T14:24:54.261Z INFO 92 --- [ 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-21T14:24:54.280Z INFO 92 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : Starting UserServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T14:24:54.280Z INFO 92 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T14:24:54.340Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T14:24:54.360Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 18 ms. Found 19 JPA repository interfaces.
2026-03-21T14:24:54.378Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T14:24:54.389Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:01318435-9360-4c47-a1ff-aed360615546;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T14:24:54.405Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T14:24:54.406Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T14:24:54.415Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T14:24:54.416Z WARN 92 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-21T14:24:54.416Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@58303fc8']
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-21T14:24:54.539Z INFO 92 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_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-21T14:24:54.575Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T14:24:54.747Z INFO 92 --- [ main] c.e.u.mdp.pets.services.UserServiceTest : Started UserServiceTest in 0.482 seconds (process running for 13.946)
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-21T14:24:54.783Z INFO 92 --- [ 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-21T14:24:54.812Z INFO 92 --- [ 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-21T14:24:54.826Z INFO 92 --- [ 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-21T14:24:54.941Z INFO 92 --- [ 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-21T14:24:54.961Z INFO 92 --- [ 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-21T14:24:54.975Z INFO 92 --- [ 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-21T14:24:54.987Z INFO 92 --- [ main] c.e.u.mdp.pets.services.UserService : Starting creation process for user: OPrNEOR7yI
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-21T14:24:54.998Z INFO 92 --- [ 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.744 s -- in co.edu.udistrital.mdp.pets.services.UserServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
2026-03-21T14:24:55.004Z INFO 92 --- [ 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-21T14:24:55.012Z INFO 92 --- [ 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-21T14:24:55.031Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : Starting TrialCohabitationServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T14:24:55.031Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-03-21T14:24:55.087Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T14:24:55.107Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 18 ms. Found 19 JPA repository interfaces.
2026-03-21T14:24:55.124Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-03-21T14:24:55.136Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:63fe641d-5385-4d12-9414-247fb898a776;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-03-21T14:24:55.151Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T14:24:55.153Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T14:24:55.160Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T14:24:55.161Z WARN 92 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-03-21T14:24:55.161Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@17a16484']
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-21T14:24:55.278Z INFO 92 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_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-21T14:24:55.313Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T14:24:55.457Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationServiceTest : Started TrialCohabitationServiceTest in 0.443 seconds (process running for 14.656)
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-21T14:24:55.470Z INFO 92 --- [ 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-21T14:24:55.479Z INFO 92 --- [ 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-21T14:24:55.481Z ERROR 92 --- [ 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-21T14:24:55.491Z INFO 92 --- [ 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-21T14:24:55.500Z INFO 92 --- [ 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-21T14:24:55.527Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 13
2026-03-21T14:24:55.528Z INFO 92 --- [ 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-21T14:24:55.538Z INFO 92 --- [ 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-21T14:24:55.548Z INFO 92 --- [ 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-21T14:24:55.560Z INFO 92 --- [ 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-21T14:24:55.569Z INFO 92 --- [ 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-21T14:24:55.578Z INFO 92 --- [ 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-21T14:24:55.588Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-03-21T14:24:55.588Z INFO 92 --- [ 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-21T14:24:55.599Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 39
2026-03-21T14:24:55.599Z WARN 92 --- [ 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-21T14:24:55.608Z INFO 92 --- [ 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-21T14:24:55.618Z INFO 92 --- [ 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-21T14:24:55.629Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-03-21T14:24:55.629Z INFO 92 --- [ 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-21T14:24:55.638Z INFO 92 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 50
2026-03-21T14:24:55.639Z INFO 92 --- [ 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.638 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-21T14:24:58.205Z INFO 173 --- [ main] c.e.udistrital.mdp.pets.MainApplication : Starting MainApplication using Java 21.0.4 with PID 173 (/home/cecaduser/workspace/MP_202610_G81_E1_Back/target/classes started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-03-21T14:24:58.207Z INFO 173 --- [ main] c.e.udistrital.mdp.pets.MainApplication : The following 1 profile is active: "integration-tests"
2026-03-21T14:24:58.966Z INFO 173 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-03-21T14:24:59.076Z INFO 173 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 99 ms. Found 19 JPA repository interfaces.
2026-03-21T14:24:59.630Z INFO 173 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8999 (http)
2026-03-21T14:24:59.643Z INFO 173 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2026-03-21T14:24:59.644Z INFO 173 --- [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.50]
2026-03-21T14:24:59.689Z INFO 173 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/api] : Initializing Spring embedded WebApplicationContext
2026-03-21T14:24:59.690Z INFO 173 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1427 ms
2026-03-21T14:24:59.877Z INFO 173 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-03-21T14:24:59.921Z INFO 173 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.6.41.Final
2026-03-21T14:24:59.951Z INFO 173 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-03-21T14:25:00.232Z INFO 173 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-03-21T14:25:00.260Z INFO 173 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2026-03-21T14:25:00.439Z INFO 173 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection conn0: url=jdbc:h2:mem:pets user=SA
2026-03-21T14:25:00.441Z INFO 173 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2026-03-21T14:25:00.469Z WARN 173 --- [ 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-21T14:25:00.490Z INFO 173 --- [ 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-21T14:25:01.743Z INFO 173 --- [ 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-21T14:25:01.841Z INFO 173 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T14:25:02.765Z INFO 173 --- [ main] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:pets'
2026-03-21T14:25:02.845Z INFO 173 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8999 (http) with context path '/api'
2026-03-21T14:25:02.854Z INFO 173 --- [ main] c.e.udistrital.mdp.pets.MainApplication : Started MainApplication in 5.194 seconds (process running for 5.789)
[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-21T14:25:03.776Z INFO 173 --- [on(2)-127.0.0.1] inMXBeanRegistrar$SpringApplicationAdmin : Application shutdown requested.
2026-03-21T14:25:03.778Z INFO 173 --- [on(2)-127.0.0.1] o.s.b.w.e.tomcat.GracefulShutdown : Commencing graceful shutdown. Waiting for active requests to complete
2026-03-21T14:25:03.783Z INFO 173 --- [tomcat-shutdown] o.s.b.w.e.tomcat.GracefulShutdown : Graceful shutdown complete
2026-03-21T14:25:03.788Z INFO 173 --- [on(2)-127.0.0.1] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
2026-03-21T14:25:03.805Z INFO 173 --- [on(2)-127.0.0.1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2026-03-21T14:25:03.809Z INFO 173 --- [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: 28.792 s
[INFO] Finished at: 2026-03-21T14:25:03Z
[INFO] ------------------------------------------------------------------------
![[Jenkins]](/jenkins/static/1229cee1/images/svgs/logo.svg){kind=logo}
