Re: continuum with oracle
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 <[EMAIL PROTECTED]>: 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 <[EMAIL PROTECTED]>: 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
Re: continuum with oracle
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 <[EMAIL PROTECTED]>: 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
Re: continuum with oracle
On 9/29/07, I am Who i am <[EMAIL PROTECTED]> 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
continuum with oracle
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