java 如何在Sping Boot 中跳过某些@Entity类，使其不被创建为h2(内存中)数据库中的表？

cuxqih21  于 2022-11-20  发布在  Java
关注(0)|答案(2)|浏览(214)

我正在尝试构建一个使用2个数据源的Sping Boot 应用程序。目前我的主数据库是内存中的数据库（仅用于测试目的），其中的表是通过我创建的sql文件填充的。另一个数据库（oracledb）中的表已经填充。

**我尝试实现什么目标？**我尝试从oracledb提取数据，处理数据并填充h2数据库中的表。
**我面临的问题是什么？**我只希望h2 db的实体被创建为in-mem数据库中的表（我希望能够指定h2要扫描哪些实体并创建表，而不是所有具有@Entity注解的类）。所有具有@Entity的类都被创建为我的in-mem数据库中的表，这正是我试图避免的。
**我尝试了哪些方法？**我为属于h2和oracledb的实体创建了两个单独的包，并使用@EntityScan仅扫描了包含h2实体的包。此方法有效，但我需要扫描oracledb的其他实体，以便能够使用它们。

我所拥有的代码片段：

我的applications.properties文件

  1. #spring.jpa.hibernate.ddl-auto=none
  2. spring.jpa.generate-ddl=true
  4. spring.h2.console.enabled=true
  5. spring.h2.console.path=/h2
  7. # first data source
  8. spring.datasource.url=jdbc:h2:mem:mydb
  9. spring.datasource.driverClassName=org.h2.Driver
  10. spring.datasource.username=sa
  11. spring.datasource.password=
  13. spring.application.name=Health Monitor
  15. ## 2nd data source
  16. spring.production-datasource.url= jdbc:oracle://localhost:3306/db2
  17. spring.production-datasource.driverClassName=oracle.jdbc.driver.OracleDriver
  18. spring.production-datasource.username=abcd
  19. spring.production-datasource.password=xyz123

演示应用程序.java

  1. package com.automation.demo;
  3. import java.sql.SQLException;
  5. import org.springframework.boot.SpringApplication;
  6. import org.springframework.boot.autoconfigure.SpringBootApplication;
  7. import org.springframework.boot.autoconfigure.domain.EntityScan;
  8. import org.springframework.context.annotation.Bean;
  10. @SpringBootApplication
  11. //@EntityScan( basePackages = {"domain"} )
  12. public class DemoApplication {
  14.     public static void main(String[] args) {
  15.         SpringApplication.run(DemoApplication.class, args);
  16.     }
  18.     @Bean(initMethod = "start", destroyMethod = "stop")
  19.     public org.h2.tools.Server inMemoryH2DatabaseaServer() throws SQLException {
  20.         return org.h2.tools.Server.createTcpServer(
  21.           "-tcp", "-tcpAllowOthers", "-tcpPort", "9090");
  22.     }
  25. }

配置数据库.java

  1. package com.automation.demo.configurations;
  3. import javax.sql.DataSource;
  5. import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
  6. import org.springframework.boot.context.properties.ConfigurationProperties;
  7. import org.springframework.boot.jdbc.DataSourceBuilder;
  8. import org.springframework.context.annotation.Bean;
  9. import org.springframework.context.annotation.Configuration;
  10. import org.springframework.context.annotation.Primary;
  11. import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
  13. import com.zaxxer.hikari.HikariDataSource;
  15. @Configuration
  16. public class ConfigureDB {
  18.     @Primary
  19.     @Bean
  20.     @ConfigurationProperties(prefix="spring.datasource")
  21.     public DataSourceProperties devDataSourceProperties() {
  22.         return new DataSourceProperties();
  23.     }
  25.     @Bean
  26.     @Primary
  27.     @ConfigurationProperties("spring.datasource.configuration")
  28.     public DataSource devDataSource() {
  29.         return devDataSourceProperties().initializeDataSourceBuilder()
  30.                 .type(HikariDataSource.class).build();
  31.     }
  33.     @Bean
  34.     @ConfigurationProperties("spring.production-datasource")
  35.     public DataSourceProperties productionDataSourceProperties() {
  36.         return new DataSourceProperties();
  37.     }
  39.     @Bean
  40.     @ConfigurationProperties("spring.production-datasource.configuration")
  41.     public DataSource productionDataSource() {
  43.         return productionDataSourceProperties().initializeDataSourceBuilder()
  44.                 .type(HikariDataSource.class).build();
  46.     }
  48. }

