Bug 1057300 - Add support for Oracle 12c
Summary: Add support for Oracle 12c
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Database
Version: unspecified
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: GA
: RHQ 4.11
Assignee: Jay Shaughnessy
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On:
Blocks: JON3-53, PRODMGT-661 1085900
TreeView+ depends on / blocked
 
Reported: 2014-01-23 19:27 UTC by dsteigne
Modified: 2014-07-21 10:13 UTC (History)
3 users (show)

Fixed In Version:
Clone Of:
: JON3-53, PRODMGT-661 (view as bug list)
Environment:
Last Closed: 2014-07-21 10:13:44 UTC
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 699703 0 None None None Never

Description dsteigne 2014-01-23 19:27:52 UTC
Description of problem:
Since the current release of Oracle 11.2 will come off of support in Jan 2015, can you add support in RHQ/JON for Oracle 12

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 Heiko W. Rupp 2014-02-24 13:27:07 UTC
master 32c7ee5c92f adds the classes that are necessary to recognize Oracle12c.
Domain tests worked (as well as they can be for a remote database on a different continent) when I manually added 

      <property
        name="hibernate.dialect"
        value="org.hibernate.dialect.Oracle10gDialect" />

to test-persistence.xml , as I did not have the mvn command line for this ready.

Comment 2 Jay Shaughnessy 2014-03-28 14:41:35 UTC
I've done some testing against ora 12c using a dballocator instance.  Unfortunately the dballocator instance was extremely slow. Also, I found no way to set the Oracle GRANTs that we require in our db prerequisites.

Taking into account that certain warnings were due to the missing GRANTs and the latency issues, I was able to spin up a dev container, install, start and run successfully.  Resource discovery, import, avail and various GUI views all looked OK.

I also ran the domain i-tests successfully as well as some individual server i-test classes (the whole sweet was too slow to run completely).

Instead of editing persistence.xml as mentioned in comment 1 I made the change described in the commit below.  Since persistence.xml does not perform property resolution we would have had to edit it when moving between oracle and postgres, which is difficult.

Also, when running the i-tests against oracle it is important to supply

   -Pitest.oracle

This properly sets up the EAP standalone.xml configuration.

master commit e2a5830dd84643b65ad324fe6275b5161a755b38
Author: Jay Shaughnessy <jshaughn>
Date:   Fri Mar 28 10:35:21 2014 -0400

    Since the Hibernate4 standard dialect resolver does not recognize
    Oracle 12, we need to ensure the hibernate.dialect system property
    is set when running the i-tests.

Comment 3 Jay Shaughnessy 2014-03-31 13:46:00 UTC
master commit 44de78d0d3344d5e982049a299275013c3e3f30a
Author: Jay Shaughnessy <jshaughn>
Date:   Fri Mar 28 16:52:52 2014 -0400

To support oracle 12c, updating the default driver version. It should be backward
compatible to our earlier, supported releases.

Comment 5 Heiko W. Rupp 2014-07-21 10:13:44 UTC
Bulk closing of RHQ 4.11 issues, now that RHQ 4.12 is out.

If you find an issue with those, please open a new BZ, linking to the old one.


Note You need to log in before you can comment on or make changes to this bug.