Hakari Pool - Failed to initialize pool: ConnectionStringHostListProvider does not support identifyConnection

[aleruz-dt]

Describe the bug

While upgrading the library from 2.5.4 to 2.5.5, I got the following error:
com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: ConnectionStringHostListProvider does not support identifyConnection

Hikari is in the latest version https://mvnrepository.com/artifact/com.zaxxer/HikariCP/6.2.1

Expected Behavior

The driver works as before with Hikari.

What plugins are used? What other connection properties were set?

default settings

Current Behavior

java.lang.UnsupportedOperationException: ConnectionStringHostListProvider does not support identifyConnection. at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.hostlistprovider.ConnectionStringHostListProvider.identifyConnection(ConnectionStringHostListProvider.java:119) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.PluginServiceImpl.identifyConnection(PluginServiceImpl.java:723) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.PluginServiceImpl.fillAliases(PluginServiceImpl.java:752) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.plugin.AuroraConnectionTrackerPlugin.connect(AuroraConnectionTrackerPlugin.java:101) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.ConnectionPluginManager.lambda$connect$6(ConnectionPluginManager.java:390) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.ConnectionPluginManager.lambda$null$3(ConnectionPluginManager.java:278) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.ConnectionPluginManager.executeWithTelemetry(ConnectionPluginManager.java:246) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.ConnectionPluginManager.lambda$makePluginChainFunc$4(ConnectionPluginManager.java:277) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.ConnectionPluginManager.executeWithSubscribedPlugins(ConnectionPluginManager.java:236) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.ConnectionPluginManager.connect(ConnectionPluginManager.java:387) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.wrapper.ConnectionWrapper.init(ConnectionWrapper.java:161) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.wrapper.ConnectionWrapper.<init>(ConnectionWrapper.java:105) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.ds.AwsWrapperDataSource.createConnectionWrapper(AwsWrapperDataSource.java:255) at aws.advanced.jdbc.wrapper@2.5.5/software.amazon.jdbc.ds.AwsWrapperDataSource.getConnection(AwsWrapperDataSource.java:210) at com.zaxxer.hikari@6.2.1/com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:367) at com.zaxxer.hikari@6.2.1/com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:205) at com.zaxxer.hikari@6.2.1/com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:484) at com.zaxxer.hikari@6.2.1/com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:572) at com.zaxxer.hikari@6.2.1/com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:101) at com.zaxxer.hikari@6.2.1/com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:111)

Reproduction Steps

DataSourceClassname: software.amazon.jdbc.ds.AwsWrapperDataSource
DataSourceProperties: targetDataSourceClassName:org.postgresql.ds.PGSimpleDataSource

Possible Solution

No response

Additional Information/Context

No response

The AWS Advanced JDBC Driver version used

2.5.5

JDK version used

openjdk version "21.0.2" 2024-01-16 LTS OpenJDK Runtime Environment Temurin-21.0.2+13 (build 21.0.2+13-LTS) OpenJDK 64-Bit Server VM Temurin-21.0.2+13 (build 21.0.2+13-LTS, mixed mode)

Operating System and version

mac / linux

[sergiyvamz]

Hi @aleruz-dt

Thank you for reaching out with this issue. Could you please provide driver logs? This will help troubleshoot the issue. For reference: https://github.com/aws/aws-advanced-jdbc-wrapper/blob/main/docs/using-the-jdbc-driver/UsingTheJdbcDriver.md#logging

Also, to clarify, are you only seeing this issue with the 2.5.5 driver and Hikari 6.2.1? e.g., Does Wrapper 2.5.4 work correctly with Hikari 6.2.1?

From what I can see from the provided exception, the driver hasn't identified the database dialect properly. As a quick remedy for the issue, I can suggest to add an additional configuration parameter wrapperDialect=auroa-pg. For reference: https://github.com/aws/aws-advanced-jdbc-wrapper/blob/main/docs/using-the-jdbc-driver/DatabaseDialects.md

[Kennelly57]

I am also seeing this issue using Dropwizard + Hibernate and an underlying Tomcat pool, so it seems not limited to only Hikari.

