jpa适配达梦数据库相关配置

datasource:
    type: com.zaxxer.hikari.HikariDataSource
    url: jdbc:dm://xxx.xxx.xxx.xx:5236?SCHEMA=test
    username: SYSDBA
    password: SYSDBA
    databaseName: test
    dialect: org.hibernate.dialect.DmDialect
    driver-class-name: dm.jdbc.driver.DmDriver
jpa:
    database-platform: org.hibernate.dialect.DmDialect
    #    database: DM
    show-sql: true

以上为applicaton-prod.yml中的配置。
驱动为DmJdbcDriver18
方言包为DmDialect-for-hibernate5.3

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,下面是数据库JPA 多源数据库配置方法: 1. 首先,在 pom.xml 文件中添加数据库的 JDBC 驱动依赖: ```xml <dependency> <groupId>dm.jdbc.driver</groupId> <artifactId>dm7jdbc</artifactId> <version>7.2.2-jre7</version> </dependency> ``` 2. 在 application.properties 文件中添加数据源的配置信息: ```properties # 主数据源 spring.datasource.primary.url=jdbc:dm://localhost:5236/mydb spring.datasource.primary.username=myusername spring.datasource.primary.password=mypassword spring.datasource.primary.driver-class-name=dm.jdbc.driver.DmDriver # 第二个数据源 spring.datasource.secondary.url=jdbc:dm://localhost:5236/mydb2 spring.datasource.secondary.username=myusername2 spring.datasource.secondary.password=mypassword2 spring.datasource.secondary.driver-class-name=dm.jdbc.driver.DmDriver ``` 3. 在代码中配置 JPA 的多源数据库: ```java @Configuration @EnableTransactionManagement @EnableJpaRepositories( entityManagerFactoryRef = "primaryEntityManagerFactory", transactionManagerRef = "primaryTransactionManager", basePackages = {"com.example.primary.repository"} ) public class PrimaryDataSourceConfig { @Primary @Bean(name = "primaryDataSource") @ConfigurationProperties(prefix = "spring.datasource.primary") public DataSource primaryDataSource() { return DataSourceBuilder.create().build(); } @Primary @Bean(name = "primaryEntityManagerFactory") public LocalContainerEntityManagerFactoryBean primaryEntityManagerFactory( EntityManagerFactoryBuilder builder, @Qualifier("primaryDataSource") DataSource dataSource) { return builder .dataSource(dataSource) .packages("com.example.primary.entity") .persistenceUnit("primary") .build(); } @Primary @Bean(name = "primaryTransactionManager") public PlatformTransactionManager primaryTransactionManager( @Qualifier("primaryEntityManagerFactory") EntityManagerFactory entityManagerFactory) { return new JpaTransactionManager(entityManagerFactory); } } @Configuration @EnableTransactionManagement @EnableJpaRepositories( entityManagerFactoryRef = "secondaryEntityManagerFactory", transactionManagerRef = "secondaryTransactionManager", basePackages = {"com.example.secondary.repository"} ) public class SecondaryDataSourceConfig { @Bean(name = "secondaryDataSource") @ConfigurationProperties(prefix = "spring.datasource.secondary") public DataSource secondaryDataSource() { return DataSourceBuilder.create().build(); } @Bean(name = "secondaryEntityManagerFactory") public LocalContainerEntityManagerFactoryBean secondaryEntityManagerFactory( EntityManagerFactoryBuilder builder, @Qualifier("secondaryDataSource") DataSource dataSource) { return builder .dataSource(dataSource) .packages("com.example.secondary.entity") .persistenceUnit("secondary") .build(); } @Bean(name = "secondaryTransactionManager") public PlatformTransactionManager secondaryTransactionManager( @Qualifier("secondaryEntityManagerFactory") EntityManagerFactory entityManagerFactory) { return new JpaTransactionManager(entityManagerFactory); } } ``` 以上是数据库JPA 多源数据库配置方法,希望对你有所帮助。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值