java初始化数据报_java – 在Spring中初始化多个数据库

我正在使用AbstractRoutingDatasource在运行时在数据库之间进行路由.在informix数据库的实际情况下一切正常.

对于测试,我创建了一个弹簧配置文件,用于内存H2数据库.

运行测试配置文件后的spring应用程序后,我使用h2控制台检查了本地数据库.没有创建架构.

我尝试在recources和hibernates中使用schema.sql：

generate-ddl: true

hibernate:

ddl-auto: create-drop

冬眠投掷

java.lang.IllegalStateException: Cannot determine target DataSource for lookup key [null]

据我所知,hibernate试图只生成“路由”数据源.由于没有设置DatabaseContextHolder(null),因此失败.

两种方式都失败了.

有没有办法用(相同)模式初始化所有数据库？

我在下面列出了我的配置.

bootstrap.yml：

spring:

profiles: acceptanceTest

config:

name: standalone

cloud:

config:

enabled: false

discovery:

enabled: false

jpa:

database-platform: org.hibernate.dialect.H2Dialect

generate-ddl: true

hibernate:

ddl-auto: create-drop

properties:

hibernate:

show_sql: false

use_sql_comments: false

format_sql: false

h2:

console:

enabled: true

path: /h2

datasource:

mc:

driver-class-name: 'org.h2.Driver'

url: 'jdbc:h2:mem:test-mc-db;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE'

username: sa

password: ''

platform: h2

initialize: true

type: com.zaxxer.hikari.HikariDataSource

hikari:

maximum-pool-size: 10

minimum-idle: 0

idle-timeout: 60000

pool-name: MarkHikariPool

cw:

driver-class-name: 'org.h2.Driver'

url: 'jdbc:h2:mem:test-cw-db'

username: sa

password: ''

type: com.zaxxer.hikari.HikariDataSource

hikari:

maximum-pool-size: 10

minimum-idle: 0

idle-timeout: 60000

pool-name: MarkHikariPool

MainApp.java：

@ComponentScan({ "de.md.mark" })

@EnableDiscoveryClient

@SpringBootApplication(

exclude =

{

DataSourceAutoConfiguration.class,

DataSourceTransactionManagerAutoConfiguration.class,

HibernateJpaAutoConfiguration.class

}

)

public class MainApp

{

public static void main(String[] args)

{

DataSourceConfiguration.java：

@Configuration

@EnableJpaRepositories(

basePackageClasses = { MarkTypeRepository.class, MarkRepository.class }, entityManagerFactoryRef = "markEntityManager",

transactionManagerRef = "markTransactionManager"

)

@EnableTransactionManagement

public class DataSourceConfiguration

{

@Autowired(required = false)

private PersistenceUnitManager persistenceUnitManager;

@Bean

@ConfigurationProperties("app.jpa")

@Primary

public JpaProperties jpaProperties()

{

return new JpaProperties();

}

@Bean

@ConfigurationProperties(prefix = "datasource.mc")

public DataSource mcDataSource()

{

return DataSourceBuilder.create().build();

}

@Bean

@ConfigurationProperties(prefix = "datasource.cw")

public DataSource cwDataSource()

{

return DataSourceBuilder.create().build();

}

@Bean

@Primary

public DataSource dataSource()

{

DataSourceRouter router = new DataSourceRouter();

final HashMap map = new HashMap<>(DatabaseEnvironment.values().length);

map.put(DatabaseEnvironment.MC, mcDataSource());

map.put(DatabaseEnvironment.CW, cwDataSource());

router.setTargetDataSources(map);

return router;

}

@Bean

@Primary

public LocalContainerEntityManagerFactoryBean markEntityManager(final JpaProperties jpaProperties)

{

EntityManagerFactoryBuilder builder = createEntityManagerFactoryBuilder(jpaProperties);

return builder.dataSource(dataSource()).packages(MarkTypeEntity.class).persistenceUnit("markEntityManager").build();

}

@Bean

@Primary

public JpaTransactionManager markTransactionManager(@Qualifier("markEntityManager") final EntityManagerFactory factory)

{

return new JpaTransactionManager(factory);

}

private EntityManagerFactoryBuilder createEntityManagerFactoryBuilder(JpaProperties jpaProperties)

{

JpaVendorAdapter jpaVendorAdapter = createJpaVendorAdapter(jpaProperties);

return new EntityManagerFactoryBuilder(jpaVendorAdapter, jpaProperties.getProperties(), this.persistenceUnitManager);

}

private JpaVendorAdapter createJpaVendorAdapter(JpaProperties jpaProperties)

{

AbstractJpaVendorAdapter adapter = new HibernateJpaVendorAdapter();

adapter.setShowSql(jpaProperties.isShowSql());

adapter.setDatabase(jpaProperties.getDatabase());

adapter.setDatabasePlatform(jpaProperties.getDatabasePlatform());

adapter.setGenerateDdl(jpaProperties.isGenerateDdl());

return adapter;

}

}