I can confirm that 2.5.4 works, and 2.5.5 does not work. Setting the wrapperDialect also does not fix the problem. Attaching trace level logs.

TRACE [2025-03-07 20:24:23,593] software.amazon.jdbc.Driver: Opening connection to jdbc:aws-wrapper:postgresql://localhost:5432/dev-db
TRACE [2025-03-07 20:24:23,596] software.amazon.jdbc.Driver: Connecting with properties: 
[hibernate.hbm2ddl.auto] update
[hibernate.type.preferred_instant_jdbc_type] timestamp
[wrapperDialect] pg
[hibernate.dialect] com.xyz.util.db.aws.AwsCompliantPostgresDialect
[hibernate.type.preferred_duration_jdbc_type] bigint
[org.hibernate.envers.revision_field_name] revision
[database] dev-db
[password] ***
[org.hibernate.envers.store_data_at_delete] true
[wrapperDriverName] PostgreSQL JDBC Driver
[wrapperPlugins] auroraConnectionTracker,failover2,efm2,driverMetaData
[connectTimeout] 10000
[socketTimeout] 5000
[org.hibernate.envers.audit_strategy_validity_revend_timestamp_field_name] revisionendtimestamp
[org.hibernate.envers.audit_strategy_validity_end_rev_field_name] revisionend
[loginTimeout] 10000
[autoCommit] false
[charSet] UTF-8
[org.hibernate.envers.audit_strategy_validity_store_revend_timestamp] true
[hibernate.id.db_structure_naming_strategy] legacy
[org.hibernate.envers.audit_strategy] org.hibernate.envers.strategy.ValidityAuditStrategy
[org.hibernate.envers.audit_table_suffix] _history
[failoverTimeoutMs] 180000
[wrapperTargetDriverDialect] pgjdbc
[user] postgres
[org.hibernate.envers.revision_type_field_name] revisiontype
TRACE [2025-03-07 20:24:23,605] software.amazon.jdbc.targetdriverdialect.TargetDriverDialectManager: Target driver dialect set to: 'pgjdbc', software.amazon.jdbc.targetdriverdialect.PgTargetDriverDialect@566fe83c.
TRACE [2025-03-07 20:24:23,615] software.amazon.jdbc.dialect.DialectManager: Current dialect: pg, software.amazon.jdbc.dialect.PgDialect@3b8507df, canUpdate: false
TRACE [2025-03-07 20:24:23,618] software.amazon.jdbc.ConnectionPluginChainBuilder: Plugins order has been rearranged. The following order is in effect: DriverMetaDataConnectionPluginFactory, AuroraConnectionTrackerPluginFactory, FailoverConnectionPluginFactory, HostMonitoringConnectionPluginFactory
DEBUG [2025-03-07 20:24:23,632] software.amazon.jdbc.plugin.failover2.FailoverConnectionPlugin: failoverMode=STRICT_WRITER
TRACE [2025-03-07 20:24:23,633] software.amazon.jdbc.DriverConnectionProvider: Connecting to jdbc:postgresql://localhost:5432/dev-db
with properties: 
[charSet] UTF-8
[org.hibernate.envers.audit_strategy_validity_store_revend_timestamp] true
[hibernate.hbm2ddl.auto] update
[hibernate.type.preferred_instant_jdbc_type] timestamp
[hibernate.id.db_structure_naming_strategy] legacy
[hibernate.dialect] com.xyz.util.db.aws.AwsCompliantPostgresDialect
[tcpKeepAlive] false
[hibernate.type.preferred_duration_jdbc_type] bigint
[org.hibernate.envers.revision_field_name] revision
[org.hibernate.envers.audit_strategy] org.hibernate.envers.strategy.ValidityAuditStrategy
[org.hibernate.envers.audit_table_suffix] _history
[password] ***
[org.hibernate.envers.store_data_at_delete] true
[connectTimeout] 10
[socketTimeout] 5
[org.hibernate.envers.audit_strategy_validity_revend_timestamp_field_name] revisionendtimestamp
[org.hibernate.envers.audit_strategy_validity_end_rev_field_name] revisionend
[loginTimeout] 10
[autoCommit] false
[user] postgres
[org.hibernate.envers.revision_type_field_name] revisiontype
TRACE [2025-03-07 20:24:23,679] software.amazon.jdbc.dialect.DialectManager: Current dialect: pg, software.amazon.jdbc.dialect.PgDialect@3b8507df, canUpdate: false
ERROR [2025-03-07 20:24:23,686] org.apache.tomcat.jdbc.pool.ConnectionPool: Unable to create initial connections of pool.
! java.lang.UnsupportedOperationException: ConnectionStringHostListProvider does not support identifyConnection.
! at software.amazon.jdbc.hostlistprovider.ConnectionStringHostListProvider.identifyConnection(ConnectionStringHostListProvider.java:119)
! at software.amazon.jdbc.PluginServiceImpl.identifyConnection(PluginServiceImpl.java:723)
! at software.amazon.jdbc.PluginServiceImpl.fillAliases(PluginServiceImpl.java:752)
! at software.amazon.jdbc.plugin.AuroraConnectionTrackerPlugin.connect(AuroraConnectionTrackerPlugin.java:101)
! at software.amazon.jdbc.ConnectionPluginManager.lambda$connect$6(ConnectionPluginManager.java:390)
! at software.amazon.jdbc.ConnectionPluginManager.lambda$null$3(ConnectionPluginManager.java:278)
! at software.amazon.jdbc.ConnectionPluginManager.executeWithTelemetry(ConnectionPluginManager.java:246)
! at software.amazon.jdbc.ConnectionPluginManager.lambda$makePluginChainFunc$4(ConnectionPluginManager.java:277)
! at software.amazon.jdbc.ConnectionPluginManager.executeWithSubscribedPlugins(ConnectionPluginManager.java:236)
! at software.amazon.jdbc.ConnectionPluginManager.connect(ConnectionPluginManager.java:387)
! at software.amazon.jdbc.wrapper.ConnectionWrapper.init(ConnectionWrapper.java:161)
! at software.amazon.jdbc.wrapper.ConnectionWrapper.<init>(ConnectionWrapper.java:105)
! at software.amazon.jdbc.Driver.connect(Driver.java:219)
! at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:346)
! ... 36 common frames omitted
! Causing: java.sql.SQLException: ConnectionStringHostListProvider does not support identifyConnection.
! at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:359)
! at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:227)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:779)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:707)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:506)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:155)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
! at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:126)
! at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:467)
! at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:61)
! at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:320)
! at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:129)
! at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:81)
! at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:130)
! at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
! at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238)
! at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215)
! at org.hibernate.boot.model.relational.Database.<init>(Database.java:45)
! at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:226)
! at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:194)
! at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:171)
! at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:129)
! at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:449)
! at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:101)
! at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:949)
! at io.dropwizard.hibernate.SessionFactoryFactory.buildSessionFactory(SessionFactoryFactory.java:103)
! at io.dropwizard.hibernate.SessionFactoryFactory.build(SessionFactoryFactory.java:52)
! at io.dropwizard.hibernate.SessionFactoryFactory.build(SessionFactoryFactory.java:42)
! at io.dropwizard.hibernate.HibernateBundle.run(HibernateBundle.java:73)
! at io.dropwizard.core.setup.Bootstrap.run(Bootstrap.java:199)
! at io.dropwizard.core.cli.EnvironmentCommand.run(EnvironmentCommand.java:65)
! at io.dropwizard.core.cli.ConfiguredCommand.run(ConfiguredCommand.java:98)
! at io.dropwizard.core.cli.Cli.run(Cli.java:78)
! at io.dropwizard.core.Application.run(Application.java:94)
! at com.sage.admin.server.AdminServiceApplication.main(AdminServiceApplication.java:267)
WARN  [2025-03-07 20:24:23,688] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 0, SQLState: null
ERROR [2025-03-07 20:24:23,688] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: ConnectionStringHostListProvider does not support identifyConnection.
WARN  [2025-03-07 20:24:23,688] org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator: HHH000342: Could not obtain connection to query metadata
! java.lang.UnsupportedOperationException: ConnectionStringHostListProvider does not support identifyConnection.
! at software.amazon.jdbc.hostlistprovider.ConnectionStringHostListProvider.identifyConnection(ConnectionStringHostListProvider.java:119)
! at software.amazon.jdbc.PluginServiceImpl.identifyConnection(PluginServiceImpl.java:723)
! at software.amazon.jdbc.PluginServiceImpl.fillAliases(PluginServiceImpl.java:752)
! at software.amazon.jdbc.plugin.AuroraConnectionTrackerPlugin.connect(AuroraConnectionTrackerPlugin.java:101)
! at software.amazon.jdbc.ConnectionPluginManager.lambda$connect$6(ConnectionPluginManager.java:390)
! at software.amazon.jdbc.ConnectionPluginManager.lambda$null$3(ConnectionPluginManager.java:278)
! at software.amazon.jdbc.ConnectionPluginManager.executeWithTelemetry(ConnectionPluginManager.java:246)
! at software.amazon.jdbc.ConnectionPluginManager.lambda$makePluginChainFunc$4(ConnectionPluginManager.java:277)
! at software.amazon.jdbc.ConnectionPluginManager.executeWithSubscribedPlugins(ConnectionPluginManager.java:236)
! at software.amazon.jdbc.ConnectionPluginManager.connect(ConnectionPluginManager.java:387)
! at software.amazon.jdbc.wrapper.ConnectionWrapper.init(ConnectionWrapper.java:161)
! at software.amazon.jdbc.wrapper.ConnectionWrapper.<init>(ConnectionWrapper.java:105)
! at software.amazon.jdbc.Driver.connect(Driver.java:219)
! at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:346)
! ... 36 common frames omitted
! Causing: java.sql.SQLException: ConnectionStringHostListProvider does not support identifyConnection.
! at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:359)
! at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:227)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:779)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:707)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:506)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:155)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
! at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:126)
! at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:467)
! at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:61)
! ... 25 common frames omitted
! Causing: org.hibernate.exception.GenericJDBCException: unable to obtain isolated JDBC connection [ConnectionStringHostListProvider does not support identifyConnection.] [n/a]
! at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:63)
! at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
! at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:94)
! at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:116)
! at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:320)
! at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:129)
! at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:81)
! at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:130)
! at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
! at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238)
! at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215)
! at org.hibernate.boot.model.relational.Database.<init>(Database.java:45)
! at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:226)
! at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:194)
! at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:171)
! at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:129)
! at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:449)
! at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:101)
! at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:949)
! at io.dropwizard.hibernate.SessionFactoryFactory.buildSessionFactory(SessionFactoryFactory.java:103)
! at io.dropwizard.hibernate.SessionFactoryFactory.build(SessionFactoryFactory.java:52)
! at io.dropwizard.hibernate.SessionFactoryFactory.build(SessionFactoryFactory.java:42)
! at io.dropwizard.hibernate.HibernateBundle.run(HibernateBundle.java:73)
! at io.dropwizard.core.setup.Bootstrap.run(Bootstrap.java:199)
! at io.dropwizard.core.cli.EnvironmentCommand.run(EnvironmentCommand.java:65)
! at io.dropwizard.core.cli.ConfiguredCommand.run(ConfiguredCommand.java:98)
! at io.dropwizard.core.cli.Cli.run(Cli.java:78)
! at io.dropwizard.core.Application.run(Application.java:94)
! at com.sage.admin.server.AdminServiceApplication.main(AdminServiceApplication.java:267)

