2025-05-18T23:06:27.904Z INFO 4760 --- [psyceful_api] [ Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [com.psyceful.psyceful_api.integration.PatientControllerTests]: PatientControllerTests does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2025-05-18T23:06:27.924Z INFO 4760 --- [psyceful_api] [ Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration com.psyceful.psyceful_api.PsycefulApiApplication for test class com.psyceful.psyceful_api.integration.PatientControllerTests
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.4.2)
2025-05-18T23:06:28.035Z INFO 4760 --- [psyceful_api] [ Test worker] c.p.p.i.PatientControllerTests : Starting PatientControllerTests using Java 21.0.7 with PID 4760 (started by jenkins in /home/jenkins/workspace/psyceful-api-build)
2025-05-18T23:06:28.039Z INFO 4760 --- [psyceful_api] [ Test worker] c.p.p.i.PatientControllerTests : The following 1 profile is active: "test"
2025-05-18T23:06:28.898Z INFO 4760 --- [psyceful_api] [ Test worker] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-05-18T23:06:28.975Z INFO 4760 --- [psyceful_api] [ Test worker] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 68 ms. Found 5 JPA repository interfaces.
2025-05-18T23:06:30.305Z INFO 4760 --- [psyceful_api] [ Test worker] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-05-18T23:06:30.334Z INFO 4760 --- [psyceful_api] [ Test worker] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2025-05-18T23:06:30.427Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-05-18T23:06:30.437Z INFO 4760 --- [psyceful_api] [ Test worker] com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Starting...
2025-05-18T23:06:30.450Z INFO 4760 --- [psyceful_api] [ Test worker] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - Added connection conn10: url=jdbc:h2:mem:testdb user=PSYCEFUL_TEST
2025-05-18T23:06:30.455Z INFO 4760 --- [psyceful_api] [ Test worker] com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Start completed.
2025-05-18T23:06:30.459Z WARN 4760 --- [psyceful_api] [ Test worker] 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-05-18T23:06:30.464Z INFO 4760 --- [psyceful_api] [ Test worker] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'HikariDataSource (HikariPool-2)']
Database driver: undefined/unknown
Database version: 2.3.232
Autocommit mode: undefined/unknown
Isolation level: undefined/unknown
Minimum pool size: undefined/unknown
Maximum pool size: undefined/unknown
Hibernate:
create global temporary table HTE_users(activated boolean, enabled boolean, rn_ integer not null, created_at timestamp(6), id bigint, updated_at timestamp(6), email varchar(255), firstname varchar(255), lastname varchar(255), password varchar(255), primary key (rn_)) TRANSACTIONAL
Hibernate:
create global temporary table HT_patients(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate:
create global temporary table HTE_patients(activated boolean, enabled boolean, rn_ integer not null, created_at timestamp(6), id bigint, updated_at timestamp(6), email varchar(255), firstname varchar(255), lastname varchar(255), password varchar(255), primary key (rn_)) TRANSACTIONAL
Hibernate:
create global temporary table HT_practitioners(id bigint not null, primary key (id)) TRANSACTIONAL
Hibernate:
create global temporary table HTE_practitioners(activated boolean, enabled boolean, rn_ integer not null, created_at timestamp(6), id bigint, updated_at timestamp(6), email varchar(255), firstname varchar(255), lastname varchar(255), password varchar(255), primary key (rn_)) TRANSACTIONAL
Hibernate:
create global temporary table HTE_tokens(rn_ integer not null, created_at timestamp(6), expire_at timestamp(6), id bigint, user_id bigint, validate_at timestamp(6), token varchar(255), type varchar(255), primary key (rn_)) TRANSACTIONAL
Hibernate:
create global temporary table HTE_roles(rn_ integer not null, id bigint, name varchar(255), primary key (rn_)) TRANSACTIONAL
Hibernate:
create global temporary table HT_users(id bigint not null, primary key (id)) TRANSACTIONAL
2025-05-18T23:06:31.783Z INFO 4760 --- [psyceful_api] [ Test worker] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2025-05-18T23:06:31.895Z INFO 4760 --- [psyceful_api] [ Test worker] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2025-05-18T23:06:33.221Z INFO 4760 --- [psyceful_api] [ Test worker] eAuthenticationProviderManagerConfigurer : Global AuthenticationManager configured with AuthenticationProvider bean with name authenticationProvider
2025-05-18T23:06:33.225Z WARN 4760 --- [psyceful_api] [ Test worker] r$InitializeUserDetailsManagerConfigurer : Global AuthenticationManager configured with an AuthenticationProvider bean. UserDetailsService beans will not be used by Spring Security for automatically configuring username/password login. Consider removing the AuthenticationProvider bean. Alternatively, consider using the UserDetailsService in a manually instantiated DaoAuthenticationProvider. If the current configuration is intentional, to turn off this warning, increase the logging level of 'org.springframework.security.config.annotation.authentication.configuration.InitializeUserDetailsBeanManagerConfigurer' to ERROR
2025-05-18T23:06:33.388Z WARN 4760 --- [psyceful_api] [ Test worker] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2025-05-18T23:06:34.215Z DEBUG 4760 --- [psyceful_api] [ Test worker] o.s.s.web.DefaultSecurityFilterChain : Will secure any request with filters: DisableEncodeUrlFilter, WebAsyncManagerIntegrationFilter, SecurityContextHolderFilter, HeaderWriterFilter, CorsFilter, LogoutFilter, JwtAuthFilter, RequestCacheAwareFilter, SecurityContextHolderAwareRequestFilter, AnonymousAuthenticationFilter, SessionManagementFilter, ExceptionTranslationFilter, AuthorizationFilter
2025-05-18T23:06:35.011Z INFO 4760 --- [psyceful_api] [ Test worker] c.p.p.i.PatientControllerTests : Started PatientControllerTests in 7.071 seconds (process running for 37.227)
Hibernate:
select
count(*)
from
roles r1_0
2025-05-18T23:06:35.138Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:35.138Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:35.142Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 4 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
next value for users_seq
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
patients
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
select
next value for tokens_seq
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
where
u1_0.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
patients
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:35.949Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:35.949Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:35.957Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 8 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
patients
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
select
next value for tokens_seq
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
patients
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
patients
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
where
u1_0.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
patients
where
id=?
Hibernate:
delete
from
users
where
id=?
Hibernate:
delete
from
patients
where
id=?
Hibernate:
delete
from
users
where
id=?
Hibernate:
delete
from
patients
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:37.348Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:37.353Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:37.364Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 11 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
patients
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
patients
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
count(*)
from
patients p1_0
Hibernate:
select
count(*)
from
users u1_0
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
patients
where
id=?
Hibernate:
delete
from
users
where
id=?
Hibernate:
delete
from
patients
where
id=?
Hibernate:
delete
from
users
where
id=?