Hubspot_webhook_oauth_step6_1_build.kts

dependencies {
  // ...
  implementation("org.springframework.boot:spring-boot-starter-jdbc")
	implementation("org.flywaydb:flyway-core") // Optional, but highly recommended
	implementation("org.postgresql:postgresql") // Add the driver for your favourite database here
}

Hubspot_webhook_oauth_step6_2_application.yml

  spring:
    # ...
    datasource:
      url: jdbc:postgresql://localhost:5432/demo-app-oauth2-webhooks
      username: stefano
      password: 

Hubspot_webhook_oauth_step6_3_spring_migration.sql

; -- src/main/resources/db/migration/V1__Add_oauth2_authorized_client_table.sql

CREATE TABLE oauth2_authorized_client
(
  client_registration_id  varchar(100)                            NOT NULL,
  principal_name          varchar(200)                            NOT NULL,
  access_token_type       varchar(100)                            NOT NULL,
  access_token_value      bytea                                   NOT NULL,
  access_token_issued_at  timestamp                               NOT NULL,
  access_token_expires_at timestamp                               NOT NULL,
  access_token_scopes     varchar(1000) DEFAULT NULL,
  refresh_token_value     bytea         DEFAULT NULL,
  refresh_token_issued_at timestamp     DEFAULT NULL,
  created_at              timestamp     DEFAULT CURRENT_TIMESTAMP NOT NULL,
  PRIMARY KEY (client_registration_id, principal_name)
);

Hubspot_webhook_oauth_step6_4_web_security_config.kt

@Configuration
class WebSecurityConfig {
  // ...
  
  @Bean
  fun authorizedClientService(
    jdbcOperations: JdbcOperations,
    clientRegistrationRepository: ClientRegistrationRepository,
  ): OAuth2AuthorizedClientService =
    JdbcOAuth2AuthorizedClientService(jdbcOperations, clientRegistrationRepository)
    
  // ...
}