[jbpm-issues] [JBoss JIRA] Commented: (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 Assignee: Joram Barrez Fix For: jBPM 4.2 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