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