![[Jenkins]](/jenkins/static/ed8ccf5c/images/svgs/logo.svg){kind=logo}
Started by GitHub push by DrkGodEater9 Obtained Jenkinsfile from git https://github.com/UDFJDC-ModelosProgramacion/MP_202530_G81_E4_DogSpa_Back [Pipeline] Start of Pipeline [Pipeline] node Running on Slave2 in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back [Pipeline] { [Pipeline] stage [Pipeline] { (Declarative: Checkout SCM) [Pipeline] checkout Selected Git installation does not exist. Using Default The recommended git tool is: NONE using credential josejbocanegra Cloning the remote Git repository Cloning repository https://github.com/UDFJDC-ModelosProgramacion/MP_202530_G81_E4_DogSpa_Back > git init /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back # timeout=10 Fetching upstream changes from https://github.com/UDFJDC-ModelosProgramacion/MP_202530_G81_E4_DogSpa_Back > git --version # timeout=10 > git --version # 'git version 2.43.0' using GIT_ASKPASS to set credentials > git fetch --tags --force --progress -- https://github.com/UDFJDC-ModelosProgramacion/MP_202530_G81_E4_DogSpa_Back +refs/heads/*:refs/remotes/origin/* # timeout=10 Avoid second fetch Checking out Revision 5b67838fc0236af79c2fe46795791bcab0d86f5b (refs/remotes/origin/main) Commit message: "Merge pull request #16 from UDFJDC-ModelosProgramacion/develop" > git config remote.origin.url https://github.com/UDFJDC-ModelosProgramacion/MP_202530_G81_E4_DogSpa_Back # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 > git rev-parse refs/remotes/origin/main^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f 5b67838fc0236af79c2fe46795791bcab0d86f5b # timeout=10 > git rev-list --no-walk 779c75aef6f87ae630c9a3541c75da227e840612 # timeout=10 [Pipeline] } [Pipeline] // stage [Pipeline] withEnv [Pipeline] { [Pipeline] withCredentials Masking supported pattern matches of $SONAR_TOKEN [Pipeline] { [Pipeline] withEnv [Pipeline] { [Pipeline] stage [Pipeline] { (Checkout) [Pipeline] scmSkip SCM Skip: Pattern .*\[ci-skip\].* NOT matched on message: Implement service layer with comprehensive tests - Added PersonService with CRUD operations - Added AdminService with business logic - Added UserService with validation - Created comprehensive unit tests for all services - Fixed exception handling declarations in tests Services include: - Create, read, update, delete operations - Input validation and error handling - Proper exception throwing for not found cases Tests include: - Happy path scenarios - Edge cases and error conditions - Proper exception testing [Pipeline] git Selected Git installation does not exist. Using Default The recommended git tool is: NONE Warning: CredentialId "c0e8826e-5e2c-4c1c-a484-6c17d53ac539" could not be found. Fetching changes from the remote Git repository Checking out Revision 5b67838fc0236af79c2fe46795791bcab0d86f5b (refs/remotes/origin/main) Commit message: "Merge pull request #16 from UDFJDC-ModelosProgramacion/develop" [Pipeline] } [Pipeline] // stage [Pipeline] stage [Pipeline] { (Build) [Pipeline] script [Pipeline] { [Pipeline] isUnix [Pipeline] withEnv [Pipeline] { [Pipeline] sh + docker inspect -f . citools-isis2603:latest . [Pipeline] } [Pipeline] // withEnv [Pipeline] withDockerContainer > git rev-parse --resolve-git-dir /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back/.git # timeout=10 > git config remote.origin.url https://github.com/UDFJDC-ModelosProgramacion/MP_202530_G81_E4_DogSpa_Back # timeout=10 Fetching upstream changes from https://github.com/UDFJDC-ModelosProgramacion/MP_202530_G81_E4_DogSpa_Back > git --version # timeout=10 > git --version # 'git version 2.43.0' > git fetch --tags --force --progress -- https://github.com/UDFJDC-ModelosProgramacion/MP_202530_G81_E4_DogSpa_Back +refs/heads/*:refs/remotes/origin/* # timeout=10 > git rev-parse refs/remotes/origin/main^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f 5b67838fc0236af79c2fe46795791bcab0d86f5b # timeout=10 > git branch -a -v --no-abbrev # timeout=10 > git checkout -b main 5b67838fc0236af79c2fe46795791bcab0d86f5b # timeout=10 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_202530_G81_E4_DogSpa_Back -v /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back:/home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back:rw,z -v /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back@tmp:/home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_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 60da8a9a7280b21e608c8667a6c9f9a8cefe244ef49cdeff82104854adddafb3 -eo pid,comm [Pipeline] { [Pipeline] sh + java -version openjdk version "21.0.4" 2024-07-16 LTS OpenJDK Runtime Environment Temurin-21.0.4+7 (build 21.0.4+7-LTS) OpenJDK 64-Bit Server VM Temurin-21.0.4+7 (build 21.0.4+7-LTS, mixed mode, sharing) + mvn clean install [INFO] Scanning for projects... [INFO] [INFO] ---------< co.edu.udistrital.mdp:MP_202530_G81_E4_DogSpa_Back >--------- [INFO] Building MP_202530_G81_E4_DogSpa_Back 0.0.1-SNAPSHOT [INFO] from pom.xml [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- clean:3.3.2:clean (default-clean) @ MP_202530_G81_E4_DogSpa_Back --- [INFO] [INFO] --- jacoco:0.8.11:prepare-agent (jacoco-initialize) @ MP_202530_G81_E4_DogSpa_Back --- [INFO] argLine set to -javaagent:/root/.m2/repository/org/jacoco/org.jacoco.agent/0.8.11/org.jacoco.agent-0.8.11-runtime.jar=destfile=/home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back/target/jacoco.exec [INFO] [INFO] --- resources:3.3.1:resources (default-resources) @ MP_202530_G81_E4_DogSpa_Back --- [INFO] Copying 1 resource from src/main/resources to target/classes [INFO] Copying 0 resource from src/main/resources to target/classes [INFO] [INFO] --- compiler:3.11.0:compile (default-compile) @ MP_202530_G81_E4_DogSpa_Back --- [INFO] Changes detected - recompiling the module! :source [INFO] Compiling 47 source files with javac [debug release 21] to target/classes [INFO] Annotation processing is enabled because one or more processors were found on the class path. A future release of javac may disable annotation processing unless at least one processor is specified by name (-processor), or a search path is specified (--processor-path, --processor-module-path), or annotation processing is enabled explicitly (-proc:only, -proc:full). Use -Xlint:-options to suppress this message. Use -proc:none to disable annotation processing. [INFO] [INFO] --- resources:3.3.1:testResources (default-testResources) @ MP_202530_G81_E4_DogSpa_Back --- [INFO] skip non existing resourceDirectory /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back/src/test/resources [INFO] [INFO] --- compiler:3.11.0:testCompile (default-testCompile) @ MP_202530_G81_E4_DogSpa_Back --- [INFO] Changes detected - recompiling the module! :dependency [INFO] Compiling 6 source files with javac [debug release 21] to target/test-classes [INFO] Annotation processing is enabled because one or more processors were found on the class path. A future release of javac may disable annotation processing unless at least one processor is specified by name (-processor), or a search path is specified (--processor-path, --processor-module-path), or annotation processing is enabled explicitly (-proc:only, -proc:full). Use -Xlint:-options to suppress this message. Use -proc:none to disable annotation processing. [INFO] [INFO] --- surefire:2.22.1:test (default-test) @ MP_202530_G81_E4_DogSpa_Back --- [INFO] [INFO] ------------------------------------------------------- [INFO] T E S T S [INFO] ------------------------------------------------------- [INFO] Running co.edu.udistrital.mdp.back.services.AdminServiceTest 05:03:35.186 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils -- Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.AdminServiceTest]: AdminServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration. 05:03:35.540 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper -- Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.AdminServiceTest . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 2025-10-06T05:03:36.195Z INFO 97 --- [ main] c.e.u.m.back.services.AdminServiceTest : Starting AdminServiceTest using Java 21.0.4 with PID 97 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back) 2025-10-06T05:03:36.198Z INFO 97 --- [ main] c.e.u.m.back.services.AdminServiceTest : No active profile set, falling back to 1 default profile: "default" 2025-10-06T05:03:36.809Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2025-10-06T05:03:36.955Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 130 ms. Found 14 JPA repository interfaces. 2025-10-06T05:03:37.047Z INFO 97 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version 2025-10-06T05:03:37.309Z INFO 97 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:e144e1d8-18b0-49a3-9083-a204693ed948;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa' 2025-10-06T05:03:37.950Z INFO 97 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2025-10-06T05:03:38.050Z INFO 97 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.4.4.Final 2025-10-06T05:03:38.117Z INFO 97 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 2025-10-06T05:03:38.511Z INFO 97 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 2025-10-06T05:03:38.597Z WARN 97 --- [ 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) 2025-10-06T05:03:40.686Z INFO 97 --- [ 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 branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id)) Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id)) Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id)) Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id)) Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id)) Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id)) Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id)) Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null) Hibernate: create table product_entity (popularity integer, price float(53), id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id)) Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null) Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, user_id bigint, reservation_status varchar(255), primary key (id)) Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id)) Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id)) Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null) Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id)) Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity 2025-10-06T05:03:40.831Z INFO 97 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2025-10-06T05:03:41.580Z INFO 97 --- [ main] c.e.u.m.back.services.AdminServiceTest : Started AdminServiceTest in 5.922 seconds (process running for 7.954) WARNING: A Java agent has been loaded dynamically (/root/.m2/repository/net/bytebuddy/byte-buddy-agent/1.14.12/byte-buddy-agent-1.14.12.jar) WARNING: If a serviceability tool is in use, please run with -XX:+EnableDynamicAgentLoading to hide this warning WARNING: If a serviceability tool is not in use, please run with -Djdk.instrument.traceUsage for more information WARNING: Dynamic loading of agents will be disallowed by default in a future release Hibernate: select ae1_0.id,ae1_0.address,ae1_0.email,ae1_0.lastname,ae1_0.name,ae1_0.password,ae1_0.telephone from person_entity ae1_0 where ae1_0.dtype='AdminEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'AdminEntity',default) Hibernate: select ae1_0.id,ae1_0.address,ae1_0.email,ae1_0.lastname,ae1_0.name,ae1_0.password,ae1_0.telephone from person_entity ae1_0 where ae1_0.dtype='AdminEntity' and ae1_0.id=? Hibernate: select ae1_0.id,ae1_0.address,ae1_0.email,ae1_0.lastname,ae1_0.name,ae1_0.password,ae1_0.telephone from person_entity ae1_0 where ae1_0.dtype='AdminEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'AdminEntity',default) Hibernate: select ae1_0.id,ae1_0.address,ae1_0.email,ae1_0.lastname,ae1_0.name,ae1_0.password,ae1_0.telephone from person_entity ae1_0 where ae1_0.dtype='AdminEntity' Hibernate: select ae1_0.id,ae1_0.address,ae1_0.email,ae1_0.lastname,ae1_0.name,ae1_0.password,ae1_0.telephone from person_entity ae1_0 where ae1_0.dtype='AdminEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'AdminEntity',default) Hibernate: select ae1_0.id,ae1_0.address,ae1_0.email,ae1_0.lastname,ae1_0.name,ae1_0.password,ae1_0.telephone from person_entity ae1_0 where ae1_0.dtype='AdminEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'AdminEntity',default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'AdminEntity',default) [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.842 s - in co.edu.udistrital.mdp.back.services.AdminServiceTest [INFO] Running co.edu.udistrital.mdp.back.services.PaymentServiceTest 2025-10-06T05:03:42.624Z INFO 97 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.PaymentServiceTest]: PaymentServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration. 2025-10-06T05:03:42.633Z INFO 97 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.PaymentServiceTest . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 2025-10-06T05:03:42.681Z INFO 97 --- [ main] c.e.u.m.b.services.PaymentServiceTest : Starting PaymentServiceTest using Java 21.0.4 with PID 97 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back) 2025-10-06T05:03:42.681Z INFO 97 --- [ main] c.e.u.m.b.services.PaymentServiceTest : No active profile set, falling back to 1 default profile: "default" 2025-10-06T05:03:42.778Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2025-10-06T05:03:42.799Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 20 ms. Found 14 JPA repository interfaces. 2025-10-06T05:03:42.823Z INFO 97 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version 2025-10-06T05:03:42.841Z INFO 97 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:304e2e64-1002-4dcb-bf14-dabc31da576a;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa' 2025-10-06T05:03:42.867Z INFO 97 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2025-10-06T05:03:42.869Z INFO 97 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 2025-10-06T05:03:42.873Z INFO 97 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 2025-10-06T05:03:42.875Z WARN 97 --- [ 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) 2025-10-06T05:03:43.158Z INFO 97 --- [ 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 branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id)) Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id)) Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id)) Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id)) Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id)) Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id)) Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id)) Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null) Hibernate: create table product_entity (popularity integer, price float(53), id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id)) Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null) Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, user_id bigint, reservation_status varchar(255), primary key (id)) Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id)) Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id)) Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null) Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id)) Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity 2025-10-06T05:03:43.208Z INFO 97 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2025-10-06T05:03:43.454Z INFO 97 --- [ main] c.e.u.m.b.services.PaymentServiceTest : Started PaymentServiceTest in 0.797 seconds (process running for 9.829) Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:43.830Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to process payment with id = {0} 2025-10-06T05:03:43.832Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Finishing process to process payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:43.859Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to complete payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:43.880Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to cancel payment with id = {0} 2025-10-06T05:03:43.881Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Finishing process to cancel payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:43.901Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to process payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:43.922Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to create payment Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=? Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:43.948Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to query all payments Hibernate: select pe1_0.id,pe1_0.amount,pe1_0.date,pe1_0.method,pe1_0.shopping_cart_id,pe1_0.status from payment pe1_0 Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:43.989Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to delete payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.006Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to update payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.024Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to create payment 2025-10-06T05:03:44.024Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Finishing process to create payment Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.055Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to query payment with id = {0} 2025-10-06T05:03:44.056Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Finishing process to query payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.072Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to update payment with id = {0} 2025-10-06T05:03:44.073Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Finishing process to update payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.089Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to cancel payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.105Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to update payment with id = {0} Hibernate: select pe1_0.id,pe1_0.amount,pe1_0.date,pe1_0.method,sc1_0.id,sc1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints,pe1_0.status from payment pe1_0 left join shopping_cart_entity sc1_0 on sc1_0.id=pe1_0.shopping_cart_id left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sc1_0.user_id where pe1_0.id=? Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.124Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to create payment Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.139Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to complete payment with id = {0} 2025-10-06T05:03:44.140Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Finishing process to complete payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.154Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to query payment with id = {0} Hibernate: select pe1_0.id,pe1_0.amount,pe1_0.date,pe1_0.method,sc1_0.id,sc1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints,pe1_0.status from payment pe1_0 left join shopping_cart_entity sc1_0 on sc1_0.id=pe1_0.shopping_cart_id left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sc1_0.user_id where pe1_0.id=? Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.172Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to delete payment with id = {0} Hibernate: select pe1_0.id,pe1_0.amount,pe1_0.date,pe1_0.method,sc1_0.id,sc1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints,pe1_0.status from payment pe1_0 left join shopping_cart_entity sc1_0 on sc1_0.id=pe1_0.shopping_cart_id left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sc1_0.user_id where pe1_0.id=? Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.190Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to create payment Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.204Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to delete payment with id = {0} 2025-10-06T05:03:44.209Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Finishing process to delete payment with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.225Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to create payment Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.240Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to create payment Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.255Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to query payments for shopping cart with id = {0} 2025-10-06T05:03:44.255Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Finishing process to query payments for shopping cart with id = {0} Hibernate: delete from payment Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) Hibernate: insert into payment (amount,date,method,shopping_cart_id,status,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.270Z INFO 97 --- [ main] c.e.u.mdp.back.services.PaymentService : Starting process to query payments for shopping cart with id = {0} Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=? [ERROR] Tests run: 23, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 1.618 s <<< FAILURE! - in co.edu.udistrital.mdp.back.services.PaymentServiceTest [ERROR] testCreatePayment Time elapsed: 0.033 s <<< FAILURE! org.opentest4j.AssertionFailedError: expected: <pending> but was: <wkZM7gO_Jy> at co.edu.udistrital.mdp.back.services.PaymentServiceTest.testCreatePayment(PaymentServiceTest.java:87) [ERROR] testGetPaymentsByShoppingCart Time elapsed: 0.015 s <<< FAILURE! org.opentest4j.AssertionFailedError: expected: <3> but was: <0> at co.edu.udistrital.mdp.back.services.PaymentServiceTest.testGetPaymentsByShoppingCart(PaymentServiceTest.java:290) [INFO] Running co.edu.udistrital.mdp.back.services.MultimediaServiceTest 2025-10-06T05:03:44.277Z INFO 97 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.MultimediaServiceTest]: MultimediaServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration. 2025-10-06T05:03:44.284Z INFO 97 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.MultimediaServiceTest . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 2025-10-06T05:03:44.309Z INFO 97 --- [ main] c.e.u.m.b.s.MultimediaServiceTest : Starting MultimediaServiceTest using Java 21.0.4 with PID 97 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back) 2025-10-06T05:03:44.309Z INFO 97 --- [ main] c.e.u.m.b.s.MultimediaServiceTest : No active profile set, falling back to 1 default profile: "default" 2025-10-06T05:03:44.381Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2025-10-06T05:03:44.399Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 17 ms. Found 14 JPA repository interfaces. 2025-10-06T05:03:44.425Z INFO 97 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version 2025-10-06T05:03:44.439Z INFO 97 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:e4a32401-addf-4fba-b3fd-5f664ba7c124;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa' 2025-10-06T05:03:44.462Z INFO 97 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2025-10-06T05:03:44.464Z INFO 97 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 2025-10-06T05:03:44.468Z INFO 97 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 2025-10-06T05:03:44.469Z WARN 97 --- [ 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) 2025-10-06T05:03:44.695Z INFO 97 --- [ 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 branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id)) Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id)) Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id)) Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id)) Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id)) Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id)) Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id)) Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null) Hibernate: create table product_entity (popularity integer, price float(53), id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id)) Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null) Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, user_id bigint, reservation_status varchar(255), primary key (id)) Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id)) Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id)) Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null) Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id)) Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity 2025-10-06T05:03:44.733Z INFO 97 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2025-10-06T05:03:44.907Z INFO 97 --- [ main] c.e.u.m.b.s.MultimediaServiceTest : Started MultimediaServiceTest in 0.619 seconds (process running for 11.281) Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.929Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to query multimedia with id = {0} 2025-10-06T05:03:44.931Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to query multimedia with id = {0} Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.945Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to query all multimedia elements Hibernate: select me1_0.id,me1_0.branch_id,me1_0.product_id,me1_0.service_id,me1_0.type,me1_0.url from multimedia_entity me1_0 Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.964Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to query multimedia with id = {0} Hibernate: select me1_0.id,b1_0.id,b1_0.address,b1_0.name,b1_0.phone,b1_0.zone,p1_0.id,p1_0.category,p1_0.description,p1_0.name,p1_0.popularity,p1_0.price,s1_0.id,s1_0.description,s1_0.duration,s1_0.name,s1_0.price,me1_0.type,me1_0.url from multimedia_entity me1_0 left join branch_entity b1_0 on b1_0.id=me1_0.branch_id left join product_entity p1_0 on p1_0.id=me1_0.product_id left join service_entity s1_0 on s1_0.id=me1_0.service_id where me1_0.id=? Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.980Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to delete multimedia with id = {0} Hibernate: select me1_0.id,me1_0.branch_id,me1_0.product_id,me1_0.service_id,me1_0.type,me1_0.url from multimedia_entity me1_0 2025-10-06T05:03:44.984Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to delete multimedia with id = {0} Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:44.997Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia Hibernate: select be1_0.id,be1_0.address,be1_0.name,be1_0.phone,be1_0.zone from branch_entity be1_0 where be1_0.id=? Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.012Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to update multimedia with id = {0} 2025-10-06T05:03:45.013Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to update multimedia with id = {0} Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.028Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.041Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to update multimedia with id = {0} Hibernate: select me1_0.id,b1_0.id,b1_0.address,b1_0.name,b1_0.phone,b1_0.zone,p1_0.id,p1_0.category,p1_0.description,p1_0.name,p1_0.popularity,p1_0.price,s1_0.id,s1_0.description,s1_0.duration,s1_0.name,s1_0.price,me1_0.type,me1_0.url from multimedia_entity me1_0 left join branch_entity b1_0 on b1_0.id=me1_0.branch_id left join product_entity p1_0 on p1_0.id=me1_0.product_id left join service_entity s1_0 on s1_0.id=me1_0.service_id where me1_0.id=? Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.056Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.072Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.086Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to delete multimedia with id = {0} Hibernate: select me1_0.id,b1_0.id,b1_0.address,b1_0.name,b1_0.phone,b1_0.zone,p1_0.id,p1_0.category,p1_0.description,p1_0.name,p1_0.popularity,p1_0.price,s1_0.id,s1_0.description,s1_0.duration,s1_0.name,s1_0.price,me1_0.type,me1_0.url from multimedia_entity me1_0 left join branch_entity b1_0 on b1_0.id=me1_0.branch_id left join product_entity p1_0 on p1_0.id=me1_0.product_id left join service_entity s1_0 on s1_0.id=me1_0.service_id where me1_0.id=? Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.100Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia 2025-10-06T05:03:45.101Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to create multimedia Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.114Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to delete multimedia with id = {0} Hibernate: select me1_0.id,me1_0.branch_id,me1_0.product_id,me1_0.service_id,me1_0.type,me1_0.url from multimedia_entity me1_0 Hibernate: delete from multimedia_entity Hibernate: delete from service_entity_branches Hibernate: delete from branch_entity Hibernate: delete from service_entity_branches Hibernate: delete from service_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default) Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) 2025-10-06T05:03:45.130Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia 2025-10-06T05:03:45.130Z INFO 97 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to create multimedia Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default) [ERROR] Tests run: 14, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.839 s <<< FAILURE! - in co.edu.udistrital.mdp.back.services.MultimediaServiceTest [ERROR] testCreateMultimediaWithInvalidUrl Time elapsed: 0.014 s <<< FAILURE! org.opentest4j.AssertionFailedError: Expected co.edu.udistrital.mdp.back.exceptions.IllegalOperationException to be thrown, but nothing was thrown. at co.edu.udistrital.mdp.back.services.MultimediaServiceTest.testCreateMultimediaWithInvalidUrl(MultimediaServiceTest.java:139) [INFO] Running co.edu.udistrital.mdp.back.services.UserServiceTest 2025-10-06T05:03:45.136Z INFO 97 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.UserServiceTest]: UserServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration. 2025-10-06T05:03:45.142Z INFO 97 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.UserServiceTest . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 2025-10-06T05:03:45.162Z INFO 97 --- [ main] c.e.u.mdp.back.services.UserServiceTest : Starting UserServiceTest using Java 21.0.4 with PID 97 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back) 2025-10-06T05:03:45.163Z INFO 97 --- [ main] c.e.u.mdp.back.services.UserServiceTest : No active profile set, falling back to 1 default profile: "default" 2025-10-06T05:03:45.226Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2025-10-06T05:03:45.242Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 15 ms. Found 14 JPA repository interfaces. 2025-10-06T05:03:45.259Z INFO 97 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version 2025-10-06T05:03:45.272Z INFO 97 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:d17e8ab3-38e7-42dc-b197-d71a8e9f8bb6;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa' 2025-10-06T05:03:45.290Z INFO 97 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2025-10-06T05:03:45.291Z INFO 97 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 2025-10-06T05:03:45.295Z INFO 97 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 2025-10-06T05:03:45.296Z WARN 97 --- [ 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) 2025-10-06T05:03:45.499Z INFO 97 --- [ 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 branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id)) Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id)) Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id)) Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id)) Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id)) Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id)) Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id)) Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null) Hibernate: create table product_entity (popularity integer, price float(53), id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id)) Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null) Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, user_id bigint, reservation_status varchar(255), primary key (id)) Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id)) Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id)) Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null) Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id)) Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity 2025-10-06T05:03:45.533Z INFO 97 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2025-10-06T05:03:45.687Z INFO 97 --- [ main] c.e.u.mdp.back.services.UserServiceTest : Started UserServiceTest in 0.542 seconds (process running for 12.061) Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints,sc1_0.id,sc1_0.total from person_entity ue1_0 left join shopping_cart_entity sc1_0 on ue1_0.id=sc1_0.user_id where ue1_0.dtype='UserEntity' and ue1_0.id=? Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity' Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity' Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.581 s - in co.edu.udistrital.mdp.back.services.UserServiceTest [INFO] Running co.edu.udistrital.mdp.back.services.ShoppingCartServiceTest 2025-10-06T05:03:45.727Z INFO 97 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.ShoppingCartServiceTest]: ShoppingCartServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration. 2025-10-06T05:03:45.734Z INFO 97 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.ShoppingCartServiceTest . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 2025-10-06T05:03:45.751Z INFO 97 --- [ main] c.e.u.m.b.s.ShoppingCartServiceTest : Starting ShoppingCartServiceTest using Java 21.0.4 with PID 97 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back) 2025-10-06T05:03:45.751Z INFO 97 --- [ main] c.e.u.m.b.s.ShoppingCartServiceTest : No active profile set, falling back to 1 default profile: "default" 2025-10-06T05:03:45.810Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2025-10-06T05:03:45.825Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 15 ms. Found 14 JPA repository interfaces. 2025-10-06T05:03:45.841Z INFO 97 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version 2025-10-06T05:03:45.853Z INFO 97 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:7f985e96-fd61-4fa0-8ac0-193b57319ebe;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa' 2025-10-06T05:03:45.870Z INFO 97 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2025-10-06T05:03:45.872Z INFO 97 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 2025-10-06T05:03:45.875Z INFO 97 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 2025-10-06T05:03:45.877Z WARN 97 --- [ 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) 2025-10-06T05:03:46.080Z INFO 97 --- [ 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 branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id)) Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id)) Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id)) Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id)) Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id)) Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id)) Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id)) Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null) Hibernate: create table product_entity (popularity integer, price float(53), id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id)) Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null) Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, user_id bigint, reservation_status varchar(255), primary key (id)) Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id)) Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id)) Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null) Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id)) Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity 2025-10-06T05:03:46.111Z INFO 97 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2025-10-06T05:03:46.272Z INFO 97 --- [ main] c.e.u.m.b.s.ShoppingCartServiceTest : Started ShoppingCartServiceTest in 0.536 seconds (process running for 12.646) Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.296Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to remove product with id = {0} from cart with id = {1} 2025-10-06T05:03:46.298Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to remove product from cart Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.318Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to create shopping cart Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints,sc1_0.id,sc1_0.total from person_entity ue1_0 left join shopping_cart_entity sc1_0 on ue1_0.id=sc1_0.user_id where ue1_0.dtype='UserEntity' and ue1_0.id=? Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.338Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to update shopping cart with id = {0} Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=? Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) 2025-10-06T05:03:46.360Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to create shopping cart 2025-10-06T05:03:46.361Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to create shopping cart Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.380Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to update shopping cart with id = {0} Hibernate: select pe1_0.id,pe1_0.category,pe1_0.description,pe1_0.name,pe1_0.popularity,pe1_0.price from product_entity pe1_0 where pe1_0.id=? Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.399Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to add product with id = {0} to cart with id = {1} Hibernate: select pe1_0.id,pe1_0.category,pe1_0.description,pe1_0.name,pe1_0.popularity,pe1_0.price from product_entity pe1_0 where pe1_0.id=? Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.416Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to delete shopping cart with id = {0} 2025-10-06T05:03:46.417Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to delete shopping cart with id = {0} Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.435Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to remove product with id = {0} from cart with id = {1} Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=? Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.454Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to query shopping cart with id = {0} 2025-10-06T05:03:46.455Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to query shopping cart with id = {0} Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.472Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to add product with id = {0} to cart with id = {1} 2025-10-06T05:03:46.473Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to add product to cart Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.492Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to update shopping cart with id = {0} 2025-10-06T05:03:46.492Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to update shopping cart with id = {0} Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.507Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to query all shopping carts Hibernate: select sce1_0.id,sce1_0.total,sce1_0.user_id from shopping_cart_entity sce1_0 Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.525Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to query shopping cart with id = {0} Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=? Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.541Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to add product with id = {0} to cart with id = {1} Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=? Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.557Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to remove product with id = {0} from cart with id = {1} Hibernate: select pe1_0.id,pe1_0.category,pe1_0.description,pe1_0.name,pe1_0.popularity,pe1_0.price from product_entity pe1_0 where pe1_0.id=? Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.574Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to create shopping cart Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.589Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to create shopping cart Hibernate: delete from product_entity_shopping_carts Hibernate: delete from shopping_cart_entity Hibernate: delete from product_entity_shopping_carts Hibernate: delete from product_entity Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity') Hibernate: delete from person_entity where dtype='UserEntity' Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into product_entity (category,description,name,popularity,price,id) values (?,?,?,?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default) Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default) 2025-10-06T05:03:46.604Z INFO 97 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to delete shopping cart with id = {0} Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=? [INFO] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.879 s - in co.edu.udistrital.mdp.back.services.ShoppingCartServiceTest [INFO] Running co.edu.udistrital.mdp.back.services.PersonServiceTest 2025-10-06T05:03:46.610Z INFO 97 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.PersonServiceTest]: PersonServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration. 2025-10-06T05:03:46.616Z INFO 97 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.PersonServiceTest . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 2025-10-06T05:03:46.633Z INFO 97 --- [ main] c.e.u.m.back.services.PersonServiceTest : Starting PersonServiceTest using Java 21.0.4 with PID 97 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back) 2025-10-06T05:03:46.634Z INFO 97 --- [ main] c.e.u.m.back.services.PersonServiceTest : No active profile set, falling back to 1 default profile: "default" 2025-10-06T05:03:46.691Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2025-10-06T05:03:46.706Z INFO 97 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14 ms. Found 14 JPA repository interfaces. 2025-10-06T05:03:46.720Z INFO 97 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version 2025-10-06T05:03:46.731Z INFO 97 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:4778ee76-f347-43e8-be4d-81f583f5d06b;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa' 2025-10-06T05:03:46.747Z INFO 97 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2025-10-06T05:03:46.749Z INFO 97 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 2025-10-06T05:03:46.752Z INFO 97 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 2025-10-06T05:03:46.754Z WARN 97 --- [ 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) 2025-10-06T05:03:46.936Z INFO 97 --- [ 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 branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id)) Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id)) Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id)) Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id)) Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id)) Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id)) Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id)) Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null) Hibernate: create table product_entity (popularity integer, price float(53), id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id)) Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null) Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, user_id bigint, reservation_status varchar(255), primary key (id)) Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id)) Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id)) Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null) Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id)) Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity 2025-10-06T05:03:46.965Z INFO 97 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2025-10-06T05:03:47.100Z INFO 97 --- [ main] c.e.u.m.back.services.PersonServiceTest : Started PersonServiceTest in 0.481 seconds (process running for 13.474) Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default) Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default) Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default) Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints,sc1_0.id,sc1_0.total,sc1_0.user_id from person_entity pe1_0 left join shopping_cart_entity sc1_0 on pe1_0.id=sc1_0.user_id where pe1_0.id=? Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default) Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default) Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default) Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default) Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0 Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default) Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints,sc1_0.id,sc1_0.total,sc1_0.user_id from person_entity pe1_0 left join shopping_cart_entity sc1_0 on pe1_0.id=sc1_0.user_id where pe1_0.id=? [INFO] Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.539 s - in co.edu.udistrital.mdp.back.services.PersonServiceTest 2025-10-06T05:03:47.170Z INFO 97 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' Hibernate: drop table if exists branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade 2025-10-06T05:03:47.315Z INFO 97 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' Hibernate: drop table if exists branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade 2025-10-06T05:03:47.322Z INFO 97 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' Hibernate: drop table if exists branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade 2025-10-06T05:03:47.329Z INFO 97 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' Hibernate: drop table if exists branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade 2025-10-06T05:03:47.336Z INFO 97 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' Hibernate: drop table if exists branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade 2025-10-06T05:03:47.342Z INFO 97 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' Hibernate: drop table if exists branch_entity cascade Hibernate: drop table if exists multimedia_entity cascade Hibernate: drop table if exists notification_entity cascade Hibernate: drop table if exists order_detail_entity cascade Hibernate: drop table if exists order_entity cascade Hibernate: drop table if exists payment cascade Hibernate: drop table if exists person_entity cascade Hibernate: drop table if exists person_entity_notifications cascade Hibernate: drop table if exists product_entity cascade Hibernate: drop table if exists product_entity_shopping_carts cascade Hibernate: drop table if exists reservation_entity cascade Hibernate: drop table if exists review_entity cascade Hibernate: drop table if exists service_entity cascade Hibernate: drop table if exists service_entity_branches cascade Hibernate: drop table if exists shopping_cart_entity cascade [INFO] [INFO] Results: [INFO] [ERROR] Failures: [ERROR] MultimediaServiceTest.testCreateMultimediaWithInvalidUrl:139 Expected co.edu.udistrital.mdp.back.exceptions.IllegalOperationException to be thrown, but nothing was thrown. [ERROR] PaymentServiceTest.testCreatePayment:87 expected: <pending> but was: <wkZM7gO_Jy> [ERROR] PaymentServiceTest.testGetPaymentsByShoppingCart:290 expected: <3> but was: <0> [INFO] [ERROR] Tests run: 70, Failures: 3, Errors: 0, Skipped: 0 [INFO] [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 18.861 s [INFO] Finished at: 2025-10-06T05:03:47Z [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.1:test (default-test) on project MP_202530_G81_E4_DogSpa_Back: There are test failures. [ERROR] [ERROR] Please refer to /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back/target/surefire-reports for the individual test results. [ERROR] Please refer to dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream. [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException [Pipeline] } $ docker stop --time=1 60da8a9a7280b21e608c8667a6c9f9a8cefe244ef49cdeff82104854adddafb3 $ docker rm -f --volumes 60da8a9a7280b21e608c8667a6c9f9a8cefe244ef49cdeff82104854adddafb3 [Pipeline] // withDockerContainer [Pipeline] } [Pipeline] // script [Pipeline] } [Pipeline] // stage [Pipeline] stage [Pipeline] { (Testing) Stage "Testing" skipped due to earlier failure(s) [Pipeline] getContext [Pipeline] } [Pipeline] // stage [Pipeline] stage [Pipeline] { (Static Analysis) Stage "Static Analysis" skipped due to earlier failure(s) [Pipeline] getContext [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_202530_G81_E4_DogSpa_Back/MP_202530_G81_E4_DogSpa_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