java - 在 Spring Boot 上配置两个数据库后,我从查询中收到了 empy 答案,为什么?
问题描述
我正在尝试将两个数据库连接到 Spring Boot 项目。当我尝试查询时,数据库中的结果为空。
该应用程序正常启动
当我尝试查询时,我收到一个nullpointer exception
public class PGDataBaseConfig {
@Bean(name = "Pgconfig")
@Primary
@ConfigurationProperties("spring.pgdatasource")
public DataSourceProperties firstDataSourceProperties() {
return new DataSourceProperties();
}
@Bean(name = "PG")
@Primary
public DataSource firstDataSource() {
return firstDataSourceProperties().initializeDataSourceBuilder().type(HikariDataSource.class).build();
}
@Bean(name = "PGem")
@Primary
public LocalContainerEntityManagerFactoryBean pgEntity(EntityManagerFactoryBuilder builder,
@Qualifier("PG") DataSource firstDataSource) {
HashMap<String,String> map = new HashMap<>();
map.put("hibernate.dialect", "org.hibernate.dialect.PostgreSQL9Dialect");
map.put("hibernate.show_sql", "true");
return builder.dataSource(firstDataSource).packages(".db.Postgress.Model").persistenceUnit("PGDB").properties(map)
.build();
}
@Primary
@Bean(name = "PGtrans")
public PlatformTransactionManager transactionManager(@Qualifier("PGem") EntityManagerFactory entityManagerFactory) {
return new JpaTransactionManager(entityManagerFactory);
}
}
第二个数据库配置
@EnableTransactionManagement
@EnableJpaRepositories(entityManagerFactoryRef = "MSem",basePackages = "sla.db.ms", bootstrapMode = BootstrapMode.DEFAULT)
public class MSDataBaseConfig {
@Bean(name ="MSConfig" )
@ConfigurationProperties("spring.ms.datasource")
public DataSourceProperties thirdDataSorceProperties() {
return new DataSourceProperties();
}
@Bean(name = "MS")
public DataSource thirdDataSource() {
return thirdDataSorceProperties().initializeDataSourceBuilder().type(HikariDataSource.class).build();
}
@Bean(name = "MStrans")
public PlatformTransactionManager transactionManager(
@Qualifier("MSem") EntityManagerFactory
entityManagerFactory
) {
return new JpaTransactionManager(entityManagerFactory);
}
解决方案
推荐阅读
- python - lxml / scrapy选择器可以不传输html实体吗
- javascript - 如何让 async/await 等待 Observable 返回
- javascript - 如何在 Firefox 70 中调试 service-worker javascript 代码
- python - Django - 重新呈现表单时自动完成字段
- python - 高斯过程中“张量不可散列”的张量流概率错误
- php - PDO::__construct(): php_network_getaddresses: getaddrinfo
- assembly - 跟踪寄存器和变量的变化
- c++ - Case 语句中的数组
- python - 需要等效函数来获取exchangelib Python中的别名,就像win32com中的这个(item.sender.getexchange().Alias)
- elasticsearch - ElasticSearch:地理点聚类