[amasson88]

Same issue from standalone DB migration app, using local Postgres (testcontainer).
Was working in 2.5.4.

java.lang.UnsupportedOperationException: ConnectionStringHostListProvider does not support identifyConnection.
	at software.amazon.jdbc.hostlistprovider.ConnectionStringHostListProvider.identifyConnection(ConnectionStringHostListProvider.java:119)
	at software.amazon.jdbc.PluginServiceImpl.identifyConnection(PluginServiceImpl.java:723)
	at software.amazon.jdbc.PluginServiceImpl.fillAliases(PluginServiceImpl.java:752)
	at software.amazon.jdbc.plugin.AuroraConnectionTrackerPlugin.connect(AuroraConnectionTrackerPlugin.java:101)
	at software.amazon.jdbc.ConnectionPluginManager.lambda$connect$6(ConnectionPluginManager.java:390)
	at software.amazon.jdbc.ConnectionPluginManager.lambda$null$3(ConnectionPluginManager.java:278)
	at software.amazon.jdbc.ConnectionPluginManager.executeWithTelemetry(ConnectionPluginManager.java:246)
	at software.amazon.jdbc.ConnectionPluginManager.lambda$makePluginChainFunc$4(ConnectionPluginManager.java:277)
	at software.amazon.jdbc.ConnectionPluginManager.executeWithSubscribedPlugins(ConnectionPluginManager.java:236)
	at software.amazon.jdbc.ConnectionPluginManager.connect(ConnectionPluginManager.java:387)
	at software.amazon.jdbc.wrapper.ConnectionWrapper.init(ConnectionWrapper.java:161)
	at software.amazon.jdbc.wrapper.ConnectionWrapper.<init>(ConnectionWrapper.java:105)
	at software.amazon.jdbc.Driver.connect(Driver.java:219)
	at software.amazon.jdbc.DriverConnectionProvider.connect(DriverConnectionProvider.java:138)
	at software.amazon.jdbc.plugin.DefaultConnectionPlugin.connectInternal(DefaultConnectionPlugin.java:195)
	at software.amazon.jdbc.plugin.DefaultConnectionPlugin.connect(DefaultConnectionPlugin.java:178)
	at software.amazon.jdbc.ConnectionPluginManager.lambda$connect$6(ConnectionPluginManager.java:390)
	at software.amazon.jdbc.ConnectionPluginManager.lambda$null$0(ConnectionPluginManager.java:270)
	at software.amazon.jdbc.ConnectionPluginManager.executeWithTelemetry(ConnectionPluginManager.java:246)
	at software.amazon.jdbc.ConnectionPluginManager.lambda$makePluginChainFunc$1(ConnectionPluginManager.java:270)
	at software.amazon.jdbc.ConnectionPluginManager.executeWithSubscribedPlugins(ConnectionPluginManager.java:236)
	at software.amazon.jdbc.ConnectionPluginManager.connect(ConnectionPluginManager.java:387)
	at software.amazon.jdbc.wrapper.ConnectionWrapper.init(ConnectionWrapper.java:161)
	at software.amazon.jdbc.wrapper.ConnectionWrapper.<init>(ConnectionWrapper.java:105)
	at software.amazon.jdbc.ds.AwsWrapperDataSource.createConnectionWrapper(AwsWrapperDataSource.java:255)
	at software.amazon.jdbc.ds.AwsWrapperDataSource.getConnection(AwsWrapperDataSource.java:229)
	at software.amazon.jdbc.ds.AwsWrapperDataSource.getConnection(AwsWrapperDataSource.java:95)
....

[aleruz-dt]

@sergiyvamz worked with exact same configuration with 2.5.4, broke when renovate bot updated the version.

[monosoul]

Looking at the call chain, I guess it's this change to blame: 85e1b3c#diff-6a324c434d1b42882f5bd3191705a27875305f4adedac858cc98a0bf15277c6fR96-R99

It causes a call to software.amazon.jdbc.PluginServiceImpl#identifyConnection, which in turn calls software.amazon.jdbc.hostlistprovider.ConnectionStringHostListProvider#identifyConnection that throws an exception as it's not implemented.

[sergiyvamz]

Hi @aleruz-dt , @Kennelly57 , @monosoul , @amasson88

Could you please verify if the latest changes address the issue for you? You can find the latest change in the snapshot build. More information on how to use the snapshot build is available here.
https://github.com/aws/aws-advanced-jdbc-wrapper/blob/main/docs/using-the-jdbc-driver/UsingTheJdbcDriver.md#using-a-snapshot-of-the-driver

Thank you!

[aleruz-dt]

@sergiyvamz tried, and that works as before 🎉

[amasson88]

@sergiyvamz I confirm it works for me too, with aws-advanced-jdbc-wrapper-2.5.6-20250311.161643-6.jar 👍