0 Replies Latest reply on Aug 18, 2009 4:20 AM by Guy Coleman

    Oracle, datasources and hibernate.default_schema

    Guy Coleman Newbie

      I'm using hibernate inside JBoss with an Oracle datasource. Usually when I do JDBC queries against the datasource it uses the schema as defined in the -ds.xml. But with hibernate I have to add the hibernate.default_schema property in persistence.xml too:

      <persistence-unit name="jpaPersistence">
       <jta-data-source>java:/MainDS</jta-data-source>
      ...
       <properties>
       <property name="hibernate.default_schema" value="guy" />
      ...
      


      I've got a set up where the schema changes a lot between environments and ususally I can change the -ds.xml in deploy/ and that's all that needs doing.

      However with hibernate have to change the persistence.xml file inside the EAR too - I want to avoid have to change the EAR file if I can help it.

      I was wondering if there was a way of making hibernate pick up the default schema from the datasource?