Issue
Hikari size set total 1 how to set in dbConfig
Solution
@Configuration
@EnableTransactionManagement()
@EnableJpaRepositories(entityManagerFactoryRef = "entitymangaer",transactionManagerRef="transactionManager",basePackages="com.master.dto")
public class DbConfig {
@Bean
@Primary
@ConfigurationProperties("spring.datasource")
public HikariDataSource memberDataSourceProperties() {
return new HikariDataSource();
}
@Bean(name ="erp_cha_ngpillai")
@ConfigurationProperties(prefix = "spring.datasource.configuration")
public DataSource datasourceMaster() {
memberDataSourceProperties().setMaximumPoolSize(1);
memberDataSourceProperties().setUsername("test");
memberDataSourceProperties().setPassword("test");
memberDataSourceProperties().setJdbcUrl("jdbc:mysql://localhost/test?sessionVariables=sql_mode='NO_ENGINE_SUBSTITUTION'&jdbcCompliantTruncation=false");
memberDataSourceProperties().setDriverClassName("com.mysql.cj.jdbc.Driver");
return memberDataSourceProperties();
}
@Bean(name = "entitymangaer")
@Primary
public LocalContainerEntityManagerFactoryBean masterEntityManagerFactory(EntityManagerFactoryBuilder builder,@Qualifier("erp_cha_ngpillai") DataSource dataSource) {
return builder.dataSource(dataSource).packages(PlaceOrganizationDao.class).build();
}
@Bean(name ="transactionManager")
@Primary
public PlatformTransactionManager masterManager(@Qualifier("entitymangaer") EntityManagerFactory entityManagerFactory)
{
return new JpaTransactionManager(entityManagerFactory);
}
}
Answered By - pearl bell
Answer Checked By - Timothy Miller (JavaFixing Admin)