Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:24.971Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 42
2026-04-06T12:59:24.971Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 42 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:24.977Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 48
2026-04-06T12:59:24.978Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 48 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:24.985Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 52
2026-04-06T12:59:24.985Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 52 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:24.992Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:24.998Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 59
2026-04-06T12:59:24.999Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 59 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.006Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 60
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.013Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-04-06T12:59:25.013Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.020Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-04-06T12:59:25.020Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.026Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 74
2026-04-06T12:59:25.027Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with ID: 74 deleted successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.033Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 78
2026-04-06T12:59:25.034Z WARN 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Attempted to delete trial cohabitation 78 but it is in progress
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.040Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.045Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting process to consult trial cohabitation with id = 82
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.051Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting deletion process for trial cohabitation ID: 999
Hibernate: select tce1_0.id,a1_0.id,a2_0.id,a2_1.email,a2_1.name,a2_1.password,a2_1.phone,a2_0.has_children,a2_0.has_other_pets,a2_0.housing_type,a1_0.adoption_date,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,mh1_0.id,mh1_0.description,mh1_0.last_checkout,mh1_0.notes,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament,a1_0.status,tce1_0.end_date,tce1_0.pet_id,tce1_0.result,tce1_0.start_date,tce1_0.status from trial_cohabitation_entity tce1_0 left join adoption_entity a1_0 on a1_0.id=tce1_0.adoption_id left join adopter_entity a2_0 on a2_0.id=a1_0.adopter_id left join user_entity a2_1 on a2_0.id=a2_1.id left join pet_entity p1_0 on p1_0.id=a1_0.pet_id left join medical_history_entity mh1_0 on p1_0.id=mh1_0.pet_id where tce1_0.id=?
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.058Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
2026-04-06T12:59:25.058Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation created successfully
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.065Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 95
2026-04-06T12:59:25.065Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 95 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.072Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 99
2026-04-06T12:59:25.073Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 99 updated successfully
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.079Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting creation process for trial cohabitation
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.086Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 106
Hibernate: delete from trial_cohabitation_entity tce1_0
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
Hibernate: insert into trial_cohabitation_entity (adoption_id,end_date,pet_id,result,start_date,status,id) values (?,?,?,?,?,?,default)
2026-04-06T12:59:25.093Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Starting update process for trial cohabitation with id = 107
2026-04-06T12:59:25.093Z INFO 71 --- [ main] c.e.u.m.p.s.TrialCohabitationService : Trial cohabitation with id = 107 updated successfully
[INFO] Tests run: 31, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.626 s -- in co.edu.udistrital.mdp.pets.services.TrialCohabitationServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.ReportServiceTest
2026-04-06T12:59:25.097Z INFO 71 --- [ 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-04-06T12:59:25.102Z INFO 71 --- [ 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-04-06T12:59:25.117Z INFO 71 --- [ main] c.e.u.m.pets.services.ReportServiceTest : Starting ReportServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-04-06T12:59:25.117Z INFO 71 --- [ main] c.e.u.m.pets.services.ReportServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-04-06T12:59:25.189Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-04-06T12:59:25.214Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 24 ms. Found 21 JPA repository interfaces.
2026-04-06T12:59:25.227Z INFO 71 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-04-06T12:59:25.237Z INFO 71 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:0af602cd-e413-40c8-9855-a2a899bb4fbb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-04-06T12:59:25.254Z INFO 71 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-04-06T12:59:25.255Z INFO 71 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-04-06T12:59:25.263Z INFO 71 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-04-06T12:59:25.264Z WARN 71 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-04-06T12:59:25.264Z INFO 71 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@28d9c5e']
Database driver: undefined/unknown
Database version: 2.3.232
Autocommit mode: undefined/unknown
Isolation level: undefined/unknown
Minimum pool size: undefined/unknown
Maximum pool size: undefined/unknown
Hibernate: create global temporary table HT_report_strategy_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_medical_event_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_return_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-04-06T12:59:25.379Z INFO 71 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (follow_up_date date, adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_event_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, reported_user_id bigint, reporter_id bigint, shelter_id bigint, strategy_id bigint, reason varchar(255), status enum ('PENDING','RESOLVED','REVIEWED'), primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table return_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table subscription_entity (active boolean, id bigint generated by default as identity, shelter_id bigint, user_id bigint, primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_report_strategy_entity add constraint FKktfiy86djtvw20h6565fl76bq foreign key (id) references report_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_event_report_strategy_entity add constraint FKsdm20588vdyki7ca5bfpu4ohi foreign key (id) references report_strategy_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FK6jux60r77sw05uia08u9dvsm4 foreign key (reported_user_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKe07325of08t46hkil1uoc038i foreign key (reporter_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists return_report_strategy_entity add constraint FKjsru2p38nruuct0fu1q64p5lu foreign key (id) references report_strategy_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FK4125j8wt2ul4p4dv9f57atjxq foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FKckoo8jnsf7bkp8kceutmrg31h foreign key (user_id) references user_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-04-06T12:59:25.404Z INFO 71 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-04-06T12:59:25.538Z INFO 71 --- [ main] c.e.u.m.pets.services.ReportServiceTest : Started ReportServiceTest in 0.434 seconds (process running for 23.352)
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_strategy_entity (id) values (default)
Hibernate: insert into medical_event_report_strategy_entity (id) values (?)
2026-04-06T12:59:25.545Z INFO 71 --- [ main] c.e.u.mdp.pets.services.ReportService : Creando reporte
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: delete from report_entity re1_0
Hibernate: insert into report_strategy_entity (id) values (default)
Hibernate: insert into return_report_strategy_entity (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0 where re1_0.strategy_id=?
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: select rse1_0.id,case when rse1_1.id is not null then 1 when rse1_2.id is not null then 2 when rse1_3.id is not null then 3 end from report_strategy_entity rse1_0 left join adoption_report_strategy_entity rse1_1 on rse1_0.id=rse1_1.id left join medical_event_report_strategy_entity rse1_2 on rse1_0.id=rse1_2.id left join return_report_strategy_entity rse1_3 on rse1_0.id=rse1_3.id where rse1_0.id=?
Hibernate: delete from report_entity re1_0
2026-04-06T12:59:25.567Z INFO 71 --- [ main] c.e.u.mdp.pets.services.ReportService : Creando reporte
2026-04-06T12:59:25.567Z INFO 71 --- [ main] c.e.u.mdp.pets.services.ReportService : Creando reporte
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
2026-04-06T12:59:25.569Z INFO 71 --- [ main] c.e.u.mdp.pets.services.ReportService : Creando reporte
Hibernate: delete from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
2026-04-06T12:59:25.582Z INFO 71 --- [ main] c.e.u.mdp.pets.services.ReportService : Eliminando reporte con id: 5
Hibernate: delete from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,rs1_0.id,case when rs1_1.id is not null then 1 when rs1_2.id is not null then 2 when rs1_3.id is not null then 3 end,ru1_0.id,case when ru1_3.id is not null then 1 when ru1_1.id is not null then 2 when ru1_2.id is not null then 3 end,ru1_0.email,ru1_0.name,ru1_0.password,ru1_0.phone,ru1_1.has_children,ru1_1.has_other_pets,ru1_1.housing_type,ru1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ru1_2.specialty,r1_0.id,case when r1_3.id is not null then 1 when r1_1.id is not null then 2 when r1_2.id is not null then 3 end,r1_0.email,r1_0.name,r1_0.password,r1_0.phone,r1_1.has_children,r1_1.has_other_pets,r1_1.housing_type,r1_2.availability,s2_0.id,s2_0.city,s2_0.description,s2_0.email,s2_0.gallery,s2_0.name,r1_2.specialty,s3_0.id,s3_0.city,s3_0.description,s3_0.email,s3_0.gallery,s3_0.name,re1_0.status from report_entity re1_0 left join report_strategy_entity rs1_0 on rs1_0.id=re1_0.strategy_id left join adoption_report_strategy_entity rs1_1 on rs1_0.id=rs1_1.id left join medical_event_report_strategy_entity rs1_2 on rs1_0.id=rs1_2.id left join return_report_strategy_entity rs1_3 on rs1_0.id=rs1_3.id left join user_entity ru1_0 on ru1_0.id=re1_0.reported_user_id left join adopter_entity ru1_1 on ru1_0.id=ru1_1.id left join veterinarian_entity ru1_2 on ru1_0.id=ru1_2.id left join mock_user ru1_3 on ru1_0.id=ru1_3.id left join shelter_entity s1_0 on s1_0.id=ru1_2.shelter_id left join user_entity r1_0 on r1_0.id=re1_0.reporter_id left join adopter_entity r1_1 on r1_0.id=r1_1.id left join veterinarian_entity r1_2 on r1_0.id=r1_2.id left join mock_user r1_3 on r1_0.id=r1_3.id left join shelter_entity s2_0 on s2_0.id=r1_2.shelter_id left join shelter_entity s3_0 on s3_0.id=re1_0.shelter_id where re1_0.id=?
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: delete from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,rs1_0.id,case when rs1_1.id is not null then 1 when rs1_2.id is not null then 2 when rs1_3.id is not null then 3 end,ru1_0.id,case when ru1_3.id is not null then 1 when ru1_1.id is not null then 2 when ru1_2.id is not null then 3 end,ru1_0.email,ru1_0.name,ru1_0.password,ru1_0.phone,ru1_1.has_children,ru1_1.has_other_pets,ru1_1.housing_type,ru1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ru1_2.specialty,r1_0.id,case when r1_3.id is not null then 1 when r1_1.id is not null then 2 when r1_2.id is not null then 3 end,r1_0.email,r1_0.name,r1_0.password,r1_0.phone,r1_1.has_children,r1_1.has_other_pets,r1_1.housing_type,r1_2.availability,s2_0.id,s2_0.city,s2_0.description,s2_0.email,s2_0.gallery,s2_0.name,r1_2.specialty,s3_0.id,s3_0.city,s3_0.description,s3_0.email,s3_0.gallery,s3_0.name,re1_0.status from report_entity re1_0 left join report_strategy_entity rs1_0 on rs1_0.id=re1_0.strategy_id left join adoption_report_strategy_entity rs1_1 on rs1_0.id=rs1_1.id left join medical_event_report_strategy_entity rs1_2 on rs1_0.id=rs1_2.id left join return_report_strategy_entity rs1_3 on rs1_0.id=rs1_3.id left join user_entity ru1_0 on ru1_0.id=re1_0.reported_user_id left join adopter_entity ru1_1 on ru1_0.id=ru1_1.id left join veterinarian_entity ru1_2 on ru1_0.id=ru1_2.id left join mock_user ru1_3 on ru1_0.id=ru1_3.id left join shelter_entity s1_0 on s1_0.id=ru1_2.shelter_id left join user_entity r1_0 on r1_0.id=re1_0.reporter_id left join adopter_entity r1_1 on r1_0.id=r1_1.id left join veterinarian_entity r1_2 on r1_0.id=r1_2.id left join mock_user r1_3 on r1_0.id=r1_3.id left join shelter_entity s2_0 on s2_0.id=r1_2.shelter_id left join shelter_entity s3_0 on s3_0.id=re1_0.shelter_id where re1_0.id=?
Hibernate: delete from report_entity re1_0
2026-04-06T12:59:25.604Z INFO 71 --- [ main] c.e.u.mdp.pets.services.ReportService : Eliminando reporte con id: 999
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,rs1_0.id,case when rs1_1.id is not null then 1 when rs1_2.id is not null then 2 when rs1_3.id is not null then 3 end,ru1_0.id,case when ru1_3.id is not null then 1 when ru1_1.id is not null then 2 when ru1_2.id is not null then 3 end,ru1_0.email,ru1_0.name,ru1_0.password,ru1_0.phone,ru1_1.has_children,ru1_1.has_other_pets,ru1_1.housing_type,ru1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ru1_2.specialty,r1_0.id,case when r1_3.id is not null then 1 when r1_1.id is not null then 2 when r1_2.id is not null then 3 end,r1_0.email,r1_0.name,r1_0.password,r1_0.phone,r1_1.has_children,r1_1.has_other_pets,r1_1.housing_type,r1_2.availability,s2_0.id,s2_0.city,s2_0.description,s2_0.email,s2_0.gallery,s2_0.name,r1_2.specialty,s3_0.id,s3_0.city,s3_0.description,s3_0.email,s3_0.gallery,s3_0.name,re1_0.status from report_entity re1_0 left join report_strategy_entity rs1_0 on rs1_0.id=re1_0.strategy_id left join adoption_report_strategy_entity rs1_1 on rs1_0.id=rs1_1.id left join medical_event_report_strategy_entity rs1_2 on rs1_0.id=rs1_2.id left join return_report_strategy_entity rs1_3 on rs1_0.id=rs1_3.id left join user_entity ru1_0 on ru1_0.id=re1_0.reported_user_id left join adopter_entity ru1_1 on ru1_0.id=ru1_1.id left join veterinarian_entity ru1_2 on ru1_0.id=ru1_2.id left join mock_user ru1_3 on ru1_0.id=ru1_3.id left join shelter_entity s1_0 on s1_0.id=ru1_2.shelter_id left join user_entity r1_0 on r1_0.id=re1_0.reporter_id left join adopter_entity r1_1 on r1_0.id=r1_1.id left join veterinarian_entity r1_2 on r1_0.id=r1_2.id left join mock_user r1_3 on r1_0.id=r1_3.id left join shelter_entity s2_0 on s2_0.id=r1_2.shelter_id left join shelter_entity s3_0 on s3_0.id=re1_0.shelter_id where re1_0.id=?
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: insert into report_strategy_entity (id) values (default)
Hibernate: insert into adoption_report_strategy_entity (id) values (?)
Hibernate: delete from report_entity re1_0
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,re1_0.strategy_id,re1_0.reported_user_id,re1_0.reporter_id,re1_0.shelter_id,re1_0.status from report_entity re1_0 where re1_0.generate_date=?
Hibernate: delete from report_entity re1_0
Hibernate: insert into report_strategy_entity (id) values (default)
Hibernate: insert into return_report_strategy_entity (id) values (?)
Hibernate: insert into user_entity (email,name,password,phone,id) values (?,?,?,?,default)
Hibernate: insert into adopter_entity (has_children,has_other_pets,housing_type,id) values (?,?,?,?)
2026-04-06T12:59:25.624Z INFO 71 --- [ main] c.e.u.mdp.pets.services.ReportService : Creando reporte
Hibernate: insert into report_entity (generate_date,reason,strategy_id,reported_user_id,reporter_id,shelter_id,status,id) values (?,?,?,?,?,?,?,default)
Hibernate: delete from report_entity re1_0
Hibernate: delete from report_entity re1_0
Hibernate: select re1_0.id,re1_0.generate_date,re1_0.reason,rs1_0.id,case when rs1_1.id is not null then 1 when rs1_2.id is not null then 2 when rs1_3.id is not null then 3 end,ru1_0.id,case when ru1_3.id is not null then 1 when ru1_1.id is not null then 2 when ru1_2.id is not null then 3 end,ru1_0.email,ru1_0.name,ru1_0.password,ru1_0.phone,ru1_1.has_children,ru1_1.has_other_pets,ru1_1.housing_type,ru1_2.availability,s1_0.id,s1_0.city,s1_0.description,s1_0.email,s1_0.gallery,s1_0.name,ru1_2.specialty,r1_0.id,case when r1_3.id is not null then 1 when r1_1.id is not null then 2 when r1_2.id is not null then 3 end,r1_0.email,r1_0.name,r1_0.password,r1_0.phone,r1_1.has_children,r1_1.has_other_pets,r1_1.housing_type,r1_2.availability,s2_0.id,s2_0.city,s2_0.description,s2_0.email,s2_0.gallery,s2_0.name,r1_2.specialty,s3_0.id,s3_0.city,s3_0.description,s3_0.email,s3_0.gallery,s3_0.name,re1_0.status from report_entity re1_0 left join report_strategy_entity rs1_0 on rs1_0.id=re1_0.strategy_id left join adoption_report_strategy_entity rs1_1 on rs1_0.id=rs1_1.id left join medical_event_report_strategy_entity rs1_2 on rs1_0.id=rs1_2.id left join return_report_strategy_entity rs1_3 on rs1_0.id=rs1_3.id left join user_entity ru1_0 on ru1_0.id=re1_0.reported_user_id left join adopter_entity ru1_1 on ru1_0.id=ru1_1.id left join veterinarian_entity ru1_2 on ru1_0.id=ru1_2.id left join mock_user ru1_3 on ru1_0.id=ru1_3.id left join shelter_entity s1_0 on s1_0.id=ru1_2.shelter_id left join user_entity r1_0 on r1_0.id=re1_0.reporter_id left join adopter_entity r1_1 on r1_0.id=r1_1.id left join veterinarian_entity r1_2 on r1_0.id=r1_2.id left join mock_user r1_3 on r1_0.id=r1_3.id left join shelter_entity s2_0 on s2_0.id=r1_2.shelter_id left join shelter_entity s3_0 on s3_0.id=re1_0.shelter_id where re1_0.id=?
[INFO] Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.538 s -- in co.edu.udistrital.mdp.pets.services.ReportServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
2026-04-06T12:59:25.637Z INFO 71 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest]: MedicalHistoryServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-04-06T12:59:25.641Z INFO 71 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-04-06T12:59:25.655Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : Starting MedicalHistoryServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-04-06T12:59:25.655Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-04-06T12:59:25.709Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-04-06T12:59:25.729Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 21 JPA repository interfaces.
2026-04-06T12:59:25.740Z INFO 71 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-04-06T12:59:25.749Z INFO 71 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:891daa8e-70bf-420e-9958-20c2363fec62;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-04-06T12:59:25.763Z INFO 71 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-04-06T12:59:25.764Z INFO 71 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-04-06T12:59:25.771Z INFO 71 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-04-06T12:59:25.772Z WARN 71 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-04-06T12:59:25.773Z INFO 71 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@46bcdf43']
Database driver: undefined/unknown
Database version: 2.3.232
Autocommit mode: undefined/unknown
Isolation level: undefined/unknown
Minimum pool size: undefined/unknown
Maximum pool size: undefined/unknown
Hibernate: create global temporary table HT_report_strategy_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_medical_event_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_return_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-04-06T12:59:25.885Z INFO 71 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (follow_up_date date, adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_event_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, reported_user_id bigint, reporter_id bigint, shelter_id bigint, strategy_id bigint, reason varchar(255), status enum ('PENDING','RESOLVED','REVIEWED'), primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table return_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table subscription_entity (active boolean, id bigint generated by default as identity, shelter_id bigint, user_id bigint, primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_report_strategy_entity add constraint FKktfiy86djtvw20h6565fl76bq foreign key (id) references report_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_event_report_strategy_entity add constraint FKsdm20588vdyki7ca5bfpu4ohi foreign key (id) references report_strategy_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FK6jux60r77sw05uia08u9dvsm4 foreign key (reported_user_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKe07325of08t46hkil1uoc038i foreign key (reporter_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists return_report_strategy_entity add constraint FKjsru2p38nruuct0fu1q64p5lu foreign key (id) references report_strategy_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FK4125j8wt2ul4p4dv9f57atjxq foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FKckoo8jnsf7bkp8kceutmrg31h foreign key (user_id) references user_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-04-06T12:59:25.905Z INFO 71 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-04-06T12:59:26.019Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryServiceTest : Started MedicalHistoryServiceTest in 0.376 seconds (process running for 23.833)
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.030Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando eliminación de la historia clínica ID: 999999
Hibernate: select count(*) from medical_history_entity mhe1_0 where mhe1_0.id=?
2026-04-06T12:59:26.033Z ERROR 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Intento de eliminar historia clínica inexistente con ID: 999999
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.043Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Consultando historia clínica con id = 4
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.053Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando actualización de historia clínica con id = 7
2026-04-06T12:59:26.054Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Historia clínica con id = 7 actualizada exitosamente
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
2026-04-06T12:59:26.065Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando actualización de historia clínica con id = 123456789
Hibernate: select mhe1_0.id,mhe1_0.description,mhe1_0.last_checkout,mhe1_0.notes,p1_0.id,p1_0.activity_level,p1_0.age,p1_0.breed,p1_0.description,p1_0.good_with_kids,p1_0.good_with_pets,p1_0.name,p1_0.origin,p1_0.photos,p1_0.sex,p1_0.shelter_id,p1_0.size,p1_0.space_required,p1_0.special_needs,p1_0.species,p1_0.status,p1_0.temperament from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where mhe1_0.id=?
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
2026-04-06T12:59:26.076Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando la creación de la historia clínica
Hibernate: select mhe1_0.id from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where p1_0.id=? fetch first ? rows only
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.080Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Historia clínica creada exitosamente id=16
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.089Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando eliminación de la historia clínica ID: 19
Hibernate: select count(*) from medical_history_entity mhe1_0 where mhe1_0.id=?
2026-04-06T12:59:26.090Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Historia clínica ID: 19 eliminada exitosamente
2026-04-06T12:59:26.091Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Consultando historia clínica con id = 19
2026-04-06T12:59:26.091Z ERROR 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Historia clínica con id 19 no encontrada
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.101Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando la creación de la historia clínica
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.110Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando la creación de la historia clínica
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.120Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando actualización de historia clínica con id = 27
Hibernate: delete from medical_history_entity mhe1_0
Hibernate: delete from pet_entity pe1_0
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
Hibernate: insert into pet_entity (activity_level,age,breed,description,good_with_kids,good_with_pets,name,origin,photos,sex,shelter_id,size,space_required,special_needs,species,status,temperament,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,default)
Hibernate: insert into medical_history_entity (description,last_checkout,notes,pet_id,id) values (?,?,?,?,default)
2026-04-06T12:59:26.129Z INFO 71 --- [ main] c.e.u.m.p.s.MedicalHistoryService : Iniciando la creación de la historia clínica
Hibernate: select mhe1_0.id from medical_history_entity mhe1_0 left join pet_entity p1_0 on p1_0.id=mhe1_0.pet_id where p1_0.id=? fetch first ? rows only
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.498 s -- in co.edu.udistrital.mdp.pets.services.MedicalHistoryServiceTest
[INFO] Running co.edu.udistrital.mdp.pets.services.VaccineServiceTest
2026-04-06T12:59:26.136Z INFO 71 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.pets.services.VaccineServiceTest]: VaccineServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-04-06T12:59:26.140Z INFO 71 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.pets.MainApplication for test class co.edu.udistrital.mdp.pets.services.VaccineServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.10)
2026-04-06T12:59:26.152Z INFO 71 --- [ main] c.e.u.m.p.services.VaccineServiceTest : Starting VaccineServiceTest using Java 21.0.4 with PID 71 (started by root in /home/cecaduser/workspace/MP_202610_G81_E1_Back)
2026-04-06T12:59:26.152Z INFO 71 --- [ main] c.e.u.m.p.services.VaccineServiceTest : No active profile set, falling back to 1 default profile: "default"
2026-04-06T12:59:26.207Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-04-06T12:59:26.227Z INFO 71 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 21 JPA repository interfaces.
2026-04-06T12:59:26.237Z INFO 71 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2026-04-06T12:59:26.246Z INFO 71 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:ce9f874c-0f19-4253-89a8-25bfde41ea01;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2026-04-06T12:59:26.259Z INFO 71 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-04-06T12:59:26.261Z INFO 71 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-04-06T12:59:26.267Z INFO 71 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-04-06T12:59:26.268Z WARN 71 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2026-04-06T12:59:26.269Z INFO 71 --- [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@3ccf3268']
Database driver: undefined/unknown
Database version: 2.3.232
Autocommit mode: undefined/unknown
Isolation level: undefined/unknown
Minimum pool size: undefined/unknown
Maximum pool size: undefined/unknown
Hibernate: create global temporary table HT_report_strategy_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adoption_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HT_user_entity(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate: create global temporary table HTE_user_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, availability varchar(255), email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_adopter_entity(has_children boolean, has_other_pets boolean, HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), housing_type varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_mock_user(HTE_IDENTITY bigint generated by default as identity, id bigint, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_medical_event_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_veterinarian_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, shelter_id bigint, availability varchar(255), email varchar(255), name varchar(255), password varchar(255), phone varchar(255), specialty varchar(255), primary key (HTE_IDENTITY)) TRANSACTIONAL
Hibernate: create global temporary table HTE_return_report_strategy_entity(HTE_IDENTITY bigint generated by default as identity, id bigint, primary key (HTE_IDENTITY)) TRANSACTIONAL
2026-04-06T12:59:26.360Z INFO 71 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
Hibernate: create table adopter_entity (has_children boolean, has_other_pets boolean, id bigint not null, housing_type varchar(255), primary key (id))
Hibernate: create table adoption_entity (adoption_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table adoption_follow_up_entity (follow_up_date date, adoption_id bigint, id bigint generated by default as identity, pet_id bigint, veterinarian_id bigint, frequency varchar(255), notes varchar(255), primary key (id))
Hibernate: create table adoption_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table adoption_request_entity (request_date date, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, strategy_id bigint, trial_cohabitation_id bigint unique, status varchar(255), primary key (id))
Hibernate: create table approval_strategy_entity (id bigint generated by default as identity, approval_type varchar(31) not null, primary key (id))
Hibernate: create table medical_event_entity (event_date date, id bigint generated by default as identity, medical_history_id bigint, veterinarian_id bigint, description varchar(255), diagnosis varchar(255), event_type varchar(255), treatment varchar(255), primary key (id))
Hibernate: create table medical_event_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table medical_history_entity (last_checkout date, id bigint generated by default as identity, pet_id bigint unique, notes varchar(1000), description varchar(255), primary key (id))
Hibernate: create table message_entity (is_read boolean, adopter_id bigint, id bigint generated by default as identity, shelter_id bigint, timestamp timestamp(6), content TEXT, primary key (id))
Hibernate: create table mock_user (id bigint not null, primary key (id))
Hibernate: create table notification_entity (is_read boolean, date timestamp(6), id bigint generated by default as identity, strategy_id bigint unique, user_id bigint, message varchar(255), primary key (id))
Hibernate: create table notification_strategy_entity (id bigint generated by default as identity, notification_type varchar(31) not null, primary key (id))
Hibernate: create table pet_entity (age integer, good_with_kids boolean, good_with_pets boolean, id bigint generated by default as identity, shelter_id bigint, activity_level varchar(255), breed varchar(255), description varchar(255), name varchar(255), origin varchar(255), photos varchar(255), sex varchar(255), size varchar(255), space_required varchar(255), special_needs varchar(255), species varchar(255), temperament varchar(255), status enum ('ADOPTED','AVAILABLE','IN_TRIAL','MEDICAL_TREATMENT','RESERVED'), primary key (id))
Hibernate: create table report_entity (generate_date date, event_id bigint, id bigint generated by default as identity, reported_user_id bigint, reporter_id bigint, shelter_id bigint, strategy_id bigint, reason varchar(255), status enum ('PENDING','RESOLVED','REVIEWED'), primary key (id))
Hibernate: create table report_strategy_entity (id bigint generated by default as identity, primary key (id))
Hibernate: create table return_report_strategy_entity (id bigint not null, primary key (id))
Hibernate: create table review_entity (date date, rating integer, adopter_id bigint, id bigint generated by default as identity, pet_id bigint, comment TEXT, primary key (id))
Hibernate: create table shelter_entity (id bigint generated by default as identity, city varchar(255), description varchar(255), email varchar(255), gallery varchar(255), name varchar(255), primary key (id))
Hibernate: create table shelter_event_entity (date date, id bigint generated by default as identity, shelter_id bigint, description varchar(255), location varchar(255), title varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table subscription_entity (active boolean, id bigint generated by default as identity, shelter_id bigint, user_id bigint, primary key (id))
Hibernate: create table trial_cohabitation_entity (end_date date, start_date date, adoption_id bigint unique, id bigint generated by default as identity, pet_id bigint, result varchar(255), status enum ('CANCELLED','COMPLETED','CREATED','IN_PROGRESS','PENDING'), primary key (id))
Hibernate: create table user_entity (id bigint generated by default as identity, email varchar(255), name varchar(255), password varchar(255), phone varchar(255), primary key (id))
Hibernate: create table vaccination_record_entity (application_date date, next_due_date date, vaccination_date date, id bigint generated by default as identity, medical_history_id bigint, pet_id bigint, vaccine_id bigint, veterinarian_id bigint, primary key (id))
Hibernate: create table vaccine_entity (validity_months integer, id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table veterinarian_entity (id bigint not null, shelter_id bigint, availability varchar(255), specialty varchar(255), primary key (id))
Hibernate: alter table if exists adopter_entity add constraint FKitj2sdxcctxrw6ql04jny7l9y foreign key (id) references user_entity
Hibernate: alter table if exists adoption_entity add constraint FK224d1qenh6y54c9lq828mmgx foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_entity add constraint FKqmviggw0khaskxup4cg7bvqku foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkxibwn0r1ep7bgevg86seymmc foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKkqclwmvja9dll86u1bn9ycwn0 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_follow_up_entity add constraint FKsump3rviut1cvfr8iv6vogfp4 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists adoption_report_strategy_entity add constraint FKktfiy86djtvw20h6565fl76bq foreign key (id) references report_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FK90j2qmgnqst03l9x6fpwf0aab foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKpdxe7jyb75mwugces1axydwtg foreign key (strategy_id) references approval_strategy_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKhanslcvxoi0t9cq07vsyerx7d foreign key (pet_id) references pet_entity
Hibernate: alter table if exists adoption_request_entity add constraint FKad0m44984i6frcsd86susx3df foreign key (trial_cohabitation_id) references trial_cohabitation_entity
Hibernate: alter table if exists medical_event_entity add constraint FKloam0wk3hbpns9awx08v8ttty foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists medical_event_entity add constraint FKmx3l6boot15lqesauq3y2k5t9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists medical_event_report_strategy_entity add constraint FKsdm20588vdyki7ca5bfpu4ohi foreign key (id) references report_strategy_entity
Hibernate: alter table if exists medical_history_entity add constraint FKfqo1kwpy0eom46u48u9i9ob79 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists message_entity add constraint FK1bx2fv4ukgy2ruq9gclvehfjw foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists message_entity add constraint FKc1jilfk3teueg8wfilq0u9h0y foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists mock_user add constraint FK1t7datqqs96rej2yoo133loxs foreign key (id) references user_entity
Hibernate: alter table if exists notification_entity add constraint FKpsofie2xkbprbd9jo128ocuy9 foreign key (strategy_id) references notification_strategy_entity
Hibernate: alter table if exists notification_entity add constraint FKgemicmmtfy225vqj5li4u96lk foreign key (user_id) references user_entity
Hibernate: alter table if exists pet_entity add constraint FK57h1lsq9l67lcsx43ftwwto1c foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK6c18c90k2vnskwos9leqbmxrv foreign key (strategy_id) references report_strategy_entity
Hibernate: alter table if exists report_entity add constraint FK6jux60r77sw05uia08u9dvsm4 foreign key (reported_user_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKe07325of08t46hkil1uoc038i foreign key (reporter_id) references user_entity
Hibernate: alter table if exists report_entity add constraint FKoa7u6l3jn2ueixs49yy8nrap3 foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists report_entity add constraint FK33bibp5ycbkys4c6g1dxm410t foreign key (event_id) references shelter_event_entity
Hibernate: alter table if exists return_report_strategy_entity add constraint FKjsru2p38nruuct0fu1q64p5lu foreign key (id) references report_strategy_entity
Hibernate: alter table if exists review_entity add constraint FK8w6fpunff42r2ytatsjbb4o96 foreign key (adopter_id) references adopter_entity
Hibernate: alter table if exists review_entity add constraint FKhtmwv0o4w6vp5k7w088xwk0yt foreign key (pet_id) references pet_entity
Hibernate: alter table if exists shelter_event_entity add constraint FKjj4fox0olnc8o73kdgso782es foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FK4125j8wt2ul4p4dv9f57atjxq foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists subscription_entity add constraint FKckoo8jnsf7bkp8kceutmrg31h foreign key (user_id) references user_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FK608jf01b64pwvg12957nbsfsj foreign key (adoption_id) references adoption_entity
Hibernate: alter table if exists trial_cohabitation_entity add constraint FKrxpesflvao88mgm4bmys2c3k1 foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKfo5r2fgxn4ltp9oubgnilaq41 foreign key (medical_history_id) references medical_history_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKmgr6y74wfe15x04s9kwtod16f foreign key (pet_id) references pet_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKdahievfho7baue5s1sayxwom2 foreign key (vaccine_id) references vaccine_entity
Hibernate: alter table if exists vaccination_record_entity add constraint FKe2aflnq4dp8kne3km9enr1mt9 foreign key (veterinarian_id) references veterinarian_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKe8xa1wxe967urrvxsxpdm8y8r foreign key (shelter_id) references shelter_entity
Hibernate: alter table if exists veterinarian_entity add constraint FKl5lutaqpbd2jrfrerhn6a9g69 foreign key (id) references user_entity
2026-04-06T12:59:26.378Z INFO 71 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-04-06T12:59:26.490Z INFO 71 --- [ main] c.e.u.m.p.services.VaccineServiceTest : Started VaccineServiceTest in 0.348 seconds (process running for 24.305)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select ve1_0.id,ve1_0.description,ve1_0.name,ve1_0.validity_months from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
2026-04-06T12:59:26.552Z INFO 71 --- [ main] c.e.u.mdp.pets.services.VaccineService : Vacuna id=8 actualizada
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
2026-04-06T12:59:26.556Z INFO 71 --- [ main] c.e.u.mdp.pets.services.VaccineService : Vacuna creada id=10
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select count(*) from vaccine_entity ve1_0 where ve1_0.id=?
2026-04-06T12:59:26.566Z INFO 71 --- [ main] c.e.u.mdp.pets.services.VaccineService : Vacuna id=12 eliminada
Hibernate: delete from vaccine_entity ve1_0
Hibernate: insert into vaccine_entity (description,name,validity_months,id) values (?,?,?,default)
Hibernate: select ve1_0.id,ve1_0.description,ve1_0.name,ve1_0.validity_months from vaccine_entity ve1_0 where ve1_0.id=?
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.439 s -- in co.edu.udistrital.mdp.pets.services.VaccineServiceTest
2026-04-06T12:59:26.589Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.745Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.751Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.757Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.761Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.766Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.770Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.774Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.778Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.782Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.787Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.791Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.795Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.798Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.802Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.806Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.810Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
Hibernate: drop table if exists medical_event_report_strategy_entity cascade
Hibernate: drop table if exists medical_history_entity cascade
Hibernate: drop table if exists message_entity cascade
Hibernate: drop table if exists mock_user cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists notification_strategy_entity cascade
Hibernate: drop table if exists pet_entity cascade
Hibernate: drop table if exists report_entity cascade
Hibernate: drop table if exists report_strategy_entity cascade
Hibernate: drop table if exists return_report_strategy_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists shelter_entity cascade
Hibernate: drop table if exists shelter_event_entity cascade
Hibernate: drop table if exists subscription_entity cascade
Hibernate: drop table if exists trial_cohabitation_entity cascade
Hibernate: drop table if exists user_entity cascade
Hibernate: drop table if exists vaccination_record_entity cascade
Hibernate: drop table if exists vaccine_entity cascade
Hibernate: drop table if exists veterinarian_entity cascade
2026-04-06T12:59:26.813Z INFO 71 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists adopter_entity cascade
Hibernate: drop table if exists adoption_entity cascade
Hibernate: drop table if exists adoption_follow_up_entity cascade
Hibernate: drop table if exists adoption_report_strategy_entity cascade
Hibernate: drop table if exists adoption_request_entity cascade
Hibernate: drop table if exists approval_strategy_entity cascade
Hibernate: drop table if exists medical_event_entity cascade
[INFO]
[INFO] Results:
[INFO]
[INFO] Tests run: 388, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 26.173 s
[INFO] Finished at: 2026-04-06T12:59:26Z
[INFO] ------------------------------------------------------------------------
[Pipeline] }
$ docker stop --time=1 db259530b0d8093ba82cf8a2b3bef7706aff6e526819ebd3a7374ebcc48876be
$ docker rm -f --volumes db259530b0d8093ba82cf8a2b3bef7706aff6e526819ebd3a7374ebcc48876be
[Pipeline] // withDockerContainer
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Static Analysis)
[Pipeline] script
[Pipeline] {
[Pipeline] isUnix
[Pipeline] withEnv
[Pipeline] {
[Pipeline] sh
+ docker inspect -f . citools-isis2603:latest
.
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] withDockerContainer
Slave2 does not seem to be running inside a container
$ docker run -t -d -u 1000:1000 -v $HOME/.m2:/root/.m2:z -u root -w /home/cecaduser/workspace/MP_202610_G81_E1_Back -v /home/cecaduser/workspace/MP_202610_G81_E1_Back:/home/cecaduser/workspace/MP_202610_G81_E1_Back:rw,z -v /home/cecaduser/workspace/MP_202610_G81_E1_Back@tmp:/home/cecaduser/workspace/MP_202610_G81_E1_Back@tmp:rw,z -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** citools-isis2603:latest cat
$ docker top b4676a18309d0a2e917f1a1f3b7b28e12024fde03f69bec1e1014636bb293d58 -eo pid,comm
[Pipeline] {
[Pipeline] sh
+ mvn sonar:sonar -Dsonar.token=**** -Dsonar.host.url=http://10.20.84.26:8082/sonar
[INFO] Scanning for projects...
[WARNING] The artifact org.codehaus.mojo:sonar-maven-plugin:jar:4.0.0.4121 has been relocated to org.sonarsource.scanner.maven:sonar-maven-plugin:jar:4.0.0.4121: SonarQube plugin was moved to SonarSource organisation
[INFO]
[INFO] ------------< co.edu.udistrital.mdp:MP_202610_G81_E1_Back >-------------
[INFO] Building MP_202610_G81_E1_Back 0.0.1-SNAPSHOT
[INFO] from pom.xml
[INFO] --------------------------------[ jar ]---------------------------------
[INFO]
[INFO] --- sonar:4.0.0.4121:sonar (default-cli) @ MP_202610_G81_E1_Back ---
[WARNING] 12:59:31.756 Using an unspecified version instead of an explicit plugin version may introduce breaking analysis changes at an unwanted time. It is highly recommended to use an explicit version, e.g. 'org.sonarsource.scanner.maven:sonar-maven-plugin:4.0.0.4121'.
[INFO] 12:59:31.765 Java 21.0.4 Eclipse Adoptium (64-bit)
[INFO] 12:59:31.766 Linux 6.17.0-19-generic (amd64)
[INFO] 12:59:31.939 User cache: /root/.sonar/cache
[ERROR] 13:00:02.023 SonarQube server [http://10.20.84.26:8082/sonar] can not be reached
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 31.423 s
[INFO] Finished at: 2026-04-06T13:00:02Z
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.sonarsource.scanner.maven:sonar-maven-plugin:4.0.0.4121:sonar (default-cli) on project MP_202610_G81_E1_Back: Unable to execute SonarScanner analysis: Fail to get bootstrap index from server: Connect timed out -> [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/MojoExecutionException[Pipeline] }
$ docker stop --time=1 b4676a18309d0a2e917f1a1f3b7b28e12024fde03f69bec1e1014636bb293d58
$ docker rm -f --volumes b4676a18309d0a2e917f1a1f3b7b28e12024fde03f69bec1e1014636bb293d58
[Pipeline] // withDockerContainer
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] cleanWs
[WS-CLEANUP] Deleting project workspace...
[WS-CLEANUP] Deferred wipeout is used...
[WS-CLEANUP] done
[Pipeline] deleteDir
[Pipeline] dir
Running in /home/cecaduser/workspace/MP_202610_G81_E1_Back/MP_202610_G81_E1_Back@tmp
[Pipeline] {
[Pipeline] deleteDir
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] End of Pipeline
ERROR: script returned exit code 1
Finished: FAILURE
![[Jenkins]](/jenkins/static/a2b248fc/images/svgs/logo.svg){kind=logo}
