[jbpm-issues] [JBoss JIRA] Created: (JBPM-2477) Problems with indexes in jbpm.history.hbm.xml

Problems with indexes in jbpm.history.hbm.xml --------------------------------------------- Key: JBPM-2477 URL: https://jira.jboss.org/jira/browse/JBPM-2477 Project: jBPM Issue Type: Feature Request Security Level: Public (Everyone can see) Affects Versions: jBPM 4.0 Environment: Ubuntu 9.04 Oracle JDBC Driver version - "11.1.0.6.0-Production+" Java(TM) SE Runtime Environment (build 1.6.0_14-b08) Oracle Database 10g Express Edition Release 10.2.0.1.0 Reporter: Michael Wohlfart problem with indexes already indexed when running jbpm.oracle.create.sql: create.jbpm.schema: [sql] Executing resource: C:\SEAM\jbpm-4.0\db\schema.scripts\jbpm.oracle.create.sql [sql] Failed to execute: create index IDX_HDETAIL_HACTI on JBPM4_HIST_DETAIL (HACTI_) [sql] java.sql.SQLException: ORA-01408: such column list already indexed [sql] Failed to execute: create index IDX_HDETAIL_HPROCI on JBPM4_HIST_DETAIL (HPROCI_) [sql] java.sql.SQLException: ORA-01408: such column list already indexed [sql] Failed to execute: create index IDX_HDET_HVAR on JBPM4_HIST_DETAIL (HVAR_) [sql] java.sql.SQLException: ORA-01408: such column list already indexed [sql] Failed to execute: create index IDX_HDET_HTASK on JBPM4_HIST_DETAIL (HTASK_) [sql] java.sql.SQLException: ORA-01408: such column list already indexed [sql] 76 of 80 SQL statements executed successfully -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira