JPA using multiple database schemas

by

I had the same problem I solved that with a persistence.xml in which I refer to the needed orm.xml files within I declared the db shema

<persistence
xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0" >
<persistence-unit name="schemaOne">
    . . .
    <mapping-file>ormOne.xml</mapping-file>
    . . .
</persistence-unit>

<persistence-unit name="schemaTwo">
    . . .
    <mapping-file>ormTwo.xml</mapping-file>
    . . .
 </persistence-unit>
</persistence>

now you can create a EntityManagerFactory for your special schema

EntityManagerFactory emf = Persistence.createEntityManagerFactory("schemaOne");

More Related Contents:

  1. Hibernate, spring, JPS & isolation – custom isolation not supported
  2. What is this spring.jpa.open-in-view=true property in Spring Boot?
  3. setMaxResults for Spring-Data-JPA annotation?
  4. Bypass GeneratedValue in Hibernate (merge data not in db?)
  5. Spring Data JPA – ZonedDateTime format for json serialization
  6. How does the FetchMode work in Spring Data JPA
  7. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  8. Handling soft-deletes with Spring JPA
  9. Hibernate and no PK
  10. Implementing custom methods of Spring Data repository and exposing them through REST
  11. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  12. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  13. Spring-Data FETCH JOIN with Paging is not working
  14. Could not commit JPA transaction: Transaction marked as rollbackOnly
  15. Why use returned instance after save() on Spring Data JPA Repository?
  16. Spring JpaRepository – Detach and Attach entity
  17. Use abstract super class as parameter for Spring data repository
  18. How to use @Transactional with Spring Data?
  19. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  20. Error creating bean with name ‘entityManagerFactory
  21. Spring Data JPA find by embedded object property
  22. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  23. How to configure transaction management for working with 2 different db in Spring?
  24. How to create join table with JPA annotations?
  25. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  26. How to auto detect entities in JPA 2.0
  27. JpaItemWriter: no transaction is in progress
  28. TransactionRequiredException Executing an update/delete query
  29. Spring v3 no declaration can be found for element ‘mvc:resources’
  30. IllegalArgumentException: At least one JPA metamodel must be present

Leave a Comment