You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "jiraposter@reviews.apache.org (Commented) (JIRA)" <ji...@apache.org> on 2012/04/17 12:41:18 UTC

[jira] [Commented] (OOZIE-814) Add support of configuring db's schema in JPAService for oozie

    [ https://issues.apache.org/jira/browse/OOZIE-814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13255454#comment-13255454 ] 

jiraposter@reviews.apache.org commented on OOZIE-814:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/4755/
-----------------------------------------------------------

Review request for oozie.


Summary
-------

Oozie's JPA service doesn't support configure different schemas for oozie's db.
Our company wants to use one db for multi oozie clusters, and then we want each oozie cluster can use different schema of the db. Therefore JPAService in oozie should support to configure the schema of the db, not just the database.
The oozie.db.schema.name is use to configure oozie's db name, however, it is a little confusing for it is not used to configure the actually schema of db.


This addresses bug OOZIE-814.
    https://issues.apache.org/jira/browse/OOZIE-814


Diffs
-----

  http://svn.apache.org/repos/asf/incubator/oozie/trunk/core/src/main/conf/oozie-site.xml 1327027 
  http://svn.apache.org/repos/asf/incubator/oozie/trunk/core/src/main/java/org/apache/oozie/service/JPAService.java 1327027 
  http://svn.apache.org/repos/asf/incubator/oozie/trunk/core/src/main/resources/oozie-default.xml 1327027 

Diff: https://reviews.apache.org/r/4755/diff


Testing
-------

* Deployed Oozie, added oozie.db.schema.name configs values, succeed to run the examples on Derby and Postgres databases.


Thanks,

Han


                
> Add support of configuring db's schema in JPAService for oozie
> --------------------------------------------------------------
>
>                 Key: OOZIE-814
>                 URL: https://issues.apache.org/jira/browse/OOZIE-814
>             Project: Oozie
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 3.2.0, trunk
>            Reporter: Han Xiao
>             Fix For: trunk
>
>
> Oozie's JPA service doesn't support configure different schemas for oozie's db.
> Our company wants to use one db for multi oozie clusters, and then we want each oozie cluster can use different schema of the db. Therefore JPAService in oozie should support to configure the schema of the db, not just the database.
> The oozie.db.schema.name is use to configure oozie's db name, however, it is a little confusing for it is not used to configure the actually schema of db.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira