在Heroku Postgres的Micronaut + Hibernate中以编程方式设置DataSource

implementation "io.micronaut:micronaut-data-hibernate-jpa"
implementation "io.micronaut.sql:micronaut-jdbc-hikari"
implementation "io.micronaut.configuration:micronaut-hibernate-jpa"
runtimeOnly "org.postgresql:postgresql"

datasources:
  default:
    url: jdbc:postgresql://<host>:<port>/<database>
    username: <username>
    password: <password>
    driverClassName: org.postgresql.Driver

import io.micronaut.context.annotation.Bean;
import io.micronaut.context.annotation.Factory;
import io.micronaut.context.annotation.Value;
import io.micronaut.jdbc.DataSourceResolver;
import io.micronaut.jdbc.metadata.DataSourcePoolMetadataResolver;
import io.micronaut.runtime.ApplicationConfiguration;

import javax.inject.Singleton;
import javax.sql.DataSource;

@Factory
public class DataSourceFactory {

    @Bean
    @Singleton
    public DataSource dataSource(
            @Value("${datasources.default.url}") String url,
            @Value("${datasources.default.username}") String username,
            @Value("${datasources.default.password}") String password,
            DataSourceResolver dataSourceResolver,
            DataSourcePoolMetadataResolver dataSourcePoolMetadataResolver,
            ApplicationConfiguration applicationConfiguration) {

        return dataSourceResolver.resolve(
                applicationConfiguration,
                dataSourcePoolMetadataResolver,
                "default",
                url,
                username,
                password
        );
    }
}

jpa:
  default:
    entity-scan:
      packages: com.example.entities
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
        hbm2ddl:
          auto: update