How to set up default schema name in JPA configuration

Question

I found that in hibernate config file we could set up parameter hibernate default schema    lt hibernate-configuration gt       lt session-factory gt                   lt property name  hibernate default schema  gt myschema lt  property gt                lt  session-factory gt   lt  hibernate-configuration gt    Now I m using JPA and I want to do the same  Otherwise I have to add parameter schema to each  Table annotation like    Entity  Table  name    projectcategory   schema    SCHEMANAME   public class Category implements Serializable           As I understand this parameter should be somewhere in this part of configuration    lt bean id  domainEntityManagerFactory  class  org springframework orm jpa LocalContainerEntityManagerFactoryBean  gt       lt property name  persistenceUnitName  value  JiraManager   gt       lt property name  dataSource  ref  domainDataSource   gt       lt property name  jpaVendorAdapter  gt           lt bean class  org springframework orm jpa vendor HibernateJpaVendorAdapter  gt               lt property name  generateDdl  value  false   gt               lt property name  showSql  value  false   gt               lt property name  databasePlatform  value    hibernate dialect    gt           lt  bean gt       lt  property gt   lt  bean gt    lt bean id  domainDataSource  class  com mchange v2 c3p0 ComboPooledDataSource  destroy-method  close  gt       lt property name  driverClass  value    db driver     gt       lt property name  jdbcUrl  value    datasource url     gt       lt property name  user  value    datasource username     gt       lt property name  password  value    datasource password     gt       lt property name  initialPoolSize  value  5   gt       lt property name  minPoolSize  value  5   gt       lt property name  maxPoolSize  value  15   gt       lt property name  checkoutTimeout  value  10000   gt       lt property name  maxStatements  value  150   gt       lt property name  testConnectionOnCheckin  value  true   gt       lt property name  idleConnectionTestPeriod  value  50   gt   lt  bean gt        but I can t find its name in google  Any ideas

User · Accepted Answer

Don t know of JPA property for this either  But you could just add the Hibernate property  assuming you use Hibernate as provider  as         lt property name  hibernate default schema  value  myschema   gt         Hibernate should pick that up

User · Answer

For others who use spring-boot  java based configuration   I set the schema value in application properties  spring jpa properties hibernate dialect     spring jpa properties hibernate default schema

User · Answer

In order to avoid hardcoding schema in JPA Entity Java Classes we used orm xml mapping file in Java EE application deployed in OracleApplicationServer10  OC4J Orion    It lays in model jar META-INF  as well as persistence xml  Mapping file orm xml is referenced from peresistence xml with tag          lt persistence-unit name  MySchemaPU   transaction-type  JTA  gt       lt provider gt        lt mapping-file gt META-INF orm xml lt  mapping-file gt        File orm xml content is cited below    lt  xml version  1 0  encoding  UTF-8   gt   lt entity-mappings xmlns  http   java sun com xml ns persistence orm                   xmlns xsi  http   www w3 org 2001 XMLSchema-instance                   xsi schemaLocation  http   java sun com xml ns persistence orm http   java sun com xml ns persistence orm 1 0 xsd                   version  1 0  gt    lt persistence-unit-metadata gt      lt persistence-unit-defaults gt      lt schema gt myschema lt  schema gt     lt  persistence-unit-defaults gt    lt  persistence-unit-metadata gt   lt  entity-mappings gt

User · Answer

For those who uses last versions of spring boot will help this     properties   spring jpa properties hibernate default schema  lt name of your schema gt     yml   spring      jpa          properties              hibernate                  default schema   lt name of your schema gt

User · Answer

I had to set the value in    and     spring     jpa       properties         hibernate            default schema    schema

User · Answer

If you are using  org springframework jdbc datasource DriverManagerDataSource   in ApplicationContext xml to specify Database details then use below simple property to specify the schema   lt property name  quot schema quot  value  quot schemaName quot    gt

User · Answer

Just to save time of people who come to the post  like me  who looking for Spring config type and want you schema name be set by an external source  property file    The configuration will work for you is    lt bean id  domainEntityManagerFactory  class  org springframework orm jpa LocalContainerEntityManagerFactoryBean  gt       lt property name  persistenceUnitName  value  JiraManager   gt       lt property name  dataSource  ref  domainDataSource   gt       lt property name  jpaVendorAdapter  gt           lt bean class  org springframework orm jpa vendor HibernateJpaVendorAdapter  gt               lt property name  generateDdl  value  false   gt               lt property name  showSql  value  false   gt               lt property name  databasePlatform  value    hibernate dialect    gt           lt  bean gt       lt  property gt       lt property name  jpaProperties  gt          lt props gt               lt prop key  hibernate hbm2ddl auto  gt none lt  prop gt               lt prop key  hibernate default schema  gt   yourSchema  lt  prop gt          lt  props gt   lt  property gt    lt  bean gt    Ps    For the hibernate hdm2ddl auto  you could look in the post Hibernate hbm2ddl auto possible values and what they do   I have used to set create-update because it is convenient  However  in production  I think it is better to take control of the ddl  so I take whatever ddl generate first time  save it  rather than let it automatically create and update

User · Answer

Use this    Table  name    Test   schema      schema       insteade of  Table  name    Test   schema    schema    If you are on postgresql the request is     SELECT   FROM  schema  test    not     SELECT   FROM schema test   PS  Test is a table

[java] How to set up default schema name in JPA configuration?

Examples related to java

Examples related to hibernate

Examples related to spring

Examples related to configuration

Examples related to jpa