使用 Hibernate 在 CollectionTable 的列上创建索引

发布于 2024-10-06 22:38:36 字数 1220 浏览 3 评论 0原文

假设我有以下实体，它对订阅者进行建模并使用 CollectionTable 来对订阅列表进行建模，如下所示：

@Entity
@Table(name = "SUBSCRIBER")
public class Subscriber {
    @ElementCollection
    @CollectionTable(name = "PERSON_ORG_SUBSCRIPTIONS",
                     joinColumns = { @JoinColumn( name = "PERSON_ID", referencedColumnName = "PERSON_ID" ),
                                     @JoinColumn( name = "ORG_ID", referencedColumnName = "ORG_ID" ) } )
    @Column(name = "SUBSCRIPTION_NAME")
    protected Set<String> _subscriptionNames;
}

因此，这将创建一个包含 PERSON_ID、列的表ORG_ID 和 SUBSCRIPTION_NAME。

我正在尝试在 SUBSCRIPTION_NAME 列上创建数据库索引。但是，如果我在 _subscriptionNames 上添加以下注释：

@org.hibernate.annotations.Index( name="subscription_idx", columnNames={"SUBSCRIPTION_NAMES"} )

我会得到一个异常：

org.hibernate.MappingException: Unable to find logical column name from physical name null in table SUBSCRIBER

我还尝试在 Subscriber 上使用 org.hibernate.annotations.Table 注释code> 实体，但似乎没有办法让它引用 PERSON_ORG_SUBSCRIPTIONS 表。

我正在使用 Hibernate 3.5.3 和 PostgreSQL 9.0。

原文

Suppose I have the following entity which models a subscriber and uses a CollectionTable to model a list of subscriptions like so:

@Entity
@Table(name = "SUBSCRIBER")
public class Subscriber {
    @ElementCollection
    @CollectionTable(name = "PERSON_ORG_SUBSCRIPTIONS",
                     joinColumns = { @JoinColumn( name = "PERSON_ID", referencedColumnName = "PERSON_ID" ),
                                     @JoinColumn( name = "ORG_ID", referencedColumnName = "ORG_ID" ) } )
    @Column(name = "SUBSCRIPTION_NAME")
    protected Set<String> _subscriptionNames;
}

So this creates a table with columns for PERSON_ID, ORG_ID and SUBSCRIPTION_NAME.

I'm trying to create a database index on the SUBSCRIPTION_NAME column. But if I put the following annotation on _subscriptionNames:

@org.hibernate.annotations.Index( name="subscription_idx", columnNames={"SUBSCRIPTION_NAMES"} )

I get an exception:

org.hibernate.MappingException: Unable to find logical column name from physical name null in table SUBSCRIBER

I also tried using the org.hibernate.annotations.Table annotation on the Subscriber entity, but there does not seem to be a way to have it reference the PERSON_ORG_SUBSCRIPTIONS table.

I'm using Hibernate 3.5.3 and PostgreSQL 9.0.

分享到QQ

分享到微博