Console Output
Skipping 503 KB..
Full Logt_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into adopter_preferences (adopter_id,preference) values (?,?)
Hibernate: insert into adopter_preferences (adopter_id,preference) values (?,?)
Hibernate: insert into adopter_preferences (adopter_id,preference) values (?,?)
Hibernate: insert into adopter_preferences (adopter_id,preference) values (?,?)
Hibernate: insert into adopter_preferences (adopter_id,preference) values (?,?)
2026-05-03T01:21:52.928Z INFO 92 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Intentando eliminar adopción con ID: 32
2026-05-03T01:21:52.929Z WARN 92 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Intento fallido de eliminar adopción no finalizada: 32
[INFO] Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.870 s -- in co.edu.udistrital.mdp.pets.services.AdoptionServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ShelterServiceTest
2026-05-03T01:21:52.935Z 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-05-03T01:21:52.944Z 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-05-03T01:21:52.970Z 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_E4_Back)
2026-05-03T01:21:52.970Z INFO 92 --- [ main] c.e.u.m.p.services.ShelterServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-03T01:21:53.044Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-03T01:21:53.066Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 21 ms. Found 18 JPA repository interfaces.
2026-05-03T01:21:53.081Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-03T01:21:53.092Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:592b9f47-823f-4a7b-9118-b6d34878e07c;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-03T01:21:53.108Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-03T01:21:53.110Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-03T01:21:53.119Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-03T01:21:53.120Z 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-05-03T01:21:53.120Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@2cd9522c']
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-05-03T01:21:53.219Z 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_preferences cascade
Hibernate: drop table if exists adopters cascade
Hibernate: drop table if exists adoption_histories cascade
Hibernate: drop table if exists adoption_requests cascade
Hibernate: drop table if exists adoption_trackings cascade
Hibernate: drop table if exists adoptions cascade
Hibernate: drop table if exists devolutions cascade
Hibernate: drop table if exists medical_event_entity_attachments cascade
Hibernate: drop table if exists medical_events cascade
Hibernate: drop table if exists messages cascade
Hibernate: drop table if exists notifications cascade
Hibernate: drop table if exists pet_entity_photos cascade
Hibernate: drop table if exists pets cascade
Hibernate: drop table if exists reports cascade
Hibernate: drop table if exists reviews cascade
Hibernate: drop table if exists shelter_events cascade
Hibernate: drop table if exists shelter_photos cascade
Hibernate: drop table if exists shelter_videos cascade
Hibernate: drop table if exists shelters cascade
Hibernate: drop table if exists trial_stays cascade
Hibernate: drop table if exists users cascade
Hibernate: drop table if exists vaccination_records cascade
Hibernate: drop table if exists vaccines cascade
Hibernate: drop table if exists vet_specialties cascade
Hibernate: drop table if exists veterinarians cascade
Hibernate: create table adopter_preferences (adopter_id bigint not null, preference varchar(255))
Hibernate: create table adopters (has_children boolean, has_other_pets boolean, id bigint generated by default as identity, address varchar(255), first_name varchar(255) not null, housing_type varchar(255), last_name varchar(255) not null, primary key (id))
Hibernate: create table adoption_histories (date date, adoption_id bigint, id bigint generated by default as identity, detail varchar(255), reason varchar(255), primary key (id))
Hibernate: create table adoption_requests (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, motivation varchar(255), status varchar(255), primary key (id))
Hibernate: create table adoption_trackings (next_review date, adoption_id bigint, id bigint generated by default as identity, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoptions (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, status varchar(255), primary key (id))
Hibernate: create table devolutions (return_date date, adoption_id bigint, id bigint generated by default as identity, detailed_description TEXT, pet_state varchar(255), reason varchar(255), primary key (id))
Hibernate: create table medical_event_entity_attachments (medical_event_entity_id bigint not null, attachment varchar(255))
Hibernate: create table medical_events (event_date date, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table messages (is_read boolean, id bigint generated by default as identity, recipient_id bigint, sender_id bigint, timestamp timestamp(6), content TEXT, recipient_type varchar(255), sender_type varchar(255), subject varchar(255), primary key (id))
Hibernate: create table notifications (is_read boolean not null, id bigint generated by default as identity, timestamp timestamp(6) not null, user_id bigint not null, notification_type varchar(50) not null, user_type varchar(50) not null, related_entity varchar(100), message TEXT not null, primary key (id))
Hibernate: create table pet_entity_photos (pet_entity_id bigint not null, photos varchar(255))
Hibernate: create table pets (age integer not null, arrival_date date, id bigint generated by default as identity, shelter_id bigint, arrival_history TEXT, breed varchar(255), name varchar(255), sex varchar(255), size varchar(255), special_needs TEXT, species varchar(255), status varchar(255), temperament varchar(255), primary key (id))
Hibernate: create table reports (end_date date, generation_date date, start_date date, id bigint generated by default as identity, shelter_id bigint, data TEXT, report_type varchar(255), primary key (id))
Hibernate: create table reviews (rating integer, review_date date, adopter_id bigint, adoption_id bigint unique, id bigint generated by default as identity, comments TEXT, primary key (id))
Hibernate: create table shelter_events (max_capacity integer, registered_count integer, event_code bigint unique, event_date timestamp(6), id bigint generated by default as identity, shelter_id bigint, description TEXT, event_type varchar(255), location varchar(255), title varchar(255), primary key (id))
Hibernate: create table shelter_photos (shelter_id bigint not null, photo_url varchar(255))
Hibernate: create table shelter_videos (shelter_id bigint not null, video_url varchar(255))
Hibernate: create table shelters (id bigint generated by default as identity, address varchar(255), city varchar(255), description TEXT, email varchar(255), name varchar(255), phone varchar(255), primary key (id))
Hibernate: create table trial_stays (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, observations TEXT, result varchar(255), primary key (id))
Hibernate: create table users (id bigint generated by default as identity, phone varchar(20), email varchar(100) not null unique, name varchar(100) not null, primary key (id))
Hibernate: create table vaccination_records (id bigint generated by default as identity, pet_id bigint, primary key (id))
Hibernate: create table vaccines (application_date date, next_application_date date, id bigint generated by default as identity, vaccination_record_id bigint, batch_number varchar(255), observations TEXT, vaccine_name varchar(255) not null, primary key (id))
Hibernate: create table vet_specialties (vet_id bigint not null, specialty varchar(255))
Hibernate: create table veterinarians (id bigint generated by default as identity, shelter_id bigint not null, veterinarian_id_business bigint not null unique, availability varchar(255), last_name varchar(255), primary key (id))
Hibernate: alter table if exists adopter_preferences add constraint FKly3f73mw116fi5yh447efv6vi foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_histories add constraint FKs9t3wscq97r0oms2tafe4jt5g foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoption_requests add constraint FKmry1xhx5vfu0efgw7wwelw376 foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_requests add constraint FKnbrvxfu9ncpliue6x29ohsyno foreign key (pet_id) references pets
Hibernate: alter table if exists adoption_requests add constraint FKfe077kidtyrf1ex2gtohvfbi8 foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists adoption_trackings add constraint FKpi269w8qdc8n4fb1h7mtuw5d7 foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoptions add constraint FKpyc8mq4cj893brg8gf9lq0mko foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoptions add constraint FKey4s7xb6gkguogi15tytsi706 foreign key (pet_id) references pets
Hibernate: alter table if exists adoptions add constraint FKgxlnefs7yrio994t0v1gtn26w foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists devolutions add constraint FKlberui1wp06v7rk2egmmpyl2c foreign key (adoption_id) references adoptions
Hibernate: alter table if exists medical_event_entity_attachments add constraint FKjui55xy3h7cgsbao5y0cfp7o0 foreign key (medical_event_entity_id) references medical_events
Hibernate: alter table if exists medical_events add constraint FKsprj1jeophve05dwagdtb348f foreign key (pet_id) references pets
Hibernate: alter table if exists medical_events add constraint FK66kg3v9vhj20vojttueoxjkvj foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists pet_entity_photos add constraint FKg1px23au2f2rwspy1fofkmh92 foreign key (pet_entity_id) references pets
Hibernate: alter table if exists pets add constraint FKcia4g747ywfkmssqfa0dghtxa foreign key (shelter_id) references shelters
Hibernate: alter table if exists reports add constraint FKp6qcftsyloqwo1ka8ye3o0tuu foreign key (shelter_id) references shelters
Hibernate: alter table if exists reviews add constraint FKngqtme1dav7fkxlffvt4rjevw foreign key (adopter_id) references adopters
Hibernate: alter table if exists reviews add constraint FKkwqumvta35wgg9u29th25pnng foreign key (adoption_id) references adoptions
Hibernate: alter table if exists shelter_events add constraint FKgejumj603irg8klosem8lsvq3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_photos add constraint FKdpa3n1lx5mh8ddfgex36bfw7b foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_videos add constraint FK6mxvp0qkt1x5kjhpchi7i1pn3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists trial_stays add constraint FKsd3sd5vdr6mm7w2fojsb4e9qj foreign key (adoption_id) references adoptions
Hibernate: alter table if exists trial_stays add constraint FKipq0ulfm9tvegmelqw7w9txin foreign key (pet_id) references pets
Hibernate: alter table if exists vaccination_records add constraint FKspacg17yvnaras9bs6t61uoq9 foreign key (pet_id) references pets
Hibernate: alter table if exists vaccines add constraint FKgv1172jsfkhxpusikruh8wh8m foreign key (vaccination_record_id) references vaccination_records
Hibernate: alter table if exists vet_specialties add constraint FKq9rebel4ncwgu0ml3p5f2gpa foreign key (vet_id) references veterinarians
Hibernate: alter table if exists veterinarians add constraint FKhu2dbj87wnwmmvxsxnr0yyop0 foreign key (shelter_id) references shelters
2026-05-03T01:21:53.249Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-03T01:21:53.361Z INFO 92 --- [ main] c.e.u.m.p.services.ShelterServiceTest : Started ShelterServiceTest in 0.412 seconds (process running for 19.666)
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.375Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Creating shelter entity
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.387Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Updating shelter with id: 4
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.401Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Searching shelter with id: null
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.412Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Creating shelter entity
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.436Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Searching shelter with id: 0
Hibernate: select se1_0.id,se1_0.address,se1_0.city,se1_0.description,se1_0.email,se1_0.name,se1_0.phone from shelters se1_0 where se1_0.id=?
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.447Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Deleting shelter with id: 16
2026-05-03T01:21:53.448Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Shelter deleted successfully
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.459Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Creating shelter entity
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.469Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Creating shelter entity
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
2026-05-03T01:21:53.480Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Deleting shelter with id: 25
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.490Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Searching shelter with id: 28
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.503Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Creating shelter entity
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.513Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Creating shelter entity
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.523Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Updating shelter with id: 1
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:53.533Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Creating shelter entity
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
[INFO] Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.603 s -- in co.edu.udistrital.mdp.pets.services.ShelterServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.PetServiceTest
2026-05-03T01:21:53.538Z 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-05-03T01:21:53.543Z 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-05-03T01:21:53.560Z 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_E4_Back)
2026-05-03T01:21:53.560Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-03T01:21:53.624Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-03T01:21:53.646Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 21 ms. Found 18 JPA repository interfaces.
2026-05-03T01:21:53.660Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-03T01:21:53.671Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:da625aa6-efe3-44e5-ad81-e6867e7d4c1b;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-03T01:21:53.686Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-03T01:21:53.688Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-03T01:21:53.695Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-03T01:21:53.696Z 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-05-03T01:21:53.696Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@5d397eee']
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-05-03T01:21:53.789Z 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_preferences cascade
Hibernate: drop table if exists adopters cascade
Hibernate: drop table if exists adoption_histories cascade
Hibernate: drop table if exists adoption_requests cascade
Hibernate: drop table if exists adoption_trackings cascade
Hibernate: drop table if exists adoptions cascade
Hibernate: drop table if exists devolutions cascade
Hibernate: drop table if exists medical_event_entity_attachments cascade
Hibernate: drop table if exists medical_events cascade
Hibernate: drop table if exists messages cascade
Hibernate: drop table if exists notifications cascade
Hibernate: drop table if exists pet_entity_photos cascade
Hibernate: drop table if exists pets cascade
Hibernate: drop table if exists reports cascade
Hibernate: drop table if exists reviews cascade
Hibernate: drop table if exists shelter_events cascade
Hibernate: drop table if exists shelter_photos cascade
Hibernate: drop table if exists shelter_videos cascade
Hibernate: drop table if exists shelters cascade
Hibernate: drop table if exists trial_stays cascade
Hibernate: drop table if exists users cascade
Hibernate: drop table if exists vaccination_records cascade
Hibernate: drop table if exists vaccines cascade
Hibernate: drop table if exists vet_specialties cascade
Hibernate: drop table if exists veterinarians cascade
Hibernate: create table adopter_preferences (adopter_id bigint not null, preference varchar(255))
Hibernate: create table adopters (has_children boolean, has_other_pets boolean, id bigint generated by default as identity, address varchar(255), first_name varchar(255) not null, housing_type varchar(255), last_name varchar(255) not null, primary key (id))
Hibernate: create table adoption_histories (date date, adoption_id bigint, id bigint generated by default as identity, detail varchar(255), reason varchar(255), primary key (id))
Hibernate: create table adoption_requests (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, motivation varchar(255), status varchar(255), primary key (id))
Hibernate: create table adoption_trackings (next_review date, adoption_id bigint, id bigint generated by default as identity, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoptions (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, status varchar(255), primary key (id))
Hibernate: create table devolutions (return_date date, adoption_id bigint, id bigint generated by default as identity, detailed_description TEXT, pet_state varchar(255), reason varchar(255), primary key (id))
Hibernate: create table medical_event_entity_attachments (medical_event_entity_id bigint not null, attachment varchar(255))
Hibernate: create table medical_events (event_date date, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table messages (is_read boolean, id bigint generated by default as identity, recipient_id bigint, sender_id bigint, timestamp timestamp(6), content TEXT, recipient_type varchar(255), sender_type varchar(255), subject varchar(255), primary key (id))
Hibernate: create table notifications (is_read boolean not null, id bigint generated by default as identity, timestamp timestamp(6) not null, user_id bigint not null, notification_type varchar(50) not null, user_type varchar(50) not null, related_entity varchar(100), message TEXT not null, primary key (id))
Hibernate: create table pet_entity_photos (pet_entity_id bigint not null, photos varchar(255))
Hibernate: create table pets (age integer not null, arrival_date date, id bigint generated by default as identity, shelter_id bigint, arrival_history TEXT, breed varchar(255), name varchar(255), sex varchar(255), size varchar(255), special_needs TEXT, species varchar(255), status varchar(255), temperament varchar(255), primary key (id))
Hibernate: create table reports (end_date date, generation_date date, start_date date, id bigint generated by default as identity, shelter_id bigint, data TEXT, report_type varchar(255), primary key (id))
Hibernate: create table reviews (rating integer, review_date date, adopter_id bigint, adoption_id bigint unique, id bigint generated by default as identity, comments TEXT, primary key (id))
Hibernate: create table shelter_events (max_capacity integer, registered_count integer, event_code bigint unique, event_date timestamp(6), id bigint generated by default as identity, shelter_id bigint, description TEXT, event_type varchar(255), location varchar(255), title varchar(255), primary key (id))
Hibernate: create table shelter_photos (shelter_id bigint not null, photo_url varchar(255))
Hibernate: create table shelter_videos (shelter_id bigint not null, video_url varchar(255))
Hibernate: create table shelters (id bigint generated by default as identity, address varchar(255), city varchar(255), description TEXT, email varchar(255), name varchar(255), phone varchar(255), primary key (id))
Hibernate: create table trial_stays (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, observations TEXT, result varchar(255), primary key (id))
Hibernate: create table users (id bigint generated by default as identity, phone varchar(20), email varchar(100) not null unique, name varchar(100) not null, primary key (id))
Hibernate: create table vaccination_records (id bigint generated by default as identity, pet_id bigint, primary key (id))
Hibernate: create table vaccines (application_date date, next_application_date date, id bigint generated by default as identity, vaccination_record_id bigint, batch_number varchar(255), observations TEXT, vaccine_name varchar(255) not null, primary key (id))
Hibernate: create table vet_specialties (vet_id bigint not null, specialty varchar(255))
Hibernate: create table veterinarians (id bigint generated by default as identity, shelter_id bigint not null, veterinarian_id_business bigint not null unique, availability varchar(255), last_name varchar(255), primary key (id))
Hibernate: alter table if exists adopter_preferences add constraint FKly3f73mw116fi5yh447efv6vi foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_histories add constraint FKs9t3wscq97r0oms2tafe4jt5g foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoption_requests add constraint FKmry1xhx5vfu0efgw7wwelw376 foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_requests add constraint FKnbrvxfu9ncpliue6x29ohsyno foreign key (pet_id) references pets
Hibernate: alter table if exists adoption_requests add constraint FKfe077kidtyrf1ex2gtohvfbi8 foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists adoption_trackings add constraint FKpi269w8qdc8n4fb1h7mtuw5d7 foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoptions add constraint FKpyc8mq4cj893brg8gf9lq0mko foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoptions add constraint FKey4s7xb6gkguogi15tytsi706 foreign key (pet_id) references pets
Hibernate: alter table if exists adoptions add constraint FKgxlnefs7yrio994t0v1gtn26w foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists devolutions add constraint FKlberui1wp06v7rk2egmmpyl2c foreign key (adoption_id) references adoptions
Hibernate: alter table if exists medical_event_entity_attachments add constraint FKjui55xy3h7cgsbao5y0cfp7o0 foreign key (medical_event_entity_id) references medical_events
Hibernate: alter table if exists medical_events add constraint FKsprj1jeophve05dwagdtb348f foreign key (pet_id) references pets
Hibernate: alter table if exists medical_events add constraint FK66kg3v9vhj20vojttueoxjkvj foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists pet_entity_photos add constraint FKg1px23au2f2rwspy1fofkmh92 foreign key (pet_entity_id) references pets
Hibernate: alter table if exists pets add constraint FKcia4g747ywfkmssqfa0dghtxa foreign key (shelter_id) references shelters
Hibernate: alter table if exists reports add constraint FKp6qcftsyloqwo1ka8ye3o0tuu foreign key (shelter_id) references shelters
Hibernate: alter table if exists reviews add constraint FKngqtme1dav7fkxlffvt4rjevw foreign key (adopter_id) references adopters
Hibernate: alter table if exists reviews add constraint FKkwqumvta35wgg9u29th25pnng foreign key (adoption_id) references adoptions
Hibernate: alter table if exists shelter_events add constraint FKgejumj603irg8klosem8lsvq3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_photos add constraint FKdpa3n1lx5mh8ddfgex36bfw7b foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_videos add constraint FK6mxvp0qkt1x5kjhpchi7i1pn3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists trial_stays add constraint FKsd3sd5vdr6mm7w2fojsb4e9qj foreign key (adoption_id) references adoptions
Hibernate: alter table if exists trial_stays add constraint FKipq0ulfm9tvegmelqw7w9txin foreign key (pet_id) references pets
Hibernate: alter table if exists vaccination_records add constraint FKspacg17yvnaras9bs6t61uoq9 foreign key (pet_id) references pets
Hibernate: alter table if exists vaccines add constraint FKgv1172jsfkhxpusikruh8wh8m foreign key (vaccination_record_id) references vaccination_records
Hibernate: alter table if exists vet_specialties add constraint FKq9rebel4ncwgu0ml3p5f2gpa foreign key (vet_id) references veterinarians
Hibernate: alter table if exists veterinarians add constraint FKhu2dbj87wnwmmvxsxnr0yyop0 foreign key (shelter_id) references shelters
2026-05-03T01:21:53.817Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-03T01:21:53.926Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : Started PetServiceTest in 0.379 seconds (process running for 20.231)
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
2026-05-03T01:21:53.945Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Updating pet with ID: 1
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
2026-05-03T01:21:53.960Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Searching all pets...
Hibernate: select pe1_0.id,pe1_0.age,pe1_0.arrival_date,pe1_0.arrival_history,pe1_0.breed,pe1_0.name,pe1_0.sex,pe1_0.shelter_id,pe1_0.size,pe1_0.special_needs,pe1_0.species,pe1_0.status,pe1_0.temperament from pets pe1_0
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
2026-05-03T01:21:53.976Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Attempting to delete pet with ID: 7
2026-05-03T01:21:53.977Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Pet with ID: 7 deleted successfully
Hibernate: delete from pet_entity_photos where pet_entity_id=?
Hibernate: delete from pets where id=?
Hibernate: select pe1_0.id,pe1_0.age,pe1_0.arrival_date,pe1_0.arrival_history,pe1_0.breed,pe1_0.name,pe1_0.sex,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.email,s1_0.name,s1_0.phone,pe1_0.size,pe1_0.special_needs,pe1_0.species,pe1_0.status,pe1_0.temperament from pets pe1_0 left join shelters s1_0 on s1_0.id=pe1_0.shelter_id where pe1_0.id=?
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
2026-05-03T01:21:53.993Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Searching pet with ID: 999
Hibernate: select pe1_0.id,pe1_0.age,pe1_0.arrival_date,pe1_0.arrival_history,pe1_0.breed,pe1_0.name,pe1_0.sex,s1_0.id,s1_0.address,s1_0.city,s1_0.description,s1_0.email,s1_0.name,s1_0.phone,pe1_0.size,pe1_0.special_needs,pe1_0.species,pe1_0.status,pe1_0.temperament from pets pe1_0 left join shelters s1_0 on s1_0.id=pe1_0.shelter_id where pe1_0.id=?
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
2026-05-03T01:21:54.009Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Iniciando creación de mascota...
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
2026-05-03T01:21:54.023Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Iniciando creación de mascota...
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
2026-05-03T01:21:54.024Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Pet created with ID: 19
Hibernate: delete from pet_entity_photos to_delete_
Hibernate: delete from pets pe1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into pets (age,arrival_date,arrival_history,breed,name,sex,shelter_id,size,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
Hibernate: insert into pet_entity_photos (pet_entity_id,photos) values (?,?)
2026-05-03T01:21:54.058Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Searching pet with ID: 20
[INFO] Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.523 s -- in co.edu.udistrital.mdp.pets.services.PetServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
2026-05-03T01:21:54.063Z 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-05-03T01:21:54.068Z 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-05-03T01:21:54.084Z 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_E4_Back)
2026-05-03T01:21:54.085Z INFO 92 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-03T01:21:54.148Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-03T01:21:54.169Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 18 JPA repository interfaces.
2026-05-03T01:21:54.182Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-03T01:21:54.193Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:37b85506-764a-44b2-84e1-5bd242ec8f3b;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-03T01:21:54.208Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-03T01:21:54.210Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-03T01:21:54.217Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-03T01:21:54.218Z 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-05-03T01:21:54.219Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@6e9514b4']
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-05-03T01:21:54.309Z 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_preferences cascade
Hibernate: drop table if exists adopters cascade
Hibernate: drop table if exists adoption_histories cascade
Hibernate: drop table if exists adoption_requests cascade
Hibernate: drop table if exists adoption_trackings cascade
Hibernate: drop table if exists adoptions cascade
Hibernate: drop table if exists devolutions cascade
Hibernate: drop table if exists medical_event_entity_attachments cascade
Hibernate: drop table if exists medical_events cascade
Hibernate: drop table if exists messages cascade
Hibernate: drop table if exists notifications cascade
Hibernate: drop table if exists pet_entity_photos cascade
Hibernate: drop table if exists pets cascade
Hibernate: drop table if exists reports cascade
Hibernate: drop table if exists reviews cascade
Hibernate: drop table if exists shelter_events cascade
Hibernate: drop table if exists shelter_photos cascade
Hibernate: drop table if exists shelter_videos cascade
Hibernate: drop table if exists shelters cascade
Hibernate: drop table if exists trial_stays cascade
Hibernate: drop table if exists users cascade
Hibernate: drop table if exists vaccination_records cascade
Hibernate: drop table if exists vaccines cascade
Hibernate: drop table if exists vet_specialties cascade
Hibernate: drop table if exists veterinarians cascade
Hibernate: create table adopter_preferences (adopter_id bigint not null, preference varchar(255))
Hibernate: create table adopters (has_children boolean, has_other_pets boolean, id bigint generated by default as identity, address varchar(255), first_name varchar(255) not null, housing_type varchar(255), last_name varchar(255) not null, primary key (id))
Hibernate: create table adoption_histories (date date, adoption_id bigint, id bigint generated by default as identity, detail varchar(255), reason varchar(255), primary key (id))
Hibernate: create table adoption_requests (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, motivation varchar(255), status varchar(255), primary key (id))
Hibernate: create table adoption_trackings (next_review date, adoption_id bigint, id bigint generated by default as identity, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoptions (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, status varchar(255), primary key (id))
Hibernate: create table devolutions (return_date date, adoption_id bigint, id bigint generated by default as identity, detailed_description TEXT, pet_state varchar(255), reason varchar(255), primary key (id))
Hibernate: create table medical_event_entity_attachments (medical_event_entity_id bigint not null, attachment varchar(255))
Hibernate: create table medical_events (event_date date, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table messages (is_read boolean, id bigint generated by default as identity, recipient_id bigint, sender_id bigint, timestamp timestamp(6), content TEXT, recipient_type varchar(255), sender_type varchar(255), subject varchar(255), primary key (id))
Hibernate: create table notifications (is_read boolean not null, id bigint generated by default as identity, timestamp timestamp(6) not null, user_id bigint not null, notification_type varchar(50) not null, user_type varchar(50) not null, related_entity varchar(100), message TEXT not null, primary key (id))
Hibernate: create table pet_entity_photos (pet_entity_id bigint not null, photos varchar(255))
Hibernate: create table pets (age integer not null, arrival_date date, id bigint generated by default as identity, shelter_id bigint, arrival_history TEXT, breed varchar(255), name varchar(255), sex varchar(255), size varchar(255), special_needs TEXT, species varchar(255), status varchar(255), temperament varchar(255), primary key (id))
Hibernate: create table reports (end_date date, generation_date date, start_date date, id bigint generated by default as identity, shelter_id bigint, data TEXT, report_type varchar(255), primary key (id))
Hibernate: create table reviews (rating integer, review_date date, adopter_id bigint, adoption_id bigint unique, id bigint generated by default as identity, comments TEXT, primary key (id))
Hibernate: create table shelter_events (max_capacity integer, registered_count integer, event_code bigint unique, event_date timestamp(6), id bigint generated by default as identity, shelter_id bigint, description TEXT, event_type varchar(255), location varchar(255), title varchar(255), primary key (id))
Hibernate: create table shelter_photos (shelter_id bigint not null, photo_url varchar(255))
Hibernate: create table shelter_videos (shelter_id bigint not null, video_url varchar(255))
Hibernate: create table shelters (id bigint generated by default as identity, address varchar(255), city varchar(255), description TEXT, email varchar(255), name varchar(255), phone varchar(255), primary key (id))
Hibernate: create table trial_stays (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, observations TEXT, result varchar(255), primary key (id))
Hibernate: create table users (id bigint generated by default as identity, phone varchar(20), email varchar(100) not null unique, name varchar(100) not null, primary key (id))
Hibernate: create table vaccination_records (id bigint generated by default as identity, pet_id bigint, primary key (id))
Hibernate: create table vaccines (application_date date, next_application_date date, id bigint generated by default as identity, vaccination_record_id bigint, batch_number varchar(255), observations TEXT, vaccine_name varchar(255) not null, primary key (id))
Hibernate: create table vet_specialties (vet_id bigint not null, specialty varchar(255))
Hibernate: create table veterinarians (id bigint generated by default as identity, shelter_id bigint not null, veterinarian_id_business bigint not null unique, availability varchar(255), last_name varchar(255), primary key (id))
Hibernate: alter table if exists adopter_preferences add constraint FKly3f73mw116fi5yh447efv6vi foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_histories add constraint FKs9t3wscq97r0oms2tafe4jt5g foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoption_requests add constraint FKmry1xhx5vfu0efgw7wwelw376 foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_requests add constraint FKnbrvxfu9ncpliue6x29ohsyno foreign key (pet_id) references pets
Hibernate: alter table if exists adoption_requests add constraint FKfe077kidtyrf1ex2gtohvfbi8 foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists adoption_trackings add constraint FKpi269w8qdc8n4fb1h7mtuw5d7 foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoptions add constraint FKpyc8mq4cj893brg8gf9lq0mko foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoptions add constraint FKey4s7xb6gkguogi15tytsi706 foreign key (pet_id) references pets
Hibernate: alter table if exists adoptions add constraint FKgxlnefs7yrio994t0v1gtn26w foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists devolutions add constraint FKlberui1wp06v7rk2egmmpyl2c foreign key (adoption_id) references adoptions
Hibernate: alter table if exists medical_event_entity_attachments add constraint FKjui55xy3h7cgsbao5y0cfp7o0 foreign key (medical_event_entity_id) references medical_events
Hibernate: alter table if exists medical_events add constraint FKsprj1jeophve05dwagdtb348f foreign key (pet_id) references pets
Hibernate: alter table if exists medical_events add constraint FK66kg3v9vhj20vojttueoxjkvj foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists pet_entity_photos add constraint FKg1px23au2f2rwspy1fofkmh92 foreign key (pet_entity_id) references pets
Hibernate: alter table if exists pets add constraint FKcia4g747ywfkmssqfa0dghtxa foreign key (shelter_id) references shelters
Hibernate: alter table if exists reports add constraint FKp6qcftsyloqwo1ka8ye3o0tuu foreign key (shelter_id) references shelters
Hibernate: alter table if exists reviews add constraint FKngqtme1dav7fkxlffvt4rjevw foreign key (adopter_id) references adopters
Hibernate: alter table if exists reviews add constraint FKkwqumvta35wgg9u29th25pnng foreign key (adoption_id) references adoptions
Hibernate: alter table if exists shelter_events add constraint FKgejumj603irg8klosem8lsvq3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_photos add constraint FKdpa3n1lx5mh8ddfgex36bfw7b foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_videos add constraint FK6mxvp0qkt1x5kjhpchi7i1pn3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists trial_stays add constraint FKsd3sd5vdr6mm7w2fojsb4e9qj foreign key (adoption_id) references adoptions
Hibernate: alter table if exists trial_stays add constraint FKipq0ulfm9tvegmelqw7w9txin foreign key (pet_id) references pets
Hibernate: alter table if exists vaccination_records add constraint FKspacg17yvnaras9bs6t61uoq9 foreign key (pet_id) references pets
Hibernate: alter table if exists vaccines add constraint FKgv1172jsfkhxpusikruh8wh8m foreign key (vaccination_record_id) references vaccination_records
Hibernate: alter table if exists vet_specialties add constraint FKq9rebel4ncwgu0ml3p5f2gpa foreign key (vet_id) references veterinarians
Hibernate: alter table if exists veterinarians add constraint FKhu2dbj87wnwmmvxsxnr0yyop0 foreign key (shelter_id) references shelters
2026-05-03T01:21:54.335Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-03T01:21:54.449Z INFO 92 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : Started VeterinarianServiceTest in 0.378 seconds (process running for 20.755)
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
2026-05-03T01:21:54.463Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Actualizando veterinario con ID: 1
2026-05-03T01:21:54.463Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Buscando veterinario con ID: 1
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
2026-05-03T01:21:54.476Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Creando nuevo veterinario
2026-05-03T01:21:54.476Z ERROR 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Especialidad inválida detectada: Neurology
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
2026-05-03T01:21:54.485Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Buscando veterinario con ID: 7
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into adoptions (adopter_id,adoption_date,pet_id,status,veterinarian_id,id) values (?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into vet_specialties (vet_id,specialty) values (?,?)
Hibernate: insert into vet_specialties (vet_id,specialty) values (?,?)
Hibernate: insert into vet_specialties (vet_id,specialty) values (?,?)
2026-05-03T01:21:54.499Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Eliminando veterinario con ID: 10
2026-05-03T01:21:54.499Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Buscando veterinario con ID: 10
Hibernate: select ae1_0.id,ae1_0.adopter_id,ae1_0.adoption_date,ae1_0.pet_id,ae1_0.status,ae1_0.veterinarian_id from adoptions ae1_0 left join veterinarians v1_0 on v1_0.id=ae1_0.veterinarian_id where v1_0.id=?
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
2026-05-03T01:21:54.514Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Eliminando veterinario con ID: 13
2026-05-03T01:21:54.515Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Buscando veterinario con ID: 13
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into vet_specialties (vet_id,specialty) values (?,?)
Hibernate: insert into vet_specialties (vet_id,specialty) values (?,?)
Hibernate: insert into vet_specialties (vet_id,specialty) values (?,?)
Hibernate: select ae1_0.id,ae1_0.adopter_id,ae1_0.adoption_date,ae1_0.pet_id,ae1_0.status,ae1_0.veterinarian_id from adoptions ae1_0 left join veterinarians v1_0 on v1_0.id=ae1_0.veterinarian_id where v1_0.id=?
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
2026-05-03T01:21:54.530Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Buscando veterinario con ID: 0
Hibernate: select ve1_0.id,ve1_0.availability,ve1_0.last_name,ve1_0.shelter_id,ve1_0.veterinarian_id_business,s2_0.vet_id,s2_0.specialty from veterinarians ve1_0 left join vet_specialties s2_0 on ve1_0.id=s2_0.vet_id where ve1_0.id=?
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
2026-05-03T01:21:54.543Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Actualizando veterinario con ID: 19
2026-05-03T01:21:54.543Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Buscando veterinario con ID: 19
2026-05-03T01:21:54.543Z ERROR 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Especialidad inválida detectada: 5QEXHpZqKa
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
2026-05-03T01:21:54.553Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Creando nuevo veterinario
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: delete from vet_specialties to_delete_
Hibernate: delete from veterinarians ve1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
Hibernate: insert into veterinarians (availability,last_name,shelter_id,veterinarian_id_business,id) values (?,?,?,?,default)
2026-05-03T01:21:54.563Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Creando nuevo veterinario
2026-05-03T01:21:54.564Z ERROR 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Especialidad inválida detectada: 577BbGkoDP
[INFO] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.504 s -- in co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ReportServiceTest
2026-05-03T01:21:54.568Z INFO 92 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.ReportServiceTest]: ReportServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-05-03T01:21:54.573Z INFO 92 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.ReportServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-05-03T01:21:54.589Z INFO 92 --- [ main] c.e.u.m.pets.services.ReportServiceTest : Starting ReportServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E4_Back)
2026-05-03T01:21:54.589Z INFO 92 --- [ main] c.e.u.m.pets.services.ReportServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-03T01:21:54.650Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-03T01:21:54.671Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 18 JPA repository interfaces.
2026-05-03T01:21:54.684Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-03T01:21:54.693Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:9dd53591-b6f2-46df-a827-7aea327a62cb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-03T01:21:54.708Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-03T01:21:54.709Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-03T01:21:54.717Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-03T01:21:54.718Z 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-05-03T01:21:54.719Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@4fae534c']
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-05-03T01:21:54.844Z 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_preferences cascade
Hibernate: drop table if exists adopters cascade
Hibernate: drop table if exists adoption_histories cascade
Hibernate: drop table if exists adoption_requests cascade
Hibernate: drop table if exists adoption_trackings cascade
Hibernate: drop table if exists adoptions cascade
Hibernate: drop table if exists devolutions cascade
Hibernate: drop table if exists medical_event_entity_attachments cascade
Hibernate: drop table if exists medical_events cascade
Hibernate: drop table if exists messages cascade
Hibernate: drop table if exists notifications cascade
Hibernate: drop table if exists pet_entity_photos cascade
Hibernate: drop table if exists pets cascade
Hibernate: drop table if exists reports cascade
Hibernate: drop table if exists reviews cascade
Hibernate: drop table if exists shelter_events cascade
Hibernate: drop table if exists shelter_photos cascade
Hibernate: drop table if exists shelter_videos cascade
Hibernate: drop table if exists shelters cascade
Hibernate: drop table if exists trial_stays cascade
Hibernate: drop table if exists users cascade
Hibernate: drop table if exists vaccination_records cascade
Hibernate: drop table if exists vaccines cascade
Hibernate: drop table if exists vet_specialties cascade
Hibernate: drop table if exists veterinarians cascade
Hibernate: create table adopter_preferences (adopter_id bigint not null, preference varchar(255))
Hibernate: create table adopters (has_children boolean, has_other_pets boolean, id bigint generated by default as identity, address varchar(255), first_name varchar(255) not null, housing_type varchar(255), last_name varchar(255) not null, primary key (id))
Hibernate: create table adoption_histories (date date, adoption_id bigint, id bigint generated by default as identity, detail varchar(255), reason varchar(255), primary key (id))
Hibernate: create table adoption_requests (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, motivation varchar(255), status varchar(255), primary key (id))
Hibernate: create table adoption_trackings (next_review date, adoption_id bigint, id bigint generated by default as identity, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoptions (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, status varchar(255), primary key (id))
Hibernate: create table devolutions (return_date date, adoption_id bigint, id bigint generated by default as identity, detailed_description TEXT, pet_state varchar(255), reason varchar(255), primary key (id))
Hibernate: create table medical_event_entity_attachments (medical_event_entity_id bigint not null, attachment varchar(255))
Hibernate: create table medical_events (event_date date, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table messages (is_read boolean, id bigint generated by default as identity, recipient_id bigint, sender_id bigint, timestamp timestamp(6), content TEXT, recipient_type varchar(255), sender_type varchar(255), subject varchar(255), primary key (id))
Hibernate: create table notifications (is_read boolean not null, id bigint generated by default as identity, timestamp timestamp(6) not null, user_id bigint not null, notification_type varchar(50) not null, user_type varchar(50) not null, related_entity varchar(100), message TEXT not null, primary key (id))
Hibernate: create table pet_entity_photos (pet_entity_id bigint not null, photos varchar(255))
Hibernate: create table pets (age integer not null, arrival_date date, id bigint generated by default as identity, shelter_id bigint, arrival_history TEXT, breed varchar(255), name varchar(255), sex varchar(255), size varchar(255), special_needs TEXT, species varchar(255), status varchar(255), temperament varchar(255), primary key (id))
Hibernate: create table reports (end_date date, generation_date date, start_date date, id bigint generated by default as identity, shelter_id bigint, data TEXT, report_type varchar(255), primary key (id))
Hibernate: create table reviews (rating integer, review_date date, adopter_id bigint, adoption_id bigint unique, id bigint generated by default as identity, comments TEXT, primary key (id))
Hibernate: create table shelter_events (max_capacity integer, registered_count integer, event_code bigint unique, event_date timestamp(6), id bigint generated by default as identity, shelter_id bigint, description TEXT, event_type varchar(255), location varchar(255), title varchar(255), primary key (id))
Hibernate: create table shelter_photos (shelter_id bigint not null, photo_url varchar(255))
Hibernate: create table shelter_videos (shelter_id bigint not null, video_url varchar(255))
Hibernate: create table shelters (id bigint generated by default as identity, address varchar(255), city varchar(255), description TEXT, email varchar(255), name varchar(255), phone varchar(255), primary key (id))
Hibernate: create table trial_stays (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, observations TEXT, result varchar(255), primary key (id))
Hibernate: create table users (id bigint generated by default as identity, phone varchar(20), email varchar(100) not null unique, name varchar(100) not null, primary key (id))
Hibernate: create table vaccination_records (id bigint generated by default as identity, pet_id bigint, primary key (id))
Hibernate: create table vaccines (application_date date, next_application_date date, id bigint generated by default as identity, vaccination_record_id bigint, batch_number varchar(255), observations TEXT, vaccine_name varchar(255) not null, primary key (id))
Hibernate: create table vet_specialties (vet_id bigint not null, specialty varchar(255))
Hibernate: create table veterinarians (id bigint generated by default as identity, shelter_id bigint not null, veterinarian_id_business bigint not null unique, availability varchar(255), last_name varchar(255), primary key (id))
Hibernate: alter table if exists adopter_preferences add constraint FKly3f73mw116fi5yh447efv6vi foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_histories add constraint FKs9t3wscq97r0oms2tafe4jt5g foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoption_requests add constraint FKmry1xhx5vfu0efgw7wwelw376 foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_requests add constraint FKnbrvxfu9ncpliue6x29ohsyno foreign key (pet_id) references pets
Hibernate: alter table if exists adoption_requests add constraint FKfe077kidtyrf1ex2gtohvfbi8 foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists adoption_trackings add constraint FKpi269w8qdc8n4fb1h7mtuw5d7 foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoptions add constraint FKpyc8mq4cj893brg8gf9lq0mko foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoptions add constraint FKey4s7xb6gkguogi15tytsi706 foreign key (pet_id) references pets
Hibernate: alter table if exists adoptions add constraint FKgxlnefs7yrio994t0v1gtn26w foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists devolutions add constraint FKlberui1wp06v7rk2egmmpyl2c foreign key (adoption_id) references adoptions
Hibernate: alter table if exists medical_event_entity_attachments add constraint FKjui55xy3h7cgsbao5y0cfp7o0 foreign key (medical_event_entity_id) references medical_events
Hibernate: alter table if exists medical_events add constraint FKsprj1jeophve05dwagdtb348f foreign key (pet_id) references pets
Hibernate: alter table if exists medical_events add constraint FK66kg3v9vhj20vojttueoxjkvj foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists pet_entity_photos add constraint FKg1px23au2f2rwspy1fofkmh92 foreign key (pet_entity_id) references pets
Hibernate: alter table if exists pets add constraint FKcia4g747ywfkmssqfa0dghtxa foreign key (shelter_id) references shelters
Hibernate: alter table if exists reports add constraint FKp6qcftsyloqwo1ka8ye3o0tuu foreign key (shelter_id) references shelters
Hibernate: alter table if exists reviews add constraint FKngqtme1dav7fkxlffvt4rjevw foreign key (adopter_id) references adopters
Hibernate: alter table if exists reviews add constraint FKkwqumvta35wgg9u29th25pnng foreign key (adoption_id) references adoptions
Hibernate: alter table if exists shelter_events add constraint FKgejumj603irg8klosem8lsvq3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_photos add constraint FKdpa3n1lx5mh8ddfgex36bfw7b foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_videos add constraint FK6mxvp0qkt1x5kjhpchi7i1pn3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists trial_stays add constraint FKsd3sd5vdr6mm7w2fojsb4e9qj foreign key (adoption_id) references adoptions
Hibernate: alter table if exists trial_stays add constraint FKipq0ulfm9tvegmelqw7w9txin foreign key (pet_id) references pets
Hibernate: alter table if exists vaccination_records add constraint FKspacg17yvnaras9bs6t61uoq9 foreign key (pet_id) references pets
Hibernate: alter table if exists vaccines add constraint FKgv1172jsfkhxpusikruh8wh8m foreign key (vaccination_record_id) references vaccination_records
Hibernate: alter table if exists vet_specialties add constraint FKq9rebel4ncwgu0ml3p5f2gpa foreign key (vet_id) references veterinarians
Hibernate: alter table if exists veterinarians add constraint FKhu2dbj87wnwmmvxsxnr0yyop0 foreign key (shelter_id) references shelters
2026-05-03T01:21:54.876Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-03T01:21:54.994Z INFO 92 --- [ main] c.e.u.m.pets.services.ReportServiceTest : Started ReportServiceTest in 0.418 seconds (process running for 21.299)
Hibernate: delete from reports re1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.020Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Creating report
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: delete from reports re1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
2026-05-03T01:21:55.059Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Updating report with id: 5
2026-05-03T01:21:55.059Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Searching report with id: 5
Hibernate: delete from reports re1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
2026-05-03T01:21:55.082Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Deleting report with id: 8
2026-05-03T01:21:55.082Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Searching report with id: 8
Hibernate: delete from reports re1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
2026-05-03T01:21:55.100Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Creating report
Hibernate: delete from reports re1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
2026-05-03T01:21:55.116Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Searching report with id: 14
Hibernate: delete from reports re1_0
Hibernate: delete from shelter_photos to_delete_
Hibernate: delete from shelter_videos to_delete_
Hibernate: delete from shelters se1_0
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelters (address,city,description,email,name,phone,id) values (?,?,?,?,?,?,default)
Hibernate: insert into reports (data,end_date,generation_date,report_type,shelter_id,start_date,id) values (?,?,?,?,?,?,default)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_photos (shelter_id,photo_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
Hibernate: insert into shelter_videos (shelter_id,video_url) values (?,?)
2026-05-03T01:21:55.133Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Searching report with id: 999
Hibernate: select re1_0.id,re1_0.data,re1_0.end_date,re1_0.generation_date,re1_0.report_type,re1_0.shelter_id,re1_0.start_date from reports re1_0 where re1_0.id=?
[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.570 s -- in co.edu.udistrital.mdp.pets.services.ReportServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VaccineServiceTest
2026-05-03T01:21:55.141Z INFO 92 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.VaccineServiceTest]: VaccineServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-05-03T01:21:55.146Z INFO 92 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.VaccineServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-05-03T01:21:55.165Z INFO 92 --- [ main] c.e.u.m.p.services.VaccineServiceTest : Starting VaccineServiceTest using Java 21.0.4 with PID 92 (started by root in /home/cecaduser/workspace/MP_202610_G81_E4_Back)
2026-05-03T01:21:55.165Z INFO 92 --- [ main] c.e.u.m.p.services.VaccineServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-03T01:21:55.229Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-03T01:21:55.250Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 20 ms. Found 18 JPA repository interfaces.
2026-05-03T01:21:55.263Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-03T01:21:55.274Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:f6760885-33f2-4e76-9058-1183da229b82;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-03T01:21:55.290Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-03T01:21:55.291Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-03T01:21:55.300Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-03T01:21:55.301Z 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-05-03T01:21:55.301Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@439fc3fd']
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-05-03T01:21:55.396Z 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_preferences cascade
Hibernate: drop table if exists adopters cascade
Hibernate: drop table if exists adoption_histories cascade
Hibernate: drop table if exists adoption_requests cascade
Hibernate: drop table if exists adoption_trackings cascade
Hibernate: drop table if exists adoptions cascade
Hibernate: drop table if exists devolutions cascade
Hibernate: drop table if exists medical_event_entity_attachments cascade
Hibernate: drop table if exists medical_events cascade
Hibernate: drop table if exists messages cascade
Hibernate: drop table if exists notifications cascade
Hibernate: drop table if exists pet_entity_photos cascade
Hibernate: drop table if exists pets cascade
Hibernate: drop table if exists reports cascade
Hibernate: drop table if exists reviews cascade
Hibernate: drop table if exists shelter_events cascade
Hibernate: drop table if exists shelter_photos cascade
Hibernate: drop table if exists shelter_videos cascade
Hibernate: drop table if exists shelters cascade
Hibernate: drop table if exists trial_stays cascade
Hibernate: drop table if exists users cascade
Hibernate: drop table if exists vaccination_records cascade
Hibernate: drop table if exists vaccines cascade
Hibernate: drop table if exists vet_specialties cascade
Hibernate: drop table if exists veterinarians cascade
Hibernate: create table adopter_preferences (adopter_id bigint not null, preference varchar(255))
Hibernate: create table adopters (has_children boolean, has_other_pets boolean, id bigint generated by default as identity, address varchar(255), first_name varchar(255) not null, housing_type varchar(255), last_name varchar(255) not null, primary key (id))
Hibernate: create table adoption_histories (date date, adoption_id bigint, id bigint generated by default as identity, detail varchar(255), reason varchar(255), primary key (id))
Hibernate: create table adoption_requests (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, motivation varchar(255), status varchar(255), primary key (id))
Hibernate: create table adoption_trackings (next_review date, adoption_id bigint, id bigint generated by default as identity, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoptions (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, status varchar(255), primary key (id))
Hibernate: create table devolutions (return_date date, adoption_id bigint, id bigint generated by default as identity, detailed_description TEXT, pet_state varchar(255), reason varchar(255), primary key (id))
Hibernate: create table medical_event_entity_attachments (medical_event_entity_id bigint not null, attachment varchar(255))
Hibernate: create table medical_events (event_date date, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table messages (is_read boolean, id bigint generated by default as identity, recipient_id bigint, sender_id bigint, timestamp timestamp(6), content TEXT, recipient_type varchar(255), sender_type varchar(255), subject varchar(255), primary key (id))
Hibernate: create table notifications (is_read boolean not null, id bigint generated by default as identity, timestamp timestamp(6) not null, user_id bigint not null, notification_type varchar(50) not null, user_type varchar(50) not null, related_entity varchar(100), message TEXT not null, primary key (id))
Hibernate: create table pet_entity_photos (pet_entity_id bigint not null, photos varchar(255))
Hibernate: create table pets (age integer not null, arrival_date date, id bigint generated by default as identity, shelter_id bigint, arrival_history TEXT, breed varchar(255), name varchar(255), sex varchar(255), size varchar(255), special_needs TEXT, species varchar(255), status varchar(255), temperament varchar(255), primary key (id))
Hibernate: create table reports (end_date date, generation_date date, start_date date, id bigint generated by default as identity, shelter_id bigint, data TEXT, report_type varchar(255), primary key (id))
Hibernate: create table reviews (rating integer, review_date date, adopter_id bigint, adoption_id bigint unique, id bigint generated by default as identity, comments TEXT, primary key (id))
Hibernate: create table shelter_events (max_capacity integer, registered_count integer, event_code bigint unique, event_date timestamp(6), id bigint generated by default as identity, shelter_id bigint, description TEXT, event_type varchar(255), location varchar(255), title varchar(255), primary key (id))
Hibernate: create table shelter_photos (shelter_id bigint not null, photo_url varchar(255))
Hibernate: create table shelter_videos (shelter_id bigint not null, video_url varchar(255))
Hibernate: create table shelters (id bigint generated by default as identity, address varchar(255), city varchar(255), description TEXT, email varchar(255), name varchar(255), phone varchar(255), primary key (id))
Hibernate: create table trial_stays (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, observations TEXT, result varchar(255), primary key (id))
Hibernate: create table users (id bigint generated by default as identity, phone varchar(20), email varchar(100) not null unique, name varchar(100) not null, primary key (id))
Hibernate: create table vaccination_records (id bigint generated by default as identity, pet_id bigint, primary key (id))
Hibernate: create table vaccines (application_date date, next_application_date date, id bigint generated by default as identity, vaccination_record_id bigint, batch_number varchar(255), observations TEXT, vaccine_name varchar(255) not null, primary key (id))
Hibernate: create table vet_specialties (vet_id bigint not null, specialty varchar(255))
Hibernate: create table veterinarians (id bigint generated by default as identity, shelter_id bigint not null, veterinarian_id_business bigint not null unique, availability varchar(255), last_name varchar(255), primary key (id))
Hibernate: alter table if exists adopter_preferences add constraint FKly3f73mw116fi5yh447efv6vi foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_histories add constraint FKs9t3wscq97r0oms2tafe4jt5g foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoption_requests add constraint FKmry1xhx5vfu0efgw7wwelw376 foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoption_requests add constraint FKnbrvxfu9ncpliue6x29ohsyno foreign key (pet_id) references pets
Hibernate: alter table if exists adoption_requests add constraint FKfe077kidtyrf1ex2gtohvfbi8 foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists adoption_trackings add constraint FKpi269w8qdc8n4fb1h7mtuw5d7 foreign key (adoption_id) references adoptions
Hibernate: alter table if exists adoptions add constraint FKpyc8mq4cj893brg8gf9lq0mko foreign key (adopter_id) references adopters
Hibernate: alter table if exists adoptions add constraint FKey4s7xb6gkguogi15tytsi706 foreign key (pet_id) references pets
Hibernate: alter table if exists adoptions add constraint FKgxlnefs7yrio994t0v1gtn26w foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists devolutions add constraint FKlberui1wp06v7rk2egmmpyl2c foreign key (adoption_id) references adoptions
Hibernate: alter table if exists medical_event_entity_attachments add constraint FKjui55xy3h7cgsbao5y0cfp7o0 foreign key (medical_event_entity_id) references medical_events
Hibernate: alter table if exists medical_events add constraint FKsprj1jeophve05dwagdtb348f foreign key (pet_id) references pets
Hibernate: alter table if exists medical_events add constraint FK66kg3v9vhj20vojttueoxjkvj foreign key (veterinarian_id) references veterinarians
Hibernate: alter table if exists pet_entity_photos add constraint FKg1px23au2f2rwspy1fofkmh92 foreign key (pet_entity_id) references pets
Hibernate: alter table if exists pets add constraint FKcia4g747ywfkmssqfa0dghtxa foreign key (shelter_id) references shelters
Hibernate: alter table if exists reports add constraint FKp6qcftsyloqwo1ka8ye3o0tuu foreign key (shelter_id) references shelters
Hibernate: alter table if exists reviews add constraint FKngqtme1dav7fkxlffvt4rjevw foreign key (adopter_id) references adopters
Hibernate: alter table if exists reviews add constraint FKkwqumvta35wgg9u29th25pnng foreign key (adoption_id) references adoptions
Hibernate: alter table if exists shelter_events add constraint FKgejumj603irg8klosem8lsvq3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_photos add constraint FKdpa3n1lx5mh8ddfgex36bfw7b foreign key (shelter_id) references shelters
Hibernate: alter table if exists shelter_videos add constraint FK6mxvp0qkt1x5kjhpchi7i1pn3 foreign key (shelter_id) references shelters
Hibernate: alter table if exists trial_stays add constraint FKsd3sd5vdr6mm7w2fojsb4e9qj foreign key (adoption_id) references adoptions
Hibernate: alter table if exists trial_stays add constraint FKipq0ulfm9tvegmelqw7w9txin foreign key (pet_id) references pets
Hibernate: alter table if exists vaccination_records add constraint FKspacg17yvnaras9bs6t61uoq9 foreign key (pet_id) references pets
Hibernate: alter table if exists vaccines add constraint FKgv1172jsfkhxpusikruh8wh8m foreign key (vaccination_record_id) references vaccination_records
Hibernate: alter table if exists vet_specialties add constraint FKq9rebel4ncwgu0ml3p5f2gpa foreign key (vet_id) references veterinarians
Hibernate: alter table if exists veterinarians add constraint FKhu2dbj87wnwmmvxsxnr0yyop0 foreign key (shelter_id) references shelters
2026-05-03T01:21:55.443Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-03T01:21:55.555Z INFO 92 --- [ main] c.e.u.m.p.services.VaccineServiceTest : Started VaccineServiceTest in 0.405 seconds (process running for 21.86)
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.567Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Iniciando creación de vacuna: rabia
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.576Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Buscando vacuna con ID: 999
Hibernate: select ve1_0.id,ve1_0.application_date,ve1_0.batch_number,ve1_0.next_application_date,ve1_0.observations,ve1_0.vaccination_record_id,ve1_0.vaccine_name from vaccines ve1_0 where ve1_0.id=?
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.586Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Consultando todas las vacunas
Hibernate: select ve1_0.id,ve1_0.application_date,ve1_0.batch_number,ve1_0.next_application_date,ve1_0.observations,ve1_0.vaccination_record_id,ve1_0.vaccine_name from vaccines ve1_0
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
2026-05-03T01:21:55.596Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Iniciando creación de vacuna: Parvo
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.606Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Iniciando creación de vacuna: Parvo
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.615Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Actualizando vacuna con ID: 999
Hibernate: select ve1_0.id,ve1_0.application_date,ve1_0.batch_number,ve1_0.next_application_date,ve1_0.observations,ve1_0.vaccination_record_id,ve1_0.vaccine_name from vaccines ve1_0 where ve1_0.id=?
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.624Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Iniciando creación de vacuna: null
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.632Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Buscando vacuna con ID: 24
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.641Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Actualizando vacuna con ID: 27
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.649Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Eliminando vacuna con ID: 999
Hibernate: select ve1_0.id,ve1_0.application_date,ve1_0.batch_number,ve1_0.next_application_date,ve1_0.observations,ve1_0.vaccination_record_id,ve1_0.vaccine_name from vaccines ve1_0 where ve1_0.id=?
Hibernate: delete from vaccines ve1_0
Hibernate: delete from vaccination_records vre1_0
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into vaccination_records (pet_id,id) values (?,default)
Hibernate: insert into vaccines (application_date,batch_number,next_application_date,observations,vaccination_record_id,vaccine_name,id) values (?,?,?,?,?,?,default)
2026-05-03T01:21:55.658Z INFO 92 --- [ main] c.e.u.mdp.pets.services.VaccineService : Eliminando vacuna con ID: 33
Hibernate: delete from vaccines where id=?
Hibernate: select ve1_0.id,ve1_0.application_date,ve1_0.batch_number,ve1_0.next_application_date,ve1_0.observations,ve1_0.vaccination_record_id,ve1_0.vaccine_name from vaccines ve1_0 where ve1_0.id=?
[INFO] Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.523 s -- in co.edu.udistrital.mdp.pets.services.VaccineServiceTest
2026-05-03T01:21:55.684Z INFO 92 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
[INFO]
[INFO] Results:
[INFO]
[INFO] Tests run: 148, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO]
[INFO] --- jar:3.4.2:jar (default-jar) @ MP_202610_G81_E4_Back ---
[INFO] Building jar: /home/cecaduser/workspace/MP_202610_G81_E4_Back/target/MP_202610_G81_E4_Back-0.0.1-SNAPSHOT.jar
[INFO]
[INFO] --- spring-boot:3.5.10:repackage (repackage) @ MP_202610_G81_E4_Back ---
[INFO] Replacing main artifact /home/cecaduser/workspace/MP_202610_G81_E4_Back/target/MP_202610_G81_E4_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_E4_Back/target/MP_202610_G81_E4_Back-0.0.1-SNAPSHOT.jar.original
[INFO]
[INFO] --- jacoco:0.8.11:report (jacoco-site) @ MP_202610_G81_E4_Back ---
[INFO] Loading execution data file /home/cecaduser/workspace/MP_202610_G81_E4_Back/target/jacoco.exec
[INFO] Analyzed bundle 'MP_202610_G81_E4_Back' with 83 classes
[INFO]
[INFO] --- spring-boot:3.5.10:start (pre-integration-test) @ MP_202610_G81_E4_Back ---
[INFO] Attaching agents: []
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-05-03T01:21:58.544Z INFO 187 --- [ main] c.e.udistrital.mdp.pets.MainApplication : Starting MainApplication using Java 21.0.4 with PID 187 (/home/cecaduser/workspace/MP_202610_G81_E4_Back/target/classes started by root in /home/cecaduser/workspace/MP_202610_G81_E4_Back)
2026-05-03T01:21:58.546Z INFO 187 --- [ main] c.e.udistrital.mdp.pets.MainApplication : The following 1 profile is active: "integration-tests"
2026-05-03T01:21:59.641Z INFO 187 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-03T01:21:59.765Z INFO 187 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 95 ms. Found 18 JPA repository interfaces.
2026-05-03T01:22:00.296Z INFO 187 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8999 (http)
2026-05-03T01:22:00.310Z INFO 187 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2026-05-03T01:22:00.310Z INFO 187 --- [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.50]
2026-05-03T01:22:00.356Z INFO 187 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/api] : Initializing Spring embedded WebApplicationContext
2026-05-03T01:22:00.356Z INFO 187 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1758 ms
2026-05-03T01:22:00.652Z INFO 187 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-03T01:22:00.700Z INFO 187 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.6.41.Final
2026-05-03T01:22:00.731Z INFO 187 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-03T01:22:01.010Z INFO 187 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-03T01:22:01.045Z INFO 187 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2026-05-03T01:22:01.229Z INFO 187 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection conn0: url=jdbc:h2:mem:pets user=SA
2026-05-03T01:22:01.231Z INFO 187 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2026-05-03T01:22:01.256Z WARN 187 --- [ 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-05-03T01:22:01.279Z INFO 187 --- [ 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-05-03T01:22:02.500Z INFO 187 --- [ 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-05-03T01:22:02.606Z INFO 187 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-03T01:22:03.972Z INFO 187 --- [ main] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:pets'
2026-05-03T01:22:03.995Z INFO 187 --- [ main] o.s.b.a.e.web.EndpointLinksResolver : Exposing 1 endpoint beneath base path '/actuator'
2026-05-03T01:22:04.068Z INFO 187 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8999 (http) with context path '/api'
2026-05-03T01:22:04.101Z INFO 187 --- [ main] c.e.udistrital.mdp.pets.MainApplication : Started MainApplication in 6.086 seconds (process running for 6.744)
[INFO]
[INFO] --- exec:1.6.0:exec (combine-collection) @ MP_202610_G81_E4_Back ---
Collection 'Default Tests' was successfully added.
Collection 'Lucero - persistencia' was successfully added.
Collection 'Orejitas y Colas' was successfully added.
Collection 'PetApp' 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_E4_Back ---
[INFO] Stopping application...
2026-05-03T01:22:04.727Z INFO 187 --- [on(2)-127.0.0.1] inMXBeanRegistrar$SpringApplicationAdmin : Application shutdown requested.
2026-05-03T01:22:04.734Z INFO 187 --- [on(2)-127.0.0.1] o.s.b.w.e.tomcat.GracefulShutdown : Commencing graceful shutdown. Waiting for active requests to complete
2026-05-03T01:22:04.739Z INFO 187 --- [tomcat-shutdown] o.s.b.w.e.tomcat.GracefulShutdown : Graceful shutdown complete
2026-05-03T01:22:04.747Z INFO 187 --- [on(2)-127.0.0.1] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
2026-05-03T01:22:04.764Z INFO 187 --- [on(2)-127.0.0.1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2026-05-03T01:22:04.767Z INFO 187 --- [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_E4_Back ---
[INFO] Installing /home/cecaduser/workspace/MP_202610_G81_E4_Back/pom.xml to /root/.m2/repository/co/edu/udistrital/mdp/MP_202610_G81_E4_Back/0.0.1-SNAPSHOT/MP_202610_G81_E4_Back-0.0.1-SNAPSHOT.pom
[INFO] Installing /home/cecaduser/workspace/MP_202610_G81_E4_Back/target/MP_202610_G81_E4_Back-0.0.1-SNAPSHOT.jar to /root/.m2/repository/co/edu/udistrital/mdp/MP_202610_G81_E4_Back/0.0.1-SNAPSHOT/MP_202610_G81_E4_Back-0.0.1-SNAPSHOT.jar
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 37.980 s
[INFO] Finished at: 2026-05-03T01:22:05Z
[INFO] ------------------------------------------------------------------------
![[Jenkins]](/jenkins/static/a2b248fc/images/svgs/logo.svg){kind=logo}
