Console Output
Skipping 492 KB..
Full Logbernate: 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 adopters (address,first_name,has_children,has_other_pets,housing_type,last_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adoptions (adopter_id,adoption_date,pet_id,status,veterinarian_id,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)
Hibernate: insert into adopters (address,first_name,has_children,has_other_pets,housing_type,last_name,id) values (?,?,?,?,?,?,default)
Hibernate: insert into adoptions (adopter_id,adoption_date,pet_id,status,veterinarian_id,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)
Hibernate: insert into adopters (address,first_name,has_children,has_other_pets,housing_type,last_name,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 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 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 (?,?)
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 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 (?,?)
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 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-02T22:28:17.406Z INFO 92 --- [ main] c.e.u.mdp.pets.services.AdoptionService : Intentando eliminar adopción con ID: 32
2026-05-02T22:28:17.406Z 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.774 s -- in co.edu.udistrital.mdp.pets.services.AdoptionServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ShelterServiceTest
2026-05-02T22:28:17.412Z 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-02T22:28:17.417Z 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-02T22:28:17.433Z 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-02T22:28:17.434Z INFO 92 --- [ main] c.e.u.m.p.services.ShelterServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-02T22:28:17.493Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-02T22:28:17.513Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 18 JPA repository interfaces.
2026-05-02T22:28:17.527Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-02T22:28:17.537Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:13906cd3-2059-45a4-9fff-2fec0c8da3d7;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-02T22:28:17.551Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-02T22:28:17.552Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-02T22:28:17.560Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-02T22:28:17.561Z 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-02T22:28:17.562Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@57176b15']
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-02T22:28:17.648Z 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-02T22:28:17.671Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-02T22:28:17.763Z INFO 92 --- [ main] c.e.u.m.p.services.ShelterServiceTest : Started ShelterServiceTest in 0.344 seconds (process running for 18.713)
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-02T22:28:17.777Z 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-02T22:28:17.803Z 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-02T22:28:17.816Z 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-02T22:28:17.824Z 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-02T22:28:17.833Z 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-02T22:28:17.843Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ShelterService : Deleting shelter with id: 16
2026-05-02T22:28:17.844Z 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-02T22:28:17.854Z 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-02T22:28:17.864Z 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-02T22:28:17.874Z 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-02T22:28:17.885Z 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-02T22:28:17.896Z 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-02T22:28:17.906Z 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-02T22:28:17.915Z 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-02T22:28:17.924Z 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.516 s -- in co.edu.udistrital.mdp.pets.services.ShelterServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.PetServiceTest
2026-05-02T22:28:17.931Z 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-02T22:28:17.937Z 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-02T22:28:17.950Z 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-02T22:28:17.951Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-02T22:28:18.002Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-02T22:28:18.022Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 18 ms. Found 18 JPA repository interfaces.
2026-05-02T22:28:18.033Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-02T22:28:18.042Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:0086e474-4d3d-416a-9882-3ca5a6883e81;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-02T22:28:18.055Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-02T22:28:18.056Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-02T22:28:18.063Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-02T22:28:18.064Z 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-02T22:28:18.064Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@192b9521']
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-02T22:28:18.142Z 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-02T22:28:18.163Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-02T22:28:18.276Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetServiceTest : Started PetServiceTest in 0.337 seconds (process running for 19.226)
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-02T22:28:18.292Z 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-02T22:28:18.305Z 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-02T22:28:18.319Z INFO 92 --- [ main] c.e.u.mdp.pets.services.PetService : Attempting to delete pet with ID: 7
2026-05-02T22:28:18.320Z 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-02T22:28:18.334Z 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-02T22:28:18.347Z 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-02T22:28:18.358Z 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-02T22:28:18.360Z 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-02T22:28:18.371Z 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.445 s -- in co.edu.udistrital.mdp.pets.services.PetServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
2026-05-02T22:28:18.376Z 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-02T22:28:18.380Z 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-02T22:28:18.393Z 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-02T22:28:18.393Z INFO 92 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-02T22:28:18.444Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-02T22:28:18.461Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 16 ms. Found 18 JPA repository interfaces.
2026-05-02T22:28:18.471Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-02T22:28:18.480Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:42de5de6-31ea-44eb-82f2-b34c53339772;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-02T22:28:18.493Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-02T22:28:18.495Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-02T22:28:18.501Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-02T22:28:18.502Z 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-02T22:28:18.503Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@696cfc28']
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-02T22:28:18.580Z 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-02T22:28:18.599Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-02T22:28:18.726Z INFO 92 --- [ main] c.e.u.m.p.s.VeterinarianServiceTest : Started VeterinarianServiceTest in 0.344 seconds (process running for 19.676)
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-02T22:28:18.750Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Actualizando veterinario con ID: 1
2026-05-02T22:28:18.751Z 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-02T22:28:18.767Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Creando nuevo veterinario
2026-05-02T22:28:18.767Z 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-02T22:28:18.778Z 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-02T22:28:18.794Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Eliminando veterinario con ID: 10
2026-05-02T22:28:18.795Z 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-02T22:28:18.813Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Eliminando veterinario con ID: 13
2026-05-02T22:28:18.813Z 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-02T22:28:18.829Z 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-02T22:28:18.842Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Actualizando veterinario con ID: 19
2026-05-02T22:28:18.842Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Buscando veterinario con ID: 19
2026-05-02T22:28:18.843Z ERROR 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Especialidad inválida detectada: yONuzWgoxd
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-02T22:28:18.854Z 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-02T22:28:18.868Z INFO 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Creando nuevo veterinario
2026-05-02T22:28:18.868Z ERROR 92 --- [ main] c.e.u.m.p.services.VeterinarianService : Especialidad inválida detectada: G6rihRDIp3
[INFO] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.496 s -- in co.edu.udistrital.mdp.pets.services.VeterinarianServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ReportServiceTest
2026-05-02T22:28:18.873Z 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-02T22:28:18.879Z 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-02T22:28:18.896Z 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-02T22:28:18.896Z INFO 92 --- [ main] c.e.u.m.pets.services.ReportServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-02T22:28:19.007Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-02T22:28:19.034Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 24 ms. Found 18 JPA repository interfaces.
2026-05-02T22:28:19.048Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-02T22:28:19.058Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:dbd1d217-f741-42b9-ab6f-fd07ca911fca;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-02T22:28:19.073Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-02T22:28:19.074Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-02T22:28:19.082Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-02T22:28:19.083Z 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-02T22:28:19.084Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@221a4506']
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-02T22:28:19.163Z 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-02T22:28:19.184Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-02T22:28:19.266Z INFO 92 --- [ main] c.e.u.m.pets.services.ReportServiceTest : Started ReportServiceTest in 0.385 seconds (process running for 20.217)
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-02T22:28:19.287Z 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-02T22:28:19.302Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Updating report with id: 5
2026-05-02T22:28:19.302Z 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-02T22:28:19.317Z INFO 92 --- [ main] c.e.u.mdp.pets.services.ReportService : Deleting report with id: 8
2026-05-02T22:28:19.317Z 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-02T22:28:19.331Z 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-02T22:28:19.345Z 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-02T22:28:19.359Z 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.492 s -- in co.edu.udistrital.mdp.pets.services.ReportServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VaccineServiceTest
2026-05-02T22:28:19.365Z 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-02T22:28:19.369Z 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-02T22:28:19.385Z 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-02T22:28:19.385Z INFO 92 --- [ main] c.e.u.m.p.services.VaccineServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-05-02T22:28:19.456Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-05-02T22:28:19.473Z INFO 92 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 16 ms. Found 18 JPA repository interfaces.
2026-05-02T22:28:19.483Z INFO 92 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-05-02T22:28:19.491Z INFO 92 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:e826b4c7-90e2-43b6-a8c1-ba0177239848;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-05-02T22:28:19.503Z INFO 92 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-05-02T22:28:19.505Z INFO 92 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-05-02T22:28:19.511Z INFO 92 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-05-02T22:28:19.512Z 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-02T22:28:19.512Z INFO 92 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@780bf0d4']
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-02T22:28:19.587Z 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-02T22:28:19.606Z INFO 92 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-05-02T22:28:19.697Z INFO 92 --- [ main] c.e.u.m.p.services.VaccineServiceTest : Started VaccineServiceTest in 0.323 seconds (process running for 20.647)
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: 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-02T22:28:19.725Z 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-02T22:28:19.734Z 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-02T22:28:19.743Z 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-02T22:28:19.752Z 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-02T22:28:19.760Z 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-02T22:28:19.768Z 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-02T22:28:19.774Z 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-02T22:28:19.782Z 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-02T22:28:19.789Z 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-02T22:28:19.798Z 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=?
[ERROR] Tests run: 11, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.437 s <<< FAILURE! -- in co.edu.udistrital.mdp.pets.services.VaccineServiceTest
[ERROR] co.edu.udistrital.mdp.pets.services.VaccineServiceTest.testCreatewithNullVaccinationRecord -- Time elapsed: 0.017 s <<< FAILURE!
org.opentest4j.AssertionFailedError: Expected co.edu.udistrital.mdp.pets.exceptions.IllegalOperationException to be thrown, but nothing was thrown.
at org.junit.jupiter.api.AssertionFailureBuilder.build(AssertionFailureBuilder.java:152)
at org.junit.jupiter.api.AssertThrows.assertThrows(AssertThrows.java:73)
at org.junit.jupiter.api.AssertThrows.assertThrows(AssertThrows.java:35)
at org.junit.jupiter.api.Assertions.assertThrows(Assertions.java:3128)
at co.edu.udistrital.mdp.pets.services.VaccineServiceTest.testCreatewithNullVaccinationRecord(VaccineServiceTest.java:101)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
2026-05-02T22:28:19.821Z INFO 92 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
[INFO]
[INFO] Results:
[INFO]
[ERROR] Failures:
[ERROR] VaccineServiceTest.testCreatewithNullVaccinationRecord:101 Expected co.edu.udistrital.mdp.pets.exceptions.IllegalOperationException to be thrown, but nothing was thrown.
[INFO]
[ERROR] Tests run: 139, Failures: 1, Errors: 0, Skipped: 0
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 27.882 s
[INFO] Finished at: 2026-05-02T22:28:20Z
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:3.2.5:test (default-test) on project MP_202610_G81_E4_Back: There are test failures.
[ERROR]
[ERROR] Please refer to /home/cecaduser/workspace/MP_202610_G81_E4_Back/target/surefire-reports for the individual test results.
[ERROR] Please refer to dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
![[Jenkins]](/jenkins/static/a2b248fc/images/svgs/logo.svg){kind=logo}
