Re: continuum with oracle

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 <emmanuel@venisse.net>:
>
>> 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@gmail.com>:
>>>
>>>> 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
>>>>
>>>
>>>
>>>
>>>
>
>
>
>