Re: continuum with oracle

[Olivier34 <ny...@sneakemail.com>]

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 <em...@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 <ra...@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
>>>>>
>>>>
>>>>
>>>>
>>>>
>> 
>> 
>> 
>> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/continuum-with-oracle-tp12956486p16093577.html
Sent from the Continuum - Users mailing list archive at Nabble.com.