将Spring Boot与EBean和HikariCP连接池集成

Question

EBean是一个无状态的ORM。http://ebean-orm.github.io/

EBean提供了一个Spring Boot工件http://ebean-orm.github.io/docs/setup/spring#spring-boothttps://github.com/ebean-orm/avaje-ebeanorm-spring

但在这种情况下，EBean直接读取jdbc连接细节，如下所示。

ebean.db.ddl.generate=true
ebean.db.ddl.run=true

datasource.db.username=sa
datasource.db.password=
datasource.db.databaseUrl=jdbc:h2:mem:tests
datasource.db.databaseDriver=org.h2.Driver

我想利用我现有的HikariCP DataSource与Spring Boot和EBean。

我们怎么做？

Answer 1

我正在这样做，现在可以正常工作。

1.应用。性质

# hikariCP
spring.datasource.type=com.zaxxer.HikariDataSource
spring.datasource.driver-class-name=@datasource.db.databaseDriver@
spring.datasource.url=@datasource.db.databaseUrl@
spring.datasource.username=@datasource.db.username@
spring.datasource.password=@datasource.db.password@
spring.datasource.poolName=SpringBootHikariCP
spring.datasource.maximumPoolSize=60
spring.datasource.minimumIdle=3
spring.datasource.maxLifetime=2000000
spring.datasource.connectionTimeout=30000
spring.datasource.idleTimeout=30000
spring.datasource.pool-prepared-statements=true
spring.datasource.max-open-prepared-statements=250

Hikari配置

@Configuration
@Component
class DataSourceConfig {

@Value("${spring.datasource.username}")
private String user;

@Value("${spring.datasource.password}")
private String password;

@Value("${spring.datasource.url}")
private String dataSourceUrl;

@Value("${spring.datasource.poolName}")
private String poolName;

@Value("${spring.datasource.connectionTimeout}")
private int connectionTimeout;

@Value("${spring.datasource.maxLifetime}")
private int maxLifetime;

@Value("${spring.datasource.maximumPoolSize}")
private int maximumPoolSize;

@Value("${spring.datasource.minimumIdle}")
private int minimumIdle;
@Value("${spring.datasource.idleTimeout}")
private int idleTimeout;
public DataSource primaryDataSource() {

    HikariConfig config = new HikariConfig();
    config.setPoolName(poolName);
    config.setJdbcUrl(dataSourceUrl);
    config.setUsername(user);
    config.setPassword(password);
    config.setConnectionTimeout(connectionTimeout);
    config.setMinimumIdle(minimumIdle);
    config.setIdleTimeout(idleTimeout);
    config.setMaximumPoolSize(maximumPoolSize);
    config.setMaxLifetime(idleTimeout);
    config.addDataSourceProperty("cachePrepStmts", "true");
    config.addDataSourceProperty("prepStmtCacheSize", "250");
    config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");

    HikariDataSource ds = new HikariDataSource(config);
    return ds;
}

}

埃宾

 @Component
 public class EbeanFactoryBean implements FactoryBean<EbeanServer>, EnvironmentAware {

@Autowired
CurrentUserProv currentUser;


@Autowired
DataSourceConfig dataSourceConfig;


/**
 * Properties used to configure EbeanServer instance
 * (loaded from spring boot application properties).
 */
Properties properties = new Properties();

public EbeanFactoryBean() {
}

@Override
public EbeanServer getObject() throws Exception {

    ServerConfig config = new ServerConfig();
    config.setName("db");
    config.setCurrentUserProvider(currentUser);
    config.setDataSource(dataSourceConfig.primaryDataSource());
    config.setDefaultServer(true);
    config.setRegister(true);
    return EbeanServerFactory.create(config);
}

@Override
public Class<?> getObjectType() {
    return EbeanServer.class;
}

@Override
public boolean isSingleton() {
    return true;
}

@Override
public void setEnvironment(Environment environment) {

    loadProperties((AbstractEnvironment) environment);
}


/**
 * Load into Properties (from Spring PropertySource implementations).
 */
private void loadProperties(AbstractEnvironment environment) {

    MutablePropertySources propertySources = environment.getPropertySources();

    // reverse the order of the property sources
    List<MapPropertySource> props = new ArrayList<>();
    for (PropertySource propertySource : propertySources) {
        if (propertySource instanceof MapPropertySource) {
            props.add(0, (MapPropertySource) propertySource);
        }
    }
    // merge them into the single Properties
    for (MapPropertySource propertySource : props) {
        properties.putAll(propertySource.getSource());
    }
}

}

Answer 2

您可以在此处查看一个Spring Boot示例：

https://github.com/bwajtr/java-persistence-frameworks-comparison

在该存储库中有SpringBoot配置：https://github.com/bwajtr/java-persistence-frameworks-comparison/blob/master/src/main/java/com/clevergang/dbtests/DbTestsApplication.java

在该类中，您可以看到EBean是如何配置的，以及数据源是如何连接到其中的-