[CONTINUUM-1586] Oracle DB use in Continuum

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 1.1
• Fix Version/s: 1.4.1
• Component/s: Data Management
• Environment: An Oracle DB
• Flags: Patch
• Assignee: Brett Porter
• Reporter: Raul Casado Piqueras
• Created: 30/Nov/07 12:23
• Updated: 05/Apr/15 14:44
• Resolved: 22/Nov/12 23:37

Description

Continuum is not able to run against an Oracle DB.

I have attached a patch that should be included in next releases in continuum in order to support Oracle DB. Should be packed in continuum-model-x.y.jar

Workaround till next release with this pacth applied:
1. copy the attached file into WEB-INF/classes/ dir
2. edit the application.xml and change the value of javax.jdo.option.Mapping property to oracle (you may have to make available this property)
<property>
<name>javax.jdo.option.Mapping</name>
<value>oracle</value>
</property>
3. edit your context.xml file or whatever you use in order to set the oracle settings:
<Resource name="jdbc/users"
auth="Container"
type="javax.sql.DataSource"
username="continuum"
password="s3cr3t"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.1.25:1521:BDD01" />

<Resource name="jdbc/continuum"
auth="Container"
type="javax.sql.DataSource"
username="continuum"
password="s3cret"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.1.25:1521:BDD01" />

4. copy ojdbc14.jar into the classpath (TOMCAT_HOME/common/lib or WEB-INF/lib)

Tested with Oracle 10g

Issue Links

• is duplicated by: CONTINUUM-1622 ORA-00910: specified length too long for its datatype on continuum startup
• supercedes: CONTINUUM-1197 Continuum aborts when using Oracle database after applying patch in CONTINUUM-961