员工.java（用于h2数据库）

  1. package com.automation.demo.dev.entities;
  3. import javax.persistence.Column;
  4. import javax.persistence.Entity;
  5. import javax.persistence.GeneratedValue;
  6. import javax.persistence.GenerationType;
  7. import javax.persistence.Id;
  8. import javax.persistence.Table;
  10. @Entity
  11. @Table(name="test")
  12. public class Employee {
  14.     // define fields
  15.     @Id
  16.     @GeneratedValue(strategy=GenerationType.IDENTITY)
  17.     @Column(name="ID")
  18.     private int id;
  20.     @Column(name="FirstName")
  21.     private String firstName;
  23.     @Column(name="LastName")
  24.     private String lastName;
  26.     @Column(name="Email")
  27.     private String email;
  29.     // define constructors
  31.     public Employee() {
  33.     }
  35.     public Employee(String firstName, String lastName, String email) {
  36.         this.firstName = firstName;
  37.         this.lastName = lastName;
  38.         this.email = email;
  39.     }
  41.     // define getter/setter
  43.     public int getId() {
  44.         return id;
  45.     }
  47.     public void setId(int id) {
  48.         this.id = id;
  49.     }
  51.     public String getFirstName() {
  52.         return firstName;
  53.     }
  55.     public void setFirstName(String firstName) {
  56.         this.firstName = firstName;
  57.     }
  59.     public String getLastName() {
  60.         return lastName;
  61.     }
  63.     public void setLastName(String lastName) {
  64.         this.lastName = lastName;
  65.     }
  67.     public String getEmail() {
  68.         return email;
  69.     }
  71.     public void setEmail(String email) {
  72.         this.email = email;
  73.     }
  75.     // define tostring
  77.     @Override
  78.     public String toString() {
  79.         return "Employee [id=" + id + ", firstName=" + firstName + ", lastName=" + lastName + ", email=" + email + "]";
  80.     }
  82. }

CustomerInfo.java（这是表示oracledb中的表的实体，我希望阻止在h2数据库中创建表示此实体的表）

  1. package com.automation.demo.production.entities;
  3. import javax.persistence.Column;
  4. import javax.persistence.Entity;
  5. import javax.persistence.GeneratedValue;
  6. import javax.persistence.GenerationType;
  7. import javax.persistence.Id;
  8. import javax.persistence.Table;
  10. @Entity
  11. @Table(name="customer")
  12. public class CustomerInfo {
  14.     // define fields
  15.     @Id
  16.     @GeneratedValue(strategy=GenerationType.IDENTITY)
  17.     @Column(name="ID")
  18.     private int id;
  20.     @Column(name="FirstName")
  21.     private String firstName;
  23.     @Column(name="LastName")
  24.     private String lastName;
  26.     @Column(name="Email")
  27.     private String email;
  29.     // define constructors
  31.     public CustomerInfo() {
  33.     }
  35.     public CustomerInfo(String firstName, String lastName, String email) {
  36.         this.firstName = firstName;
  37.         this.lastName = lastName;
  38.         this.email = email;
  39.     }
  41.     // define getter/setter
  43.     public int getId() {
  44.         return id;
  45.     }
  47.     public void setId(int id) {
  48.         this.id = id;
  49.     }
  51.     public String getFirstName() {
  52.         return firstName;
  53.     }
  55.     public void setFirstName(String firstName) {
  56.         this.firstName = firstName;
  57.     }
  59.     public String getLastName() {
  60.         return lastName;
  61.     }
  63.     public void setLastName(String lastName) {
  64.         this.lastName = lastName;
  65.     }
  67.     public String getEmail() {
  68.         return email;
  69.     }
  71.     public void setEmail(String email) {
  72.         this.email = email;
  73.     }
  75.     // define tostring
  77.     @Override
  78.     public String toString() {
  79.         return "Customer [id=" + id + ", firstName=" + firstName + ", lastName=" + lastName + ", email=" + email + "]";
  80.     }
  82. }

请让我知道，如果我错过了什么。此外，如果有任何其他的错误，我已经作出，但不涉及我目前的问题，请提到那些以及。

  • 谢谢-谢谢
Java

2条答案

按热度按时间
vqlkdk9b

vqlkdk9b1#

Hibernate有一种方法可以通过SchemaFilterProvider来实现这一点。

架构筛选器提供程序

  1. public class MySchemaFilterProvider implements SchemaFilterProvider {
  3.     @Override
  4.     public SchemaFilter getCreateFilter() {
  5.         return MySchemaFilter.INSTANCE;
  6.     }
  8.     @Override
  9.     public SchemaFilter getDropFilter() {
  10.         return MySchemaFilter.INSTANCE;
  11.     }
  13.     @Override
  14.     public SchemaFilter getMigrateFilter() {
  15.         return MySchemaFilter.INSTANCE;
  16.     }
  18.     @Override
  19.     public SchemaFilter getValidateFilter() {
  20.         return MySchemaFilter.INSTANCE;
  21.     }
  22. }

架构筛选器

  1. public class MySchemaFilter implements SchemaFilter {
  3.     public static final MySchemaFilter INSTANCE = new MySchemaFilter();
  5.     @Override
  6.     public boolean includeNamespace(Namespace namespace) {
  7.         return true;
  8.     }
  10.     @Override
  11.     public boolean includeTable(Table table) {
  12.         if (table.getName().equals("customer")) {
  13.             return false;
  14.         }
  16.         return true;
  17.     }
  19.     @Override
  20.     public boolean includeSequence(Sequence sequence) {
  21.         return true;
  22.     }
  23. }

Spring属性配置

  1. spring.jpa.properties.hibernate.hbm2ddl.schema_filter_provider=MySchemaFilterProvider
展开查看全部
赞(0）分享  回复(0）举报  2022-11-20
vql8enpb

vql8enpb2#

注意--使用Springboot时，属性为：spring.jpa.properties.hibernate.hbm2ddl.schema_filter_provider=xxx

赞(0）分享  回复(0）举报  2022-11-20
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com