springboot 配置Greenplum数据源连接

最新推荐文章于 2022-11-03 10:06:37 发布

Deschampszzzz

最新推荐文章于 2022-11-03 10:06:37 发布

阅读量2.3k

点赞数 2

文章标签： spring boot jdbc 数据库

本文链接：https://blog.csdn.net/Deschampszzzz/article/details/118217413

版权

Greenplum引用maven

<dependency>
   <groupId>com.pivotal</groupId>
   <artifactId>greenplum-jdbc</artifactId>
   <version>5.1.4</version>
</dependency>

Greenplum驱动阿里镜像上没有需要Maven中央仓库自行下载Greenplum-jdbc，富人可以支持一下，我上传到CSDN了
如果不能自动导入的可以手动将本地Jar导入maven库

mvn install:install-file -Dfile=(jar包的位置) -DgroupId=groupId(分组) -DartifactId=artifactId(jar名称) -Dversion=version(版本号) -Dpackaging=jar

jar包位置(当前jar路径)：/lib/greenplum-jdbc-5.1.4.jar
groupId(分组)：com.pivotal
artifactId(jar名称): greenplum-jdbc
version(版本号)：5.1.4

yml配置文件

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.pivotal.jdbc.GreenplumDriver
    url: jdbc:pivotal:greenplum://your Ip:your port;DatabaseName=dbname(ip port dbname 根据自己实际填写)
    username: your name(你的)
    password: your password(你的)
    druid:
      initial-size: 5
      min-idle: 5
      max-active: 20
      max-wait: 30000
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      validation-query: select version()
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      pool-prepared-statements: true
      max-open-prepared-statements: 20
      max-pool-prepared-statement-per-connection-size: 20

加载配置文件信息 DatasourceConfig

@Configuration
public class DatasourceConfig {
    @Bean(name = "Datasource")
    @ConfigurationProperties(prefix = "spring.datasource")
    @Primary
    public DataSource dataSource() {
        return DataSourceBuilder.create().build();
    }
}

值得注意 返回Datasource 需要用DataSourceBuilder.create().build();
不能用DruidDataSourceBuilder.create().build();，Druid还没有jdbc:pivotal:greenplum的解析。

最后可以注册jdbcTemplate的Bean

或者配置MybatisConfig

// JdbcTemplate
@Bean(name = "greenplumJdbcTemplate")
  public JdbcTemplate greenplumJdbcTemplate(@Qualifier("Datasource") DataSource dataSource) {
    return new JdbcTemplate(dataSource);
  }

// Mybatis
@Configuration
@MapperScan(basePackages = {"com.demo.**.mapper"}, sqlSessionFactoryRef = "gpSessionFactoryBean")
public class MybatisConfig {
  @Autowired
  @Qualifier("Datasource")
  private DataSource datasource;

  @Bean(name = "gpSessionFactoryBean")
  public SqlSessionFactoryBean gpSessionFactoryBean() {
    SqlSessionFactoryBean gpSessionFactoryBean= new SqlSessionFactoryBean();
    gpSessionFactoryBean.setDataSource(datasource);
    PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
    gpSessionFactoryBean.setMapperLocations(resolver.getResources("classpath:/mybatis/*.xml"));
    return gpSessionFactoryBean;
  }
}