[jboss-jira] [JBoss JIRA] Updated: (JBPORTAL-1196) Invalid table creation script with Oracle 9i

[Julien Viet (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBPORTAL-1196?page=all ]

Julien Viet updated JBPORTAL-1196:
----------------------------------

        Fix Version/s: 2.6.Beta1
                       2.4.2 Final
    Affects Version/s: 2.4.1 SP1
                       2.4.1 Final

> Invalid table creation script with Oracle 9i
> --------------------------------------------
>
>                 Key: JBPORTAL-1196
>                 URL: http://jira.jboss.com/jira/browse/JBPORTAL-1196
>             Project: JBoss Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Portal Core
>    Affects Versions: 2.4.1 Final, 2.6.Alpha1, 2.4.1 SP1
>         Environment: As 4.0.5.GA on XP
> Oracle 9.2.0.1.0 on remote server - using thin jdbc connection url
>            Reporter: Ian White
>         Assigned To: Julien Viet
>             Fix For: 2.6.Beta1, 2.4.2 Final
>
>
> The following creation script gets generated by Hibernate:
>     create table JBP_OBJECT_NODE (
>         PK number(19,0) not null, 
>         PATH varchar2(255 char) unique, 
>         NAME varchar2(255 char), 
>         PARENT_KEY number(19,0), 
>         primary key (PK), unique (PATH)
>     )
> Oracle does not like the unique keyword being used twice with PATH.
> The hibernate mapping is in jboss-portal.sar/conf/hibernate/portal/domain.hbm.xml.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira