Return-Path: 
 <issues-return-5611-apmail-continuum-issues-archive=continuum.apache.org@continuum.apache.org>
Delivered-To: apmail-continuum-issues-archive@www.apache.org
Received: (qmail 891 invoked from network); 20 Oct 2010 00:03:02 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 20 Oct 2010 00:03:02 -0000
Received: (qmail 76654 invoked by uid 500); 20 Oct 2010 00:03:02 -0000
Delivered-To: apmail-continuum-issues-archive@continuum.apache.org
Received: (qmail 76618 invoked by uid 500); 20 Oct 2010 00:03:01 -0000
Mailing-List: contact issues-help@continuum.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@continuum.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@continuum.apache.org>
List-Post: <mailto:issues@continuum.apache.org>
List-Id: <issues.continuum.apache.org>
Reply-To: dev@continuum.apache.org
Delivered-To: mailing list issues@continuum.apache.org
Received: (qmail 76610 invoked by uid 99); 20 Oct 2010 00:03:01 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Oct 2010 00:03:01 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [63.246.2.115] (HELO codehaus01.managed.contegix.com)
 (63.246.2.115)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Oct 2010 00:02:55 +0000
Received: from codehaus01.managed.contegix.com (localhost.localdomain
 [127.0.0.1])
	by codehaus01.managed.contegix.com (Postfix) with ESMTP id C73F515E8026
	for <issues@continuum.apache.org>; Tue, 19 Oct 2010 19:02:33 -0500 (CDT)
Date: Tue, 19 Oct 2010 19:02:33 -0500 (CDT)
From: "Arun Nachimuthu (JIRA)" <jira@codehaus.org>
To: issues@continuum.apache.org
Message-ID: 
 <23788243.84575.1287532953637.JavaMail.haus-jira@codehaus01.managed.contegix.com>
Subject: [jira] Updated: (CONTINUUM-1586) Oracle DB use in Continuum
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 4e90ceb663894a42f12c0e28abbab431
X-Virus-Checked: Checked by ClamAV on apache.org


     [ http://jira.codehaus.org/browse/CONTINUUM-1586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arun Nachimuthu updated CONTINUUM-1586:
---------------------------------------

    Attachment: package-oracle.orm

There is a new table called ProjectScmRoot in version 1.3.x and 1.4.x which has error column greater than 4000 chars in size. Attached is the updated package-oracle.orm file.

> Oracle DB use in Continuum
> --------------------------
>
>                 Key: CONTINUUM-1586
>                 URL: http://jira.codehaus.org/browse/CONTINUUM-1586
>             Project: Continuum
>          Issue Type: Improvement
>          Components: Data Management
>    Affects Versions: 1.1
>         Environment: An Oracle DB
>            Reporter: Raul Casado Piqueras
>            Priority: Trivial
>             Fix For: 1.4.1 (Beta)
>
>         Attachments: package-oracle.orm, package-oracle.orm
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira