Details
-
Type:
Improvement
-
Status:
Closed
-
Priority:
Trivial
-
Resolution: Fixed
-
Affects Version/s: 1.1
-
Fix Version/s: 1.4.1
-
Component/s: Data Management
-
Labels:None
-
Environment:An Oracle DB
-
Complexity:Intermediate
-
Patch Submitted:Yes
-
Number of attachments :
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
-
Hello,
We had the same problem when using Continuum 1.1 and Oracle 10.2.0 XE.
FYI we used to solve it changing "stash.maxSize" superior to 4000 bytes to 4000 value, in the following files :
\src\continuum-data-management\continuum-legacy\src\main\mdo\continuum.xml
\src\continuum-model\src\main\mdo\continuum.xml
\src\main\mdo\continuum-service.xml
But, I think that the way that Raul is a better one.
Olivier.