[jira] [Commented] (OOZIE-2143) Making two Oozie schemas in an Oracle Database does not behave correctly

["Bowen Zhang (JIRA)" <ji...@apache.org>]

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

Bowen Zhang commented on OOZIE-2143:
------------------------------------

We encountered this defect 6 months ago. The workaround we had is to manually insert data into the second sid in oracle. Did you have the same problem? What is the problem you encountered?

> Making two Oozie schemas in an Oracle Database does not behave correctly
> ------------------------------------------------------------------------
>
>                 Key: OOZIE-2143
>                 URL: https://issues.apache.org/jira/browse/OOZIE-2143
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Robert Kanter
>
> If you have an Oracle Database and try to create a second Oozie schema in it (for a second separate Oozie server), it will not work correctly unless you have some very specific permissions set.  This is due to a bug in OpenJPA's mapping tool, which has been open for many years with little-to-no activity.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)