Page Comparison

There are multiple ways in OpenHub how to store custom business data.

...

• is achievable via configuration
• JPA can be leveregedleveraged
• Nature & quantity of business data should be considered, as it cannot be scaled separately from the core tables

...

1. Add custom JPA entities
2. Extend OpenHub database scheme with new objects (tables, sequences ...) . Directly in project database, flyway in OpenHub can be used as well. (https://flywaydb.org/)

3. Configure EntityManager, to scan custom packages, with OpenHub configuration property ohf.jpa.additional-packages
   Example: 

   Code Block
   ohf.jpa.additional-packages=org.openhubframework.openhub.ri.persistence

   
   

4. Entity manager bean can be used for building custom dao, or configure repositories using spring-data-jpa.

b) Add second datasource to be used without JPA

• straightforward setup, except that OpenHubDatasource is Primary bean, so project has to work with Qualified dataSource.
• For example JdbcTemplate can be used that way, other frameworks build on top if, or entirelly wrapped service (not exposing beans to spring context).

c) Add second datasource, with global transaction (one transactionManager)

• SpringBoot autoconfiguration auto-configuration can be levered, either setup with JTA (Atomikos, Bitronix) or provided by application server.
• Project specific dataSource, entityManagerFactory (and entityManager) can be configured, to have two separate JPA contexts.
• Different databases can be configured for each JPA context as well. 

...

1. Add custom JPA entities.
2. Configure project-specific DataSource & EntityManagerFactory. Each of them should have custom Qualifier.

3. Create custom dao, or configure spring-data-jpa repositories.
   Configuration of spring-data-jpa repositories can look like this:

   Code Block
   language java
   @EnableJpaRepositories( entityManagerFactoryRef = "customEntityManagerFactory", basePackages = "org.openhubframework.openhub.ri.persistence.repository") @Configuration public class SecondDataSourceConfiguration { @Bean @Qualifier("customEntityManagerFactory") LocalContainerEntityManagerFactoryBean customEntityManagerFactory() { HibernateJpaVendorAdapter jpaVendorAdapter = new HibernateJpaVendorAdapter(); jpaVendorAdapter.setGenerateDdl(false); LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean(); factoryBean.setJpaVendorAdapter(jpaVendorAdapter); factoryBean.setPackagesToScan(User.class.getPackage().getName()); factoryBean.setJtaDataSource(customDataSource()); return factoryBean; } @Bean @Qualifier("customDataSource") DataSource customDataSource() { return DataSourceBuilder.create() .url("jdbc:mysql://localhost:3306/testdb?useSSL=false&nullNamePatternMatchesAll=true") .driverClassName("com.mysql.jdbc.Driver") .username("*****") .password("*****") .build(); }

   
   

...

• Spring boot by default does not configure transactionManager, if there is already bean present.
• OpenHub can be configured to provide its own JpaTransactionManager explicitely, even if there is already another bean of PlatformTransactionManager, see configuration property ohf.jpa.transaction-manager.enabled

Steps

1. Add custom JPA entities.
2. Configure project-specific DataSource, EntityManagerFactory & TransactionManager. Each of them should have custom Qualifier.

3. Configure OpenHub to register JpaTransactionManager for OpenHub entities. By default, it is disabled, and transactionManager is configured by SpringBoot.

   Code Block
   ohf.jpa.transaction-manager.enabled=true

   
   

4. Create custom dao, or configure spring-data-jpa repositories.

   Configuration of spring-data-jpa repositories can look like this :

   Code Block
   language java
   @EnableJpaRepositories( entityManagerFactoryRef = "customEntityManagerFactory", transactionManagerRef = "customTransactionManager", basePackages = "org.openhubframework.openhub.ri.persistence.repository") @Configuration public class SecondDataSourceJpaConfiguration { @Bean @Qualifier("customTransactionManager") PlatformTransactionManager customTransactionManager() { return new JpaTransactionManager(customEntityManagerFactory().getObject()); } @Bean @Qualifier("customEntityManagerFactory") LocalContainerEntityManagerFactoryBean customEntityManagerFactory() { HibernateJpaVendorAdapter jpaVendorAdapter = new HibernateJpaVendorAdapter(); jpaVendorAdapter.setGenerateDdl(false); LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean(); factoryBean.setJpaVendorAdapter(jpaVendorAdapter); factoryBean.setPackagesToScan(User.class.getPackage().getName()); factoryBean.setDataSource(customDataSource()); return factoryBean; } @Bean @Qualifier("customDataSource") DataSource customDataSource() { return DataSourceBuilder.create() .url("jdbc:mysql://localhost:3306/testdb?useSSL=false&nullNamePatternMatchesAll=true") .driverClassName("com.mysql.jdbc.Driver") .username("*****") .password("*****") .build(); }