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

[Ian White (JIRA)]

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.6.Alpha1
         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


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