constaint creation errors

60 r26928

With Sql Server 2008, db storage:

2009-05-12 12:18:07,280: ERROR [SchemaUpdate] - Unsuccessful: alter table jahia_sites_grps add constraint FK7B24559790F996AC foreign key (grpid_sites_grps) references jahia_grps (key_jahia_grps)
2009-05-12 12:18:07,283: ERROR [SchemaUpdate] - Column 'jahia_grps.key_jahia_grps' is not the same length or scale as referencing column 'jahia_sites_grps.grpid_sites_grps' in foreign key 'FK7B24559790F996AC'. Columns participating in a foreign key relationship must be defined with the same length and scale.
2009-05-12 12:18:07,286: ERROR [SchemaUpdate] - Unsuccessful: alter table jahia_sites_users add constraint FKEA2BF1BF6CF683C0 foreign key (userid_sites_users) references jahia_users (key_jahia_users)
2009-05-12 12:18:07,287: ERROR [SchemaUpdate] - Column 'jahia_users.key_jahia_users' is not the same length or scale as referencing column 'jahia_sites_users.userid_sites_users' in foreign key 'FKEA2BF1BF6CF683C0'. Columns participating in a foreign key relationship must be defined with the same length and scale.

With Orage 11g, db storage:

2009-05-12 11:19:50,436: ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]] SchemaUpdate, org.hibernate.tool.hbm2ddl.SchemaUpdate: Unsuccessful: alter table jahia_sites_grps add constraint FK7B24559790F996AC foreign key (grpid_sites_grps) references jahia_grps (key_jahia_grps)
2009-05-12 11:19:50,440: ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]] SchemaUpdate, org.hibernate.tool.hbm2ddl.SchemaUpdate: ORA-02275: une telle contrainte référentielle existe déjà dans la table
2009-05-12 11:19:50,454: ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]] SchemaUpdate, org.hibernate.tool.hbm2ddl.SchemaUpdate: Unsuccessful: alter table jahia_sites_users add constraint FKEA2BF1BF6CF683C0 foreign key (userid_sites_users) references jahia_users (key_jahia_users)
2009-05-12 11:19:50,457: ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]] SchemaUpdate, org.hibernate.tool.hbm2ddl.SchemaUpdate: ORA-02275: une telle contrainte référentielle existe déjà dans la table
2009-05-12 11:19:50,697: ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]] JDBCExceptionReporter, org.hibernate.util.JDBCExceptionReporter: ORA-02201: séquence non autorisée ici
2009-05-12 11:19:50,710: ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]] JDBCExceptionReporter, org.hibernate.util.JDBCExceptionReporter: ORA-00955: ce nom d'objet existe déjà