Uploaded image for project: 'Continuum'
  1. Continuum
  2. CONTINUUM-1586

Oracle DB use in Continuum

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 1.1
    • 1.4.1
    • Data Management
    • None
    • An Oracle DB
    • Patch

    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

      Attachments

        1. package-oracle.orm
          1 kB
        2. package-oracle.orm
          1 kB
          Raul Casado Piqueras

        Issue Links

          Activity

            People

              brett Brett Porter
              capira Raul Casado Piqueras
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: