continuum with oracle

[I am Who i am]

Is there anywhere any documenation for switching continuum database to
something different than the default one?/

i want to have oracle db, is there any migration scritps, or anything

If any one knows please let me know

[Wendy Smoak-3]

On 9/29/07, I am Who i am <ragjan@...> wrote:
> Is there anywhere any documenation for switching continuum database to
> something different than the default one?/
>
> i want to have oracle db, is there any migration scritps, or anything

It doesn't look like we have docs on it, but you might start with the
'Continuum on MySQL' wiki page, and then contribute one for Oracle
based on that:

http://docs.codehaus.org/display/CONTINUUMUSER/Continuum+on+MySQL

(You will probably need to create an account and log in before that
link will work.)

However, before you put too much time into it, I think there are some
issues re: using Continuum with Oracle.  Here's one that is still
open:  http://jira.codehaus.org/browse/CONTINUUM-1197

--
Wendy

[Cla Monsch]

hi

it's an unlovely story!

with 1.0.3 it was possible to use an oracle db. there you had to adjust
some mappings within the package.jdo file in the jpox jar. we also
tried to switch the 1.1-alpha2 version to oracle but we gave it up due
to problems between jpox and oracle.

i suspect there isn't any documentation about this topic.

cheers
cla


Quoting I am Who i am <ragjan@...>:

> Is there anywhere any documenation for switching continuum database to
> something different than the default one?/
>
> i want to have oracle db, is there any migration scritps, or anything
>
> If any one knows please let me know
>

[Emmanuel Venisse]

Actually, oracle db isn't supported due to some field lengths. A patch similar to the one for mssql can be done:
http://svn.apache.org/repos/asf/maven/continuum/trunk/continuum-model/src/main/resources/package-mssql.orm

Emmanuel

Cla Monsch a écrit :

> hi
>
> it's an unlovely story!
>
> with 1.0.3 it was possible to use an oracle db. there you had to adjust
> some mappings within the package.jdo file in the jpox jar. we also tried
> to switch the 1.1-alpha2 version to oracle but we gave it up due to
> problems between jpox and oracle.
>
> i suspect there isn't any documentation about this topic.
>
> cheers
> cla
>
>
> Quoting I am Who i am <ragjan@...>:
>
>> Is there anywhere any documenation for switching continuum database to
>> something different than the default one?/
>>
>> i want to have oracle db, is there any migration scritps, or anything
>>
>> If any one knows please let me know
>>
>
>
>
>

[Cla Monsch]

yes - that should work for 1.0.3. but in addition to this with 1.1
versions we had other problems:

INFO   | jvm 1    | 2007/08/08 14:05:04 | 2007-08-08 14:05:04,897
[WrapperSimpleAppMain] ERROR RDBMS                          - An
exception was thrown while adding/validating class(es)
ORA-00904: "CHECKOUT_RESULT_SCMRESULN2_OID": invalid identifier
INFO   | jvm 1    | 2007/08/08 14:05:04 | INFO   | jvm 1    |
2007/08/08 14:05:04 | java.sql.SQLException: ORA-00904:
"CHECKOUT_RESULT_SCMRESULN2_OID": invalid identifier


cheers cla


Quoting Emmanuel Venisse <emmanuel@...>:

> Actually, oracle db isn't supported due to some field lengths. A
> patch similar to the one for mssql can be done:
> http://svn.apache.org/repos/asf/maven/continuum/trunk/continuum-model/src/main/resources/package-mssql.orm
>
> Emmanuel
>
> Cla Monsch a écrit :
>> hi
>>
>> it's an unlovely story!
>>
>> with 1.0.3 it was possible to use an oracle db. there you had to
>> adjust some mappings within the package.jdo file in the jpox jar. we
>> also tried to switch the 1.1-alpha2 version to oracle but we gave it
>> up due to problems between jpox and oracle.
>>
>> i suspect there isn't any documentation about this topic.
>>
>> cheers
>> cla
>>
>>
>> Quoting I am Who i am <ragjan@...>:
>>
>>> Is there anywhere any documenation for switching continuum database to
>>> something different than the default one?/
>>>
>>> i want to have oracle db, is there any migration scritps, or anything
>>>
>>> If any one knows please let me know
>>>
>>
>>
>>
>>

[Emmanuel Venisse]

