MAILBOX-186 Delete index creation for MAILBOX_ID, MAIL_UID I deleted index creation annotation for MAILBOX_ID and MAIL_UID because it generate this SQL command: "CREATE INDEX INDEX_PROPERTY_MSG_ID ON JAMES_MAIL_PROPERTY (PROPERTY_ID)" instead of : "CREATE INDEX INDEX_PROPERTY_MSG_ID ON JAMES_MAIL_PROPERTY (MAILBOX_ID,MAIL_UID)" and because of PROPERTY_ID is primary key and indexed automatically then index creation generates error in Oracle database. I think this index creation annotation must move to table scope, not field scope.
Project: http://git-wip-us.apache.org/repos/asf/james-project/repo Commit: http://git-wip-us.apache.org/repos/asf/james-project/commit/e32c2cba Tree: http://git-wip-us.apache.org/repos/asf/james-project/tree/e32c2cba Diff: http://git-wip-us.apache.org/repos/asf/james-project/diff/e32c2cba Branch: refs/heads/master Commit: e32c2cba1e867fa340cab64f88f470d54cbddc4c Parents: 5d6a680 Author: mostafavtp <[email protected]> Authored: Wed Mar 28 13:01:01 2018 +0430 Committer: benwa <[email protected]> Committed: Thu Mar 29 16:45:04 2018 +0700 ---------------------------------------------------------------------- .../java/org/apache/james/mailbox/jpa/mail/model/JPAProperty.java | 3 --- 1 file changed, 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/james-project/blob/e32c2cba/mailbox/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/JPAProperty.java ---------------------------------------------------------------------- diff --git a/mailbox/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/JPAProperty.java b/mailbox/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/JPAProperty.java index f3930a9..67583f0 100644 --- a/mailbox/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/JPAProperty.java +++ b/mailbox/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/JPAProperty.java @@ -36,9 +36,6 @@ public class JPAProperty implements Property { @Id @GeneratedValue @Column(name = "PROPERTY_ID", nullable = true) - // TODO The columnNames are not interpreted, see OPENJPA-223 to fix - // MAILBOX-186 - @Index(name = "INDEX_PROPERTY_MSG_ID", columnNames = { "MAILBOX_ID", "MAIL_UID" }) private long id; /** Order within the list of properties */ --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
