I recently updated to Spring Boot 3.5.3 (from 3.4.5) which upgraded from HikariCP 5.1.0 to 6.3.0. I'm using Spring Data JPA with AWS RDS Postgres and Liquibase. After the upgrade, it is no longer able to retrieve a password (IAM token). Relevant code and stack trace are below. Note that overriding the HikariCP version to 5.1.0 fixes the issue.
@Configuration
public class PostgresConfig {
@Bean
public RdsUtilities rdsUtilities(ApplicationProperties applicationProperties) {
Region region = Region.of(applicationProperties.getRds().getRegion());
RdsClient rdsClient = RdsClient.builder().region(region).build();
return rdsClient.utilities();
}
@Bean
public StsClient stsClient(ApplicationProperties applicationProperties) {
Region region = Region.of(applicationProperties.getSts().getRegion());
return StsClient.builder().region(region).build();
}
@Bean
@Primary
@LiquibaseDataSource
public DataSource dataSource(ApplicationProperties applicationProperties, DataSourceProperties dataSourceProperties, RdsUtilities rdsUtil, StsClient stsClient) {
HikariDataSource ds = new RdsDataSource(applicationProperties.getRds(), rdsUtil, stsClient);
ds.setJdbcUrl(dataSourceProperties.getUrl());
ds.setUsername(dataSourceProperties.getUsername());
//ds.setPassword(ds.getPassword()); // setting password here allows it to initially connect but after the token expires, new connections can't be created
ds.setDriverClassName(dataSourceProperties.getDriverClassName());
ds.setMaxLifetime(applicationProperties.getPostgresConnectionLifetimeMs());
ds.setSchema(applicationProperties.getAuditSchema());
return ds;
}
}
public class RdsDataSource extends HikariDataSource {
private final ApplicationProperties.RdsConfig config;
private final RdsUtilities rdsUtil;
private final StsClient stsClient;
public RdsDataSource(ApplicationProperties.RdsConfig config, RdsUtilities rdsUtil, StsClient stsClient) {
super();
this.config = config;
this.rdsUtil = rdsUtil;
this.stsClient = stsClient;
}
//From: https://joelforjava.com/blog/2019/11/27/using-assume-role-with-aws-sdk.html
/**
* Get password for database by generating a token from AWS.
*
* ex: https://github.com/awsdocs/aws-doc-sdk-examples/blob/main/javav2/example_code/rds/src/main/java/com/example/rds/GenerateRDSAuthToken.java
*
* @return A token to be used as DB password.
*/
@Override
public String getPassword() {
AwsCredentialsProviderChain roleProviderChain = assumeRole();
String jdbcUrl = getJdbcUrl();
try {
URI jdbcUri = parseJdbcURL(jdbcUrl);
GenerateAuthenticationTokenRequest request = GenerateAuthenticationTokenRequest.builder()
.credentialsProvider(roleProviderChain)
.username(getUsername())
.hostname(jdbcUri.getHost())
.port(jdbcUri.getPort())
.build();
String token = rdsUtil.generateAuthenticationToken(request);
return token;
} catch (Exception e) {
log.error("Failed to generate RDS auth token {} for session {} at url {}", config.getRoleArn(), config.getSessionName(), jdbcUrl, e);
throw new RdsAuthTokenException(e, config.getRoleArn(), config.getSessionName(), jdbcUrl);
}
}
/**
* "Assume" the AWS RDS role. This has to be done to generate a token.
* The roles time out after some point. It should be 1 hour. Longer than the token lasts (usually 15 minutes).
* So we could keep the session alive between token refreshes., but it's easier to refresh the session at the same time.
* @return Cred provider chain needed to generate a token.
*/
private AwsCredentialsProviderChain assumeRole() {
try {
AssumeRoleRequest assumeRoleRequest = AssumeRoleRequest.builder()
.roleArn(config.getRoleArn())
.roleSessionName(config.getSessionName())
.build();
AssumeRoleResponse assumeRoleResponse = stsClient.assumeRole(assumeRoleRequest);
Credentials creds = assumeRoleResponse.credentials();
AwsSessionCredentials sessionCredentials = AwsSessionCredentials.create(creds.accessKeyId(), creds.secretAccessKey(), creds.sessionToken());
return AwsCredentialsProviderChain.builder()
.credentialsProviders(StaticCredentialsProvider.create(sessionCredentials))
.build();
} catch (SdkException e) {
log.error("Unable to assume role {} for session {}", config.getRoleArn(), config.getSessionName(), e);
throw new AssumeRoleException(e, config.getRoleArn(), config.getSessionName());
}
}
private URI parseJdbcURL(String jdbcUrl) {
String uri = jdbcUrl.substring(5);
return URI.create(uri);
}
}
"Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Failed to initialize dependency 'liquibase' of LoadTimeWeaverAware bean 'entityManagerFactory': Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: The server requested password-based authentication, but no password was provided by plugin null","exception.stacktrace":"org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Failed to initialize dependency 'liquibase' of LoadTimeWeaverAware bean 'entityManagerFactory': Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: The server requested password-based authentication, but no password was provided by plugin null at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:328) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:970) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439) at org.springframework.boot.SpringApplication.run(SpringApplication.java:318) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1361) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1350) at com.myapp.Application.main(Application.java:14) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64) at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: The server requested password-based authentication, but no password was provided by plugin null at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1826) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ... 17 common frames omitted Caused by: liquibase.exception.LiquibaseException: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: The server requested password-based authentication, but no password was provided by plugin null at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:288) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1873) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1822) ... 24 common frames omitted Caused by: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: The server requested password-based authentication, but no password was provided by plugin null at liquibase.integration.spring.SpringLiquibase.lambda$afterPropertiesSet$0(SpringLiquibase.java:280) at liquibase.Scope.lambda$child$0(Scope.java:201) at liquibase.Scope.child(Scope.java:210) at liquibase.Scope.child(Scope.java:200) at liquibase.Scope.child(Scope.java:179) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:271) ... 26 common frames omitted Caused by: org.postgresql.util.PSQLException: The server requested password-based authentication, but no password was provided by plugin null at org.postgresql.core.v3.AuthenticationPluginManager.lambda$withEncodedPassword$0(AuthenticationPluginManager.java:113) at org.postgresql.core.v3.AuthenticationPluginManager.withPassword(AuthenticationPluginManager.java:82) at org.postgresql.core.v3.AuthenticationPluginManager.withEncodedPassword(AuthenticationPluginManager.java:110) at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:839) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:234) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:289) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:57) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:277) at org.postgresql.Driver.makeConnection(Driver.java:448) at org.postgresql.Driver.connect(Driver.java:298) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:139) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:367) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:205) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:484) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:572) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:101) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:111) at liquibase.integration.spring.SpringLiquibase.lambda$afterPropertiesSet$0(SpringLiquibase.java:275) ... 31 common frames omitted"
Comment From: philwebb
I suspect this is due to https://github.com/brettwooldridge/HikariCP/commit/d43c272f3fc1de89bc4e650d8b936176d7159c12 and out of Spring Boot's control.
I would suggest changing your RdsDataSource class to also override getCredentials() to:
public Credentials getCredentials() {
return Credentials.of(getUsername(), getPassword());
}
Comment From: khamburg-dev
Thanks, implementing getCredentials as suggested solved the problem.
Comment From: milind123
I suspect this is due to brettwooldridge/HikariCP@d43c272 and out of Spring Boot's control.
I would suggest changing your
RdsDataSourceclass to also overridegetCredentials()to:public Credentials getCredentials() { return Credentials.of(getUsername(), getPassword()); }
@philwebb Many thanks for the solution. Awesome!! This issue was stopping us from going to 3.5.x
Comment From: NKWEATU
how do i fix this, having unknowns
"C:\Program Files\Java\jdk-23\bin\java.exe" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2024.1.2\lib\idea_rt.jar=60606:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2024.1.2\bin" -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath "C:\Users\USER\Desktop\spring Apps\databaseTest\databaseTest\target\classes;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot-starter-data-jpa\3.5.3\spring-boot-starter-data-jpa-3.5.3.jar;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot-starter\3.5.3\spring-boot-starter-3.5.3.jar;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot\3.5.3\spring-boot-3.5.3.jar;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\3.5.3\spring-boot-autoconfigure-3.5.3.jar;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot-starter-logging\3.5.3\spring-boot-starter-logging-3.5.3.jar;C:\Users\USER\.m2\repository\ch\qos\logback\logback-classic\1.5.18\logback-classic-1.5.18.jar;C:\Users\USER\.m2\repository\ch\qos\logback\logback-core\1.5.18\logback-core-1.5.18.jar;C:\Users\USER\.m2\repository\org\apache\logging\log4j\log4j-to-slf4j\2.24.3\log4j-to-slf4j-2.24.3.jar;C:\Users\USER\.m2\repository\org\apache\logging\log4j\log4j-api\2.24.3\log4j-api-2.24.3.jar;C:\Users\USER\.m2\repository\org\slf4j\jul-to-slf4j\2.0.17\jul-to-slf4j-2.0.17.jar;C:\Users\USER\.m2\repository\jakarta\annotation\jakarta.annotation-api\2.1.1\jakarta.annotation-api-2.1.1.jar;C:\Users\USER\.m2\repository\org\yaml\snakeyaml\2.4\snakeyaml-2.4.jar;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\3.5.3\spring-boot-starter-jdbc-3.5.3.jar;C:\Users\USER\.m2\repository\com\zaxxer\HikariCP\6.3.0\HikariCP-6.3.0.jar;C:\Users\USER\.m2\repository\org\springframework\spring-jdbc\6.2.8\spring-jdbc-6.2.8.jar;C:\Users\USER\.m2\repository\org\hibernate\orm\hibernate-core\6.6.18.Final\hibernate-core-6.6.18.Final.jar;C:\Users\USER\.m2\repository\jakarta\persistence\jakarta.persistence-api\3.1.0\jakarta.persistence-api-3.1.0.jar;C:\Users\USER\.m2\repository\jakarta\transaction\jakarta.transaction-api\2.0.1\jakarta.transaction-api-2.0.1.jar;C:\Users\USER\.m2\repository\org\jboss\logging\jboss-logging\3.6.1.Final\jboss-logging-3.6.1.Final.jar;C:\Users\USER\.m2\repository\org\hibernate\common\hibernate-commons-annotations\7.0.3.Final\hibernate-commons-annotations-7.0.3.Final.jar;C:\Users\USER\.m2\repository\io\smallrye\jandex\3.2.0\jandex-3.2.0.jar;C:\Users\USER\.m2\repository\com\fasterxml\classmate\1.7.0\classmate-1.7.0.jar;C:\Users\USER\.m2\repository\net\bytebuddy\byte-buddy\1.17.6\byte-buddy-1.17.6.jar;C:\Users\USER\.m2\repository\org\glassfish\jaxb\jaxb-runtime\4.0.5\jaxb-runtime-4.0.5.jar;C:\Users\USER\.m2\repository\org\glassfish\jaxb\jaxb-core\4.0.5\jaxb-core-4.0.5.jar;C:\Users\USER\.m2\repository\org\eclipse\angus\angus-activation\2.0.2\angus-activation-2.0.2.jar;C:\Users\USER\.m2\repository\org\glassfish\jaxb\txw2\4.0.5\txw2-4.0.5.jar;C:\Users\USER\.m2\repository\com\sun\istack\istack-commons-runtime\4.1.2\istack-commons-runtime-4.1.2.jar;C:\Users\USER\.m2\repository\jakarta\inject\jakarta.inject-api\2.0.1\jakarta.inject-api-2.0.1.jar;C:\Users\USER\.m2\repository\org\antlr\antlr4-runtime\4.13.0\antlr4-runtime-4.13.0.jar;C:\Users\USER\.m2\repository\org\springframework\data\spring-data-jpa\3.5.1\spring-data-jpa-3.5.1.jar;C:\Users\USER\.m2\repository\org\springframework\data\spring-data-commons\3.5.1\spring-data-commons-3.5.1.jar;C:\Users\USER\.m2\repository\org\springframework\spring-orm\6.2.8\spring-orm-6.2.8.jar;C:\Users\USER\.m2\repository\org\springframework\spring-context\6.2.8\spring-context-6.2.8.jar;C:\Users\USER\.m2\repository\org\springframework\spring-aop\6.2.8\spring-aop-6.2.8.jar;C:\Users\USER\.m2\repository\org\springframework\spring-tx\6.2.8\spring-tx-6.2.8.jar;C:\Users\USER\.m2\repository\org\springframework\spring-beans\6.2.8\spring-beans-6.2.8.jar;C:\Users\USER\.m2\repository\org\slf4j\slf4j-api\2.0.17\slf4j-api-2.0.17.jar;C:\Users\USER\.m2\repository\org\springframework\spring-aspects\6.2.8\spring-aspects-6.2.8.jar;C:\Users\USER\.m2\repository\org\aspectj\aspectjweaver\1.9.24\aspectjweaver-1.9.24.jar;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot-starter-web\3.5.3\spring-boot-starter-web-3.5.3.jar;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot-starter-json\3.5.3\spring-boot-starter-json-3.5.3.jar;C:\Users\USER\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.19.1\jackson-databind-2.19.1.jar;C:\Users\USER\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.19.1\jackson-annotations-2.19.1.jar;C:\Users\USER\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.19.1\jackson-core-2.19.1.jar;C:\Users\USER\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.19.1\jackson-datatype-jdk8-2.19.1.jar;C:\Users\USER\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.19.1\jackson-datatype-jsr310-2.19.1.jar;C:\Users\USER\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.19.1\jackson-module-parameter-names-2.19.1.jar;C:\Users\USER\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\3.5.3\spring-boot-starter-tomcat-3.5.3.jar;C:\Users\USER\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\10.1.42\tomcat-embed-core-10.1.42.jar;C:\Users\USER\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\10.1.42\tomcat-embed-el-10.1.42.jar;C:\Users\USER\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\10.1.42\tomcat-embed-websocket-10.1.42.jar;C:\Users\USER\.m2\repository\org\springframework\spring-web\6.2.8\spring-web-6.2.8.jar;C:\Users\USER\.m2\repository\io\micrometer\micrometer-observation\1.15.1\micrometer-observation-1.15.1.jar;C:\Users\USER\.m2\repository\io\micrometer\micrometer-commons\1.15.1\micrometer-commons-1.15.1.jar;C:\Users\USER\.m2\repository\org\springframework\spring-webmvc\6.2.8\spring-webmvc-6.2.8.jar;C:\Users\USER\.m2\repository\org\springframework\spring-expression\6.2.8\spring-expression-6.2.8.jar;C:\Users\USER\.m2\repository\com\mysql\mysql-connector-j\9.2.0\mysql-connector-j-9.2.0.jar;C:\Users\USER\.m2\repository\org\projectlombok\lombok\1.18.38\lombok-1.18.38.jar;C:\Users\USER\.m2\repository\jakarta\xml\bind\jakarta.xml.bind-api\4.0.2\jakarta.xml.bind-api-4.0.2.jar;C:\Users\USER\.m2\repository\jakarta\activation\jakarta.activation-api\2.1.3\jakarta.activation-api-2.1.3.jar;C:\Users\USER\.m2\repository\org\springframework\spring-core\6.2.8\spring-core-6.2.8.jar;C:\Users\USER\.m2\repository\org\springframework\spring-jcl\6.2.8\spring-jcl-6.2.8.jar" com.example.databaseTest.DatabaseTestApplication
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.3)
2025-07-23T15:08:28.306+01:00 INFO 1224 --- [databaseTest] [ main] c.e.d.DatabaseTestApplication : Starting DatabaseTestApplication using Java 23.0.2 with PID 1224 (C:\Users\USER\Desktop\spring Apps\databaseTest\databaseTest\target\classes started by USER in C:\Users\USER\Desktop\spring Apps\databaseTest\databaseTest)
2025-07-23T15:08:28.406+01:00 INFO 1224 --- [databaseTest] [ main] c.e.d.DatabaseTestApplication : No active profile set, falling back to 1 default profile: "default"
2025-07-23T15:08:43.451+01:00 INFO 1224 --- [databaseTest] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-07-23T15:08:43.741+01:00 INFO 1224 --- [databaseTest] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 216 ms. Found 0 JPA repository interfaces.
2025-07-23T15:08:50.557+01:00 INFO 1224 --- [databaseTest] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8080 (http)
2025-07-23T15:08:50.626+01:00 INFO 1224 --- [databaseTest] [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2025-07-23T15:08:50.628+01:00 INFO 1224 --- [databaseTest] [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.42]
2025-07-23T15:08:51.042+01:00 INFO 1224 --- [databaseTest] [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2025-07-23T15:08:51.054+01:00 INFO 1224 --- [databaseTest] [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 21114 ms
2025-07-23T15:08:51.723+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : Class com.mysql.cj.jdbc.Driver found in Thread context class loader jdk.internal.loader.ClassLoaders$AppClassLoader@5a07e868
2025-07-23T15:08:53.362+01:00 INFO 1224 --- [databaseTest] [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-07-23T15:08:54.980+01:00 INFO 1224 --- [databaseTest] [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.6.18.Final
2025-07-23T15:08:55.767+01:00 INFO 1224 --- [databaseTest] [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2025-07-23T15:08:59.885+01:00 INFO 1224 --- [databaseTest] [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-07-23T15:09:00.358+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : HikariPool-1 - configuration:
2025-07-23T15:09:00.375+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : allowPoolSuspension.............false
2025-07-23T15:09:00.376+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : autoCommit......................true
2025-07-23T15:09:00.383+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : catalog.........................none
2025-07-23T15:09:00.386+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : connectionInitSql...............none
2025-07-23T15:09:00.388+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : connectionTestQuery.............none
2025-07-23T15:09:00.392+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : connectionTimeout...............30000
2025-07-23T15:09:00.396+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : credentials.....................com.zaxxer.hikari.util.Credentials@27ab206
2025-07-23T15:09:00.404+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : dataSource......................none
2025-07-23T15:09:00.405+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : dataSourceClassName.............none
2025-07-23T15:09:00.406+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : dataSourceJNDI..................none
2025-07-23T15:09:00.410+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : dataSourceProperties............{password=<masked>}
2025-07-23T15:09:00.413+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : driverClassName................."com.mysql.cj.jdbc.Driver"
2025-07-23T15:09:00.414+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : exceptionOverride...............none
2025-07-23T15:09:00.416+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : exceptionOverrideClassName......none
2025-07-23T15:09:00.417+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : healthCheckProperties...........{}
2025-07-23T15:09:00.419+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : healthCheckRegistry.............none
2025-07-23T15:09:00.421+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : idleTimeout.....................600000
2025-07-23T15:09:00.429+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : initializationFailTimeout.......1
2025-07-23T15:09:00.430+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : isolateInternalQueries..........false
2025-07-23T15:09:00.432+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : jdbcUrl.........................jdbc:mysql://localhost:3306/user_management1?useSSL=false&serverTimezone=UTC
2025-07-23T15:09:00.433+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : keepaliveTime...................120000
2025-07-23T15:09:00.434+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : leakDetectionThreshold..........0
2025-07-23T15:09:00.436+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : maxLifetime.....................1800000
2025-07-23T15:09:00.438+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : maximumPoolSize.................10
2025-07-23T15:09:00.440+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : metricRegistry..................none
2025-07-23T15:09:00.442+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : metricsTrackerFactory...........none
2025-07-23T15:09:00.443+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : minimumIdle.....................10
2025-07-23T15:09:00.447+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : password........................<masked>
2025-07-23T15:09:00.464+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : poolName........................"HikariPool-1"
2025-07-23T15:09:00.465+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : readOnly........................false
2025-07-23T15:09:00.467+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : registerMbeans..................false
2025-07-23T15:09:00.468+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : scheduledExecutor...............none
2025-07-23T15:09:00.469+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : schema..........................none
2025-07-23T15:09:00.480+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : threadFactory...................internal
2025-07-23T15:09:00.482+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : transactionIsolation............default
2025-07-23T15:09:00.484+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : username........................"root"
2025-07-23T15:09:00.501+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariConfig : validationTimeout...............5000
2025-07-23T15:09:00.502+01:00 INFO 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2025-07-23T15:09:00.733+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (080a256c-8e9d-4dc0-b8ef-1d433d31547a)
2025-07-23T15:09:01.585+01:00 DEBUG 1224 --- [databaseTest] [ main] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (080a256c-8e9d-4dc0-b8ef-1d433d31547a)
2025-07-23T15:09:01.589+01:00 INFO 1224 --- [databaseTest] [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@796c68bf
2025-07-23T15:09:01.597+01:00 INFO 1224 --- [databaseTest] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2025-07-23T15:09:01.712+01:00 DEBUG 1224 --- [databaseTest] [l-1:housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Pool stats (total=1/10, idle=0/10, active=1, waiting=0)
2025-07-23T15:09:01.714+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (ae232d5a-3150-4cf1-b4a6-65da63d39d65)
2025-07-23T15:09:01.729+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (ae232d5a-3150-4cf1-b4a6-65da63d39d65)
2025-07-23T15:09:01.730+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@70671df2
2025-07-23T15:09:01.773+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=2/10, idle=1/10, active=1, waiting=0)
2025-07-23T15:09:01.774+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (acef92bd-e8f1-4692-964b-aaa99431f12c)
2025-07-23T15:09:01.791+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (acef92bd-e8f1-4692-964b-aaa99431f12c)
2025-07-23T15:09:01.801+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@315a17c9
2025-07-23T15:09:01.836+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=3/10, idle=2/10, active=1, waiting=0)
2025-07-23T15:09:01.838+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (ad0d9d94-03e6-4451-a19d-0a99c5bdd997)
2025-07-23T15:09:01.861+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (ad0d9d94-03e6-4451-a19d-0a99c5bdd997)
2025-07-23T15:09:01.862+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@21039b
2025-07-23T15:09:01.900+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=4/10, idle=3/10, active=1, waiting=0)
2025-07-23T15:09:01.902+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (f6c21527-d340-4529-8535-f5298d2192c6)
2025-07-23T15:09:01.924+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (f6c21527-d340-4529-8535-f5298d2192c6)
2025-07-23T15:09:01.925+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@5175e886
2025-07-23T15:09:01.963+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=5/10, idle=4/10, active=1, waiting=0)
2025-07-23T15:09:01.964+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (7a3c436c-05ae-415c-8cd7-81e5492bf154)
2025-07-23T15:09:01.992+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (7a3c436c-05ae-415c-8cd7-81e5492bf154)
2025-07-23T15:09:01.992+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@191ed7fa
2025-07-23T15:09:02.027+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=6/10, idle=5/10, active=1, waiting=0)
2025-07-23T15:09:02.030+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (79cc1bf9-5be9-4f40-be36-49fecb79e8c8)
2025-07-23T15:09:02.073+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (79cc1bf9-5be9-4f40-be36-49fecb79e8c8)
2025-07-23T15:09:02.074+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@553b5552
2025-07-23T15:09:02.091+01:00 WARN 1224 --- [databaseTest] [ main] org.hibernate.orm.deprecation : HHH90000025: MySQL8Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2025-07-23T15:09:02.095+01:00 WARN 1224 --- [databaseTest] [ main] org.hibernate.orm.deprecation : HHH90000026: MySQL8Dialect has been deprecated; use org.hibernate.dialect.MySQLDialect instead
2025-07-23T15:09:02.107+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=7/10, idle=6/10, active=1, waiting=0)
2025-07-23T15:09:02.110+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (5e63014a-1b2e-41ec-946a-aef813a33000)
2025-07-23T15:09:02.140+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (5e63014a-1b2e-41ec-946a-aef813a33000)
2025-07-23T15:09:02.140+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@728a8664
2025-07-23T15:09:02.186+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=8/10, idle=7/10, active=1, waiting=0)
2025-07-23T15:09:02.188+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (d168d87f-1a2e-4a46-8258-103f2cb33e98)
2025-07-23T15:09:02.211+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (d168d87f-1a2e-4a46-8258-103f2cb33e98)
2025-07-23T15:09:02.212+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@73a5d5fe
2025-07-23T15:09:02.305+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=9/10, idle=8/10, active=1, waiting=0)
2025-07-23T15:09:02.306+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Attempting to create/setup new connection (c192dabd-847b-430d-8fc4-7250780943a1)
2025-07-23T15:09:02.390+01:00 INFO 1224 --- [databaseTest] [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'HikariDataSource (HikariPool-1)']
Database driver: undefined/unknown
Database version: 8.0
Autocommit mode: undefined/unknown
Isolation level: undefined/unknown
Minimum pool size: undefined/unknown
Maximum pool size: undefined/unknown
2025-07-23T15:09:02.446+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Established new connection (c192dabd-847b-430d-8fc4-7250780943a1)
2025-07-23T15:09:02.447+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@695b3b2a
2025-07-23T15:09:02.488+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - After adding stats (total=10/10, idle=10/10, active=0, waiting=0)
2025-07-23T15:09:02.488+01:00 DEBUG 1224 --- [databaseTest] [onnection-adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Connection not added, stats (total=10/10, idle=10/10, active=0, waiting=0)
2025-07-23T15:09:09.230+01:00 INFO 1224 --- [databaseTest] [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2025-07-23T15:09:09.529+01:00 INFO 1224 --- [databaseTest] [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2025-07-23T15:09:09.923+01:00 WARN 1224 --- [databaseTest] [ main] 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-07-23T15:09:16.318+01:00 INFO 1224 --- [databaseTest] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8080 (http) with context path '/'
2025-07-23T15:09:16.419+01:00 INFO 1224 --- [databaseTest] [ main] c.e.d.DatabaseTestApplication : Started DatabaseTestApplication in 53.23 seconds (process running for 59.642)
2025-07-23T15:09:31.776+01:00 DEBUG 1224 --- [databaseTest] [l-1:housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Pool stats (total=10/10, idle=10/10, active=0, waiting=0)
2025-07-23T15:09:31.776+01:00 DEBUG 1224 --- [databaseTest] [l-1:housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Fill pool skipped, pool has sufficient level or currently being filled.
Comment From: philwebb
@NKWEATU that looks like a different issue, I would suggesting asking on stackoverflow.com.