Archive

Posts Tagged ‘spring’

Spring Data JPA with multiple datasource


Requisition

  • Spring Boot 1.5.11.RELEASE
  • Spring Data JPA 1.11.11.RELEASE
  • Hibernate 5.3.5.Final
  • Postgres 9.4

When using Spring Data JPA together with Spring Boot. It’s easily to realize that Spring Boot JDBC help to initialize one primary data source.

But in reality, one application usually need more than one data source. Especially with legacy systems, this kind of system is usually a centralized of all business logic implementations from customer. For instance,  We consider following scenario:

spring-data-jpa-multiple-datasource

Management System  connects to both Office department database and  People department

The following steps are sufficient for you to connect to one additional data source:

Exclude the default initalized data source from Spring Boot JDBC

@SpringBootApplication(exclude = { DataSourceAutoConfiguration.class })
public class Application {

    public static void main(String[] args) {
        SpringApplication
            .run(Application.class, args);
    }
}

Configure data source Office

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(entityManagerFactoryRef = "officeEntityManagerFactory", transactionManagerRef = "officeTransactionManager", basePackageClasses = {
    DeviceRepository.class })
public class OfficeDataSourceConfiguration {

    @Bean(name = "officeEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean entityManagerFactory(
        final EntityManagerFactoryBuilder builder,
        @Qualifier("officeDataSource") final DataSource dataSource) {
        return builder.dataSource(dataSource).packages(Device.class)
            .persistenceUnit("office").build();
    }

    @Bean(name = "officeDataSource")
    @ConfigurationProperties(prefix = "datasource.office")
    public DataSource dataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "officeTransactionManager")
    public PlatformTransactionManager transactionManager(
        @Qualifier("officeEntityManagerFactory") final EntityManagerFactory entityManagerFactory) {
        return new JpaTransactionManager(entityManagerFactory);
    }
}

Configure data source People

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(entityManagerFactoryRef = "peopleEntityManagerFactory", transactionManagerRef = "peopleTransactionManager", basePackageClasses = {
    DepartmentRepository.class })
public class PeopleDataSourceConfiguration {

    @Primary
    @Bean(name = "peopleEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean entityManagerFactory(
        final EntityManagerFactoryBuilder builder,
        @Qualifier("peopleDataSource") final DataSource dataSource) {
        return builder.dataSource(dataSource).packages(Department.class)
            .persistenceUnit("people").build();
    }

    @Primary
    @Bean(name = "peopleDataSource")
    @ConfigurationProperties(prefix = "datasource.people")
    public DataSource dataSource() {
        return DataSourceBuilder.create().build();
    }

    @Primary
    @Bean(name = "peopleTransactionManager")
    public PlatformTransactionManager peopleTransactionManager(
        @Qualifier("peopleEntityManagerFactory") final EntityManagerFactory entityManagerFactory) {
        return new JpaTransactionManager(entityManagerFactory);
    }
}

Update configuration in application.yml

spring:
    application:
        name: spring-data-jpa-multiple-datasource
    profiles:
        active: default
    data.jpa.repositories.enabled: true
    jpa:
        database-platform: POSTGRESQL
        generate-ddl: true
        open-in-view: true
        show-sql: false
        hibernate.ddl-auto: update
        properties:
            hibernate:
                dialect: org.hibernate.dialect.PostgreSQL94Dialect
                default_schema: production

datasource:
    people:
        driverClassName: org.postgresql.Driver
        url: jdbc:postgresql://10.10.15.171:5432/people?currentSchema=production
        username: postgres
        password: postgres
        type: org.apache.tomcat.jdbc.pool.DataSource
        jmx-enabled: true
        initialSize: 2
        maxActive: 100
        maxIdle: 5
        minIdle: 2
        maxWait: 600000
        testOnBorrow: true
        validationQuery: select 1
        minEvictableIdleTimeMillis: 60000
        removeAbandoned: true
        removeAbandonedTimeout: 60000
        testWhileIdle: true
        timeBetweenEvictionRunsMillis: 60000

    office:
        driverClassName: org.postgresql.Driver
        url: jdbc:postgresql://10.10.15.171:5432/office?currentSchema=production
        username: postgres
        password: postgres
        type: org.apache.tomcat.jdbc.pool.DataSource
        jmx-enabled: true
        initialSize: 2
        maxActive: 100
        maxIdle: 5
        minIdle: 2
        maxWait: 600000
        testOnBorrow: true
        validationQuery: select 1
        minEvictableIdleTimeMillis: 60000
        removeAbandoned: true
        removeAbandonedTimeout: 60000
        testWhileIdle: true
        timeBetweenEvictionRunsMillis: 60000

Source code sample

Advertisements

Configuration ngoài cho ứng dụng với Spring Boot

June 12, 2015 2 comments

1. Sử dụng properties file SpringApplication sẽ load các property từ tất cả các file application.properties trong các vị trí sau, và thêm chúng vào application environment: + Folder /config bên trong folder hiện tại. + Folder hiện tại. + Class path /config + Root class path Mặc định, SpringApplication sẽ load theo thứ tự từ dưới lên trên. Và các property nào load sau sẽ override property load trước. Vì lý do này, bạn cứ đặt property vào class path bình thường, khi muốn config ngoài file jar, thì sẽ đặt file application.properties vào folder /config là được. Như vậy cần phải build dự án với maven sao cho có kết quả trong folder target như sau:

+-target
    +---myapp.jar
    +---config
            +--application.properties

Read more…

Categories: Java Tags: , ,

Sử dụng configuration class trong Spring Boot


1. Sử dụng class Configuration
Spring Boot ưu ái việc sử dụng các class Configuration. Mặc dù bạn có thể hoàn toàn sử dụng việc gọi hàm SpringApplication.run() ngay bên trong file XML, nhưng nhìn chung Spring khuyên điểm xuất phát của ứng dụng là một class với annotation @Configuration. Thông thường thì class với hàm main() thì nên là cũng là lớp chứa @Configuration.

import org.springframework.boot.SpringApplication;
import org.springframework.context.annotation.Configuration;

@Configuration
public class Application
{
    public static void main(final String[] args)
    {
        SpringApplication.run(Application.class, args);
    }
}

Read more…

Categories: Java Tags: , , ,

Configure spring security with ldap authentication and local system roles in grails

December 2, 2014 Leave a comment

Add plugins Add plugins of Spring security and ldap in BuildConfig

plugins {
        compile ":spring-security-core:2.0-RC4"
        compile ":spring-security-ldap:2.0-RC2"
    }

Configure spring security
Configure spring security and LDAP authentication in Config
Read more…

Categories: Java Tags: , , , ,
%d bloggers like this: