AWS Secrets Manager : Driver不支持提供的URL: jdbc-secretsmanager:postgresql

Question

我正在尝试使用application.properties中的以下配置的aws-secretsmanager-jdbc连接无服务器prostgress

#secrets name
quarkus.datasource.username = rds-db-credentials/postgres-serverless/rw/dbuser
quarkus.datasource.jdbc.url = jdbc-secretsmanager:postgresql://${db.host}:${db.port}/dbname
quarkus.datasource.jdbc.driver=com.amazonaws.secretsmanager.sql.AWSSecretsManagerPostgreSQLDriver

我得到的错误是

Could not obtain connection to query metadata: java.sql.SQLException: Driver does not support the provided URL: jdbc-secretsmanager:postgresql://dburl

我正在尝试通过aws-secretsmanager-jdbc进行连接，我可以通过jdbc使用getting secrets和常规连接进行连接。

Answer 1

为了解决这个问题，我创建了一个读取秘密的bean，下面的代码显示了实现CredentialsProvider的bean

@ApplicationScoped
@Named("app-credentials-provider")
public class AppCredentialsProvider implements CredentialsProvider {
    @Inject
    DBSecretPOJO dbSecretPOJO;
    @Override
    public Map<String, String> getCredentials(String credentialsProviderName) {
        Map<String, String> properties = new HashMap<>();
        properties.put(USER_PROPERTY_NAME, dbSecretPOJO.getUsername());
        properties.put(PASSWORD_PROPERTY_NAME, dbSecretPOJO.getPassword());
        return properties;
    }
}

配置

quarkus.datasource.credentials-provider=custom
quarkus.datasource.credentials-provider-name=app-credentials-provider