If you create a file similar to the mssql file with max length equals to 4000 (I think it's the limit for Oracle) it should work with 1.1

Emmanuel

Cla Monsch a écrit :

> yes - that should work for 1.0.3. but in addition to this with 1.1
> versions we had other problems:
>
> INFO   | jvm 1    | 2007/08/08 14:05:04 | 2007-08-08 14:05:04,897
> [WrapperSimpleAppMain] ERROR RDBMS                          - An
> exception was thrown while adding/validating class(es)
> ORA-00904: "CHECKOUT_RESULT_SCMRESULN2_OID": invalid identifier
> INFO   | jvm 1    | 2007/08/08 14:05:04 | INFO   | jvm 1    | 2007/08/08
> 14:05:04 | java.sql.SQLException: ORA-00904:
> "CHECKOUT_RESULT_SCMRESULN2_OID": invalid identifier
>
>
> cheers cla
>
>
> Quoting Emmanuel Venisse <emmanuel@...>:
>
>> Actually, oracle db isn't supported due to some field lengths. A patch
>> similar to the one for mssql can be done:
>> http://svn.apache.org/repos/asf/maven/continuum/trunk/continuum-model/src/main/resources/package-mssql.orm 
>>
>>
>> Emmanuel
>>
>> Cla Monsch a écrit :
>>> hi
>>>
>>> it's an unlovely story!
>>>
>>> with 1.0.3 it was possible to use an oracle db. there you had to
>>> adjust some mappings within the package.jdo file in the jpox jar. we
>>> also tried to switch the 1.1-alpha2 version to oracle but we gave it
>>> up due to problems between jpox and oracle.
>>>
>>> i suspect there isn't any documentation about this topic.
>>>
>>> cheers
>>> cla
>>>
>>>
>>> Quoting I am Who i am <ragjan@...>:
>>>
>>>> Is there anywhere any documenation for switching continuum database to
>>>> something different than the default one?/
>>>>
>>>> i want to have oracle db, is there any migration scritps, or anything
>>>>
>>>> If any one knows please let me know
>>>>
>>>
>>>
>>>
>>>
>
>
>
>

[Olivier34]

Hello,

You should have a look to the following ticket that show solutions about Continuum limitation about Oracle :
http://jira.codehaus.org/browse/CONTINUUM-1622

Hope it would be include in the next Continuum release...

Olivier.

Emmanuel Venisse wrote:

If you create a file similar to the mssql file with max length equals to 4000 (I think it's the limit for Oracle) it should work with 1.1

Emmanuel

Cla Monsch a écrit :
> yes - that should work for 1.0.3. but in addition to this with 1.1
> versions we had other problems:
>
> INFO   | jvm 1    | 2007/08/08 14:05:04 | 2007-08-08 14:05:04,897
> [WrapperSimpleAppMain] ERROR RDBMS                          - An
> exception was thrown while adding/validating class(es)
> ORA-00904: "CHECKOUT_RESULT_SCMRESULN2_OID": invalid identifier
> INFO   | jvm 1    | 2007/08/08 14:05:04 | INFO   | jvm 1    | 2007/08/08
> 14:05:04 | java.sql.SQLException: ORA-00904:
> "CHECKOUT_RESULT_SCMRESULN2_OID": invalid identifier
>
>
> cheers cla
>
>
> Quoting Emmanuel Venisse <[e-mail]>:
>
>> Actually, oracle db isn't supported due to some field lengths. A patch
>> similar to the one for mssql can be done:
>> http://svn.apache.org/repos/asf/maven/continuum/trunk/continuum-model/src/main/resources/package-mssql.orm 
>>
>>
>> Emmanuel
>>
>> Cla Monsch a écrit :
>>> hi
>>>
>>> it's an unlovely story!
>>>
>>> with 1.0.3 it was possible to use an oracle db. there you had to
>>> adjust some mappings within the package.jdo file in the jpox jar. we
>>> also tried to switch the 1.1-alpha2 version to oracle but we gave it
>>> up due to problems between jpox and oracle.
>>>
>>> i suspect there isn't any documentation about this topic.
>>>
>>> cheers
>>> cla
>>>
>>>
>>> Quoting I am Who i am <[e-mail]>:
>>>
>>>> Is there anywhere any documenation for switching continuum database to
>>>> something different than the default one?/
>>>>
>>>> i want to have oracle db, is there any migration scritps, or anything
>>>>
>>>> If any one knows please let me know
>>>>
>>>
>>>
>>>
>>>
>
>
>
>