You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Ben Avery <be...@youthnet.org> on 2006/09/15 14:00:39 UTC
Oracle db scripts for 3.0
sorry if this has already been covered, or sent to the wrong place, just
trying to help.
the migration scripts need alteration to work, although the createdb.sql
script is fine.
the following changes need to be made:
- change datatype BIT to NUMBER(1)
- change syntax 'ADD COLUMN' to 'ADD'
and in the 240-to-300-migration.sql, the line
alter table weblogentry add locale varchar(20) default null;
is unnecessary, the column already exists, from Roller 2.10 at least.
this is tested on Oracle 9.2.10, although I believe it's also true of
Oracle 10.
otherwise looks great so far, good work :)
HTH
--
Ben Avery
Software Developer
Youthnet UK
email: ben.avery@youthnet.org
phone: 020 7288 7333
snail: 2-3 Upper Street
London N1 0PQ
Re: Oracle db scripts for 3.0
Posted by Ben Avery <be...@youthnet.org>.
Dave wrote:
> On 9/15/06, Ben Avery <be...@youthnet.org> wrote:
>> sorry if this has already been covered, or sent to the wrong place, just
>> trying to help.
>
> Thanks! We're flying blind with respect to Oracle since none of the
> Roller committers actually use that database.
>
no probs, I need it to work on Oracle, so happy to help this part along.
>
>> the following changes need to be made:
>> - change datatype BIT to NUMBER(1)
>> - change syntax 'ADD COLUMN' to 'ADD'
>
> Why the change from BIT to NUMBER(1) -- we use BIT in the database
> creation script too, do we need to change that too?
>
you actually use NUMBER(1) in the database creation script, not BIT.
Oracle doesn't have a BIT datatype.
>
>> and in the 240-to-300-migration.sql, the line
>> alter table weblogentry add locale varchar(20) default null;
>> is unnecessary, the column already exists, from Roller 2.10 at least.
>
> Does that cause an error or does Oracle ignore it and continue to
> process the migration script?
>
It does give you an error, but doesn't do any harm, and carries on with
the rest of the migration script.
> - Dave
>
>
>
>>
>> this is tested on Oracle 9.2.10, although I believe it's also true of
>> Oracle 10.
--
Ben Avery
Software Developer
Youthnet UK
email: ben.avery@youthnet.org
phone: 020 7288 7333
snail: 2-3 Upper Street
London N1 0PQ
Re: Oracle db scripts for 3.0
Posted by Dave <sn...@gmail.com>.
On 9/15/06, Ben Avery <be...@youthnet.org> wrote:
> sorry if this has already been covered, or sent to the wrong place, just
> trying to help.
Thanks! We're flying blind with respect to Oracle since none of the
Roller committers actually use that database.
> the following changes need to be made:
> - change datatype BIT to NUMBER(1)
> - change syntax 'ADD COLUMN' to 'ADD'
Why the change from BIT to NUMBER(1) -- we use BIT in the database
creation script too, do we need to change that too?
> and in the 240-to-300-migration.sql, the line
> alter table weblogentry add locale varchar(20) default null;
> is unnecessary, the column already exists, from Roller 2.10 at least.
Does that cause an error or does Oracle ignore it and continue to
process the migration script?
- Dave
>
> this is tested on Oracle 9.2.10, although I believe it's also true of
> Oracle 10.
RE: Oracle db scripts for 3.0
Posted by Er...@sanofipasteur.com.
Hi Ben,
I've no time right now to check for the Oracle version, but i'm interested by that :
Could you check that the template creation is now possible? (it was not in 2.3 due to a not nullable column in the webpages table).
Regards
Eric
-----Message d'origine-----
De : Ben Avery [mailto:ben.avery@youthnet.org]
Envoyé : vendredi 15 septembre 2006 14:01
À : roller-dev@incubator.apache.org
Objet : Oracle db scripts for 3.0
sorry if this has already been covered, or sent to the wrong place, just trying to help.
the migration scripts need alteration to work, although the createdb.sql script is fine.
the following changes need to be made:
- change datatype BIT to NUMBER(1)
- change syntax 'ADD COLUMN' to 'ADD'
and in the 240-to-300-migration.sql, the line
alter table weblogentry add locale varchar(20) default null; is unnecessary, the column already exists, from Roller 2.10 at least.
this is tested on Oracle 9.2.10, although I believe it's also true of Oracle 10.
otherwise looks great so far, good work :)
HTH
--
Ben Avery
Software Developer
Youthnet UK
email: ben.avery@youthnet.org
phone: 020 7288 7333
snail: 2-3 Upper Street
London N1 0PQ
-------------------------------------------------------------------------------------------
"Cette communication (y compris les pieces jointes) est reservee a l'usage exclusif du destinataire (des destinataires) et peut contenir des informations privilegiees, confidentielles, exemptees de divulgation selon la loi ou protegees par les droits d'auteur. Si vous n'etes pas un destinataire, toute utilisation, divulgation, distribution, reproduction, examen ou copie (totale ou partielle) est non-autorisee et peut etre illegale. Tout message electronique est susceptible d'alteration et son integrite ne peut etre assuree. Sanofi Pasteur decline toute responsabilite au titre de ce message s'il a ete modifie ou falsifie. Si vous n'etes pas destinataire de ce message, merci de le detruire immediatement et d'avertir l'expediteur de l'erreur de distribution et de la destruction du message. Merci.
This transmission (including any attachments) is intended solely for the use of the addressee(s) and may contain confidential information including trade secrets which are privileged, confidential, exempt from disclosure under applicable law and/or subject to copyright. If you are not an intended recipient, any use, disclosure, distribution, reproduction, review or copying (either whole or partial) is unauthorized and may be unlawful. E-mails are susceptible to alteration and their integrity cannot be guaranteed.Sanofi Pasteur shall not be liable for this e-mail if modified or falsified. If you are not the intended recipient of this e-mail, please delete it immediately from your system and notify the sender of the wrong delivery and the mail deletion. Thank you."
**********************************************************************