开发者

Issue Using Hibernate Criteria object with composite key

开发者 https://www.devze.com 2022-12-09 01:43 出处：网络
NOTE:I have changed the details provided due to comments provided.The new technical details are actually code that I am trying to run currently.
相关专题：jpa

NOTE: I have changed the details provided due to comments provided. The new technical details are actually code that I am trying to run currently.

I have a weird problem going on currently with one of my OneToMany / ManyToOne bidirectional relationships.

In the parent table I have a long which is the identifier and the child also has that column in addition to another field, which makes up its composite key.

In my sample data that I'm querying I have 1 parent record and 3 related records in the child table. Currently when I use the criteria object to query the table I get back 3 parent (CoPolicyPointer) records, 2 of which don't have the associated child (CoTransactionSummary) table linked and then a third that is populated properly. I would have expected to only get a single result back and that is why I am confused. Do you have any ideas why this is occuring?

I have provided more technical data below.

Parent Table (CoPolicyPointer)
Column            Data Type
SystemAssignId    String               (Primary Key)
PolicyPrefixCd    String
PolicyId          String
PolicySeqNo       int




Child Table (CoTransaction Summary)
Column            Data Type
SystemAssignId    String                  (composite key)
TransSeqId        int                     (composite key)
TransType  varchar(4)

The Criteria statement looks like the following:

Criteria criteria = session.createCriteria(classToUse);
criteria.createAlias("coTransactionSummaries", "ts");
criteria.add(Restrictions.ne("ts.transInProcessCd", "VIEW"));
criteria.add(Restrictions.gt("ts.transSeqId", Short.valueOf("0")));
criteria.add(Restrictions.eq(BaseCoPolicyPointer.COL_POLICY_PREFIX_CD,
            policyNumber.getPrefix().getLiteral()));
criteria.add(Restrictions.eq(BaseCoPolicyPointer.COL_POLICY_ID,
            policyNumber.getId()));

The Parent class looks like:

@Entity(name = "CoPolicyPointer")
public class CoPolicyPointerRedo {
private static final String CLASS_NAME = CoPolicyPointerRedo.class
        .getName();
private static final Logger logger = Logger.getLogger(CLASS_NAME);

private String systemAssignId;
private String policyPrefixCd;
private String policyId;
private String policyNumber;
private Short policySeqNo;
private Set coTransactionSummaries;

@Id
public String getSystemAssignId() {
    return systemAssignId;
}

public void setSystemAssignId(String systemAssignId) {
    this.systemAssignId = systemAssignId;
}

@Column
public String getPolicyId() {
    return policyId;
}

public void setPolicyId(String policyId) {
    this.policyId = policyId;
}

@Column
public String getPolicyPrefixCd() {
    return policyPrefixCd;
}

public void setPolicyPrefixCd(String policyPrefixCd) {
    this.policyPrefixCd = policyPrefixCd;
}

@Column
public Short getPolicySeqNo() {
    return policySeqNo;
}

public void setPolicySeqNo(Short policySeqNo) {
    this.policySeqNo = policySeqNo;
}


@OneToMany(targetEntity = CoTransactionSummaryRedo.class, mappedBy = "coPolicyPointer")
public Set getCoTransactionSummaries() {
    return coTransactionSummaries;
}

public void setCoTransactionSummaries(Set coTransactionSummaries) {
    this.coTransactionSummaries = coTransactionSummaries;
}

}

The child class looks like:

@Entity(name = "CoTransactionSummary")
public class CoTransactionSummaryRedo {
private static final String CLASS_NAME = CoTransactionSummaryRedo.class
        .getName();
private static final Logger logger = Logger.getLogger(CLASS_NAME);

private String transTypeCd;
private String transInProcessCd;
private CoPolicyPointerRedo coPolicyPointer;

private CoTransactionSummaryIdRedo id;

@EmbeddedId
public CoTransactionSummaryIdRedo getId() {
    return id;
}

public void setId(CoTransactionSummaryIdRedo id) {
    this.id = id;
}

@Column
public String getTransInProcessCd() {
    return transInProcessCd;
}

public void setTransInProcessCd(String transInProcessCd) {
    this.transInProcessCd = transInProcessCd;
}

@Column
public String getTransTypeCd() {
    return transTypeCd;
}

public void setTransTypeCd(String transTypeCd) {
    this.transTypeCd = transTypeCd;
}

@ManyToOne()
@JoinColumn(name = "systemAssignId", insertable = false, updatable = false)
public CoPolicyPointerRedo getCoPolicyPointer() {
    return coPolicyPointer;
}

public void setCoPolicyPointer(CoPolicyPointerRedo coPolicyPointer) {
    this.coPolicyPointer = coPolicyPointer;
}


}

The child class's ID class looks like:

@Embeddable
public class CoTransactionSummaryIdRedo implements java.io.Serializable {

private String systemAssignId;
private short transSeqId;

public CoTransactionSummaryIdRedo() {
}

public CoTransactionSummaryIdRedo(String systemAssignId, short transSeqId) {
    this.systemAssignId = systemAssignId;
    this.transSeqId = transSeqId;
}

@Column
public String getSystemAssignId() {
    return systemAssignId;
}

public void setSystemAssignId(String systemAssignId) {
    this.systemAssignId = systemAssignId;
}

@Column
public short getTransSeqId() {
    return transSeqId;
}

public void setTransSeqId(short transSeqId) {
    this.transSeqId = transSeqId;
}

@Override
public boolean equals(Object other) {
    if ((this == other))
        return true;
    if ((other == null))
        return false;
    if (!(other instanceof CoTransactionSummaryIdRedo))
        return false;
    CoTransactionSummaryIdRedo castOther = (CoTransactionSummaryIdRedo) other;

    return ((this.getSystemAssignId() == castOther.getSystemAssignId()) || (this
            .getSystemAssignId() != null
            && castOther.getSystemAssignId() != null && this
            .getSystemAssignId().equals(castOther.getSystemAssignId())))
            && (this.getTransSeqId() == castOther.getTransSeqId());
}

@Override
public int hashCode() {
    int result = 17;

    result = 37
            * result
            + (getSystemAssignId() == null ? 0 : this.getSystemAssignId()
                    .hashCode());
    result = 37 * result + this.getTransSeqId();
    return result;
}

}

I've got logging turned on TRACE and here is what is being generated.

08:20:47,907 DEBUG SQL:111 - select this_.systemAssignId as systemAs1_1_2_, this_.policyId as poli开发者_JS百科cyId1_2_, this_.policyPrefixCd as policyPr3_1_2_, this_.policySeqNo as policySe4_1_2_, ts1_.systemAssignId as systemAs1_0_0_, ts1_.transSeqId as transSeqId0_0_, ts1_.transInProcessCd as transInP3_0_0_, ts1_.transTypeCd as transTyp4_0_0_, copolicypo4_.systemAssignId as systemAs1_1_1_, copolicypo4_.policyId as policyId1_1_, copolicypo4_.policyPrefixCd as policyPr3_1_1_, copolicypo4_.policySeqNo as policySe4_1_1_ from CoPolicyPointer this_ inner join CoTransactionSummary ts1_ on this_.systemAssignId=ts1_.systemAssignId left outer join CoPolicyPointer copolicypo4_ on ts1_.systemAssignId=copolicypo4_.systemAssignId where this_.policyPrefixCd=? and this_.policyId=? and this_.policySeqNo=?
Hibernate: select this_.systemAssignId as systemAs1_1_2_, this_.policyId as policyId1_2_, this_.policyPrefixCd as policyPr3_1_2_, this_.policySeqNo as policySe4_1_2_, ts1_.systemAssignId as systemAs1_0_0_, ts1_.transSeqId as transSeqId0_0_, ts1_.transInProcessCd as transInP3_0_0_, ts1_.transTypeCd as transTyp4_0_0_, copolicypo4_.systemAssignId as systemAs1_1_1_, copolicypo4_.policyId as policyId1_1_, copolicypo4_.policyPrefixCd as policyPr3_1_1_, copolicypo4_.policySeqNo as policySe4_1_1_ from CoPolicyPointer this_ inner join CoTransactionSummary ts1_ on this_.systemAssignId=ts1_.systemAssignId left outer join CoPolicyPointer copolicypo4_ on ts1_.systemAssignId=copolicypo4_.systemAssignId where this_.policyPrefixCd=? and this_.policyId=? and this_.policySeqNo=?
19:14:30,938 DEBUG AbstractBatcher:513 - preparing statement
19:14:30,969 DEBUG StringType:151 - binding 'WA' to parameter: 1
19:14:30,969 DEBUG StringType:151 - binding '0100036449' to parameter: 2
19:14:30,969 DEBUG ShortType:151 - binding '0' to parameter: 3
19:14:30,969 DEBUG AbstractBatcher:426 - about to open ResultSet (open ResultSets: 0, globally: 0)
19:14:30,969 DEBUG Loader:717 - processing result set
19:14:30,969 DEBUG Loader:722 - result set row: 0
19:14:30,969 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_0_0_
19:14:30,969 DEBUG ShortType:193 - returning '0' as column: transSeqId0_0_
19:14:30,969 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_1_1_
19:14:30,969 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_1_2_
19:14:30,969 DEBUG Loader:1197 - result row: EntityKey[CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=0, systemAssignId=00502000000000}], EntityKey[CoPolicyPointerRedo#00502000000000], EntityKey[CoPolicyPointerRedo#00502000000000]
19:14:30,969 DEBUG Loader:1379 - Initializing object from ResultSet: [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=0, systemAssignId=00502000000000}]
19:14:30,969 DEBUG AbstractEntityPersister:2059 - Hydrating entity: [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=0, systemAssignId=00502000000000}]
19:14:30,969 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_0_0_
19:14:30,969 DEBUG StringType:193 - returning 'PCNM' as column: transInP3_0_0_
19:14:30,969 DEBUG StringType:193 - returning 'PCNM' as column: transTyp4_0_0_
19:14:30,969 DEBUG Loader:1379 - Initializing object from ResultSet: [CoPolicyPointerRedo#00502000000000]
19:14:30,969 DEBUG AbstractEntityPersister:2059 - Hydrating entity: [CoPolicyPointerRedo#00502000000000]
19:14:30,985 DEBUG StringType:193 - returning '0100036449          ' as column: policyId1_1_
19:14:30,985 DEBUG StringType:193 - returning 'WA    ' as column: policyPr3_1_1_
19:14:30,985 DEBUG ShortType:193 - returning '0' as column: policySe4_1_1_
19:14:30,985 DEBUG Loader:722 - result set row: 1
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_0_0_
19:14:30,985 DEBUG ShortType:193 - returning '1' as column: transSeqId0_0_
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_1_1_
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_1_2_
19:14:30,985 DEBUG Loader:1197 - result row: EntityKey[CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=1, systemAssignId=00502000000000}], EntityKey[CoPolicyPointerRedo#00502000000000], EntityKey[CoPolicyPointerRedo#00502000000000]
19:14:30,985 DEBUG Loader:1379 - Initializing object from ResultSet: [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=1, systemAssignId=00502000000000}]
19:14:30,985 DEBUG AbstractEntityPersister:2059 - Hydrating entity: [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=1, systemAssignId=00502000000000}]
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_0_0_
19:14:30,985 DEBUG StringType:193 - returning 'PCNM' as column: transInP3_0_0_
19:14:30,985 DEBUG StringType:193 - returning 'PCNM' as column: transTyp4_0_0_
19:14:30,985 DEBUG Loader:722 - result set row: 2
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_0_0_
19:14:30,985 DEBUG ShortType:193 - returning '5' as column: transSeqId0_0_
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_1_1_
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_1_2_
19:14:30,985 DEBUG Loader:1197 - result row: EntityKey[CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=5, systemAssignId=00502000000000}], EntityKey[CoPolicyPointerRedo#00502000000000], EntityKey[CoPolicyPointerRedo#00502000000000]
19:14:30,985 DEBUG Loader:1379 - Initializing object from ResultSet: [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=5, systemAssignId=00502000000000}]
19:14:30,985 DEBUG AbstractEntityPersister:2059 - Hydrating entity: [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=5, systemAssignId=00502000000000}]
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_0_0_
19:14:30,985 DEBUG StringType:193 - returning 'PCNM' as column: transInP3_0_0_
19:14:30,985 DEBUG StringType:193 - returning 'PCNM' as column: transTyp4_0_0_
19:14:30,985 DEBUG Loader:722 - result set row: 3
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_0_0_
19:14:30,985 DEBUG ShortType:193 - returning '6' as column: transSeqId0_0_
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_1_1_
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_1_2_
19:14:30,985 DEBUG Loader:1197 - result row: EntityKey[CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=6, systemAssignId=00502000000000}], EntityKey[CoPolicyPointerRedo#00502000000000], EntityKey[CoPolicyPointerRedo#00502000000000]
19:14:30,985 DEBUG Loader:1379 - Initializing object from ResultSet: [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=6, systemAssignId=00502000000000}]
19:14:30,985 DEBUG AbstractEntityPersister:2059 - Hydrating entity: [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=6, systemAssignId=00502000000000}]
19:14:30,985 DEBUG StringType:193 - returning '00502000000000' as column: systemAs1_0_0_
19:14:30,985 DEBUG StringType:193 - returning 'PCNM' as column: transInP3_0_0_
19:14:30,985 DEBUG StringType:193 - returning 'PCNM' as column: transTyp4_0_0_
19:14:30,985 DEBUG Loader:744 - done processing result set (4 rows)
19:14:30,985 DEBUG AbstractBatcher:433 - about to close ResultSet (open ResultSets: 1, globally: 1)
19:14:30,985 DEBUG AbstractBatcher:418 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
19:14:30,985 DEBUG AbstractBatcher:562 - closing statement
19:14:30,985 DEBUG ConnectionManager:427 - aggressively releasing JDBC connection
19:14:30,985 DEBUG ConnectionManager:464 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
19:14:30,985 DEBUG DriverManagerConnectionProvider:152 - returning connection to pool, pool size: 1
19:14:30,985 DEBUG Loader:874 - total objects hydrated: 5
19:14:30,985 DEBUG TwoPhaseLoad:130 - resolving associations for [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=0, systemAssignId=00502000000000}]
19:14:30,985 DEBUG DefaultLoadEventListener:199 - loading entity: [CoPolicyPointerRedo#00502000000000]
19:14:30,985 DEBUG DefaultLoadEventListener:372 - attempting to resolve: [CoPolicyPointerRedo#00502000000000]
19:14:30,985 DEBUG DefaultLoadEventListener:389 - resolved object in session cache: [CoPolicyPointerRedo#00502000000000]
19:14:30,985 DEBUG TwoPhaseLoad:226 - done materializing entity [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=0, systemAssignId=00502000000000}]
19:14:30,985 DEBUG TwoPhaseLoad:130 - resolving associations for [CoPolicyPointerRedo#00502000000000]
19:14:30,985 DEBUG LoadContexts:218 - creating collection wrapper:[CoPolicyPointerRedo.coTransactionSummaries#00502000000000]
19:14:31,047 DEBUG TwoPhaseLoad:226 - done materializing entity [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG TwoPhaseLoad:130 - resolving associations for [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=1, systemAssignId=00502000000000}]
19:14:31,047 DEBUG DefaultLoadEventListener:199 - loading entity: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG DefaultLoadEventListener:372 - attempting to resolve: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG DefaultLoadEventListener:389 - resolved object in session cache: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG TwoPhaseLoad:226 - done materializing entity [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=1, systemAssignId=00502000000000}]
19:14:31,047 DEBUG TwoPhaseLoad:130 - resolving associations for [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=5, systemAssignId=00502000000000}]
19:14:31,047 DEBUG DefaultLoadEventListener:199 - loading entity: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG DefaultLoadEventListener:372 - attempting to resolve: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG DefaultLoadEventListener:389 - resolved object in session cache: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG TwoPhaseLoad:226 - done materializing entity [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=5, systemAssignId=00502000000000}]
19:14:31,047 DEBUG TwoPhaseLoad:130 - resolving associations for [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=6, systemAssignId=00502000000000}]
19:14:31,047 DEBUG DefaultLoadEventListener:199 - loading entity: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG DefaultLoadEventListener:372 - attempting to resolve: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG DefaultLoadEventListener:389 - resolved object in session cache: [CoPolicyPointerRedo#00502000000000]
19:14:31,047 DEBUG TwoPhaseLoad:226 - done materializing entity [CoTransactionSummaryRedo#component[systemAssignId,transSeqId]{transSeqId=6, systemAssignId=00502000000000}]
19:14:31,047 DEBUG StatefulPersistenceContext:860 - initializing non-lazy collections
19:14:31,047 DEBUG JDBCContext:260 - after autocommit
19:14:31,047 DEBUG ConnectionManager:427 - aggressively releasing JDBC connection
19:14:31,047 DEBUG SessionImpl:449 - after transaction completion

The mapping you've posted and the description you provided conflict with each other:

  1. Mapping join column on inverse association as non-insertable/updatable is not going to work. How is that column going to be updated (and your parent-child association maintained)?
  2. Your child mapping defines Child's PK as childId (using @Id annotation). That's NOT how a composite key is mapped; Hibernate will consider childId to be a simple primary key.
  3. Your criteria doesn't match your mapping (ParentTable vs Parent, etc...) which is probably a conversion artifact, but other then that looks OK.

I'd use aliases, though:

Criteria criteria = session.createCriteria(Parent.class)
 .add(Restrictions.eq("policyNo", "1234"))
 .createAlias("child", "children")
 .add(Restrictions.ne("children.transType", "VIEW"));

Update (based on criteria / generated SQL):

Take a look at the SQL generated by Hibernate based on your criteria (shortened for readability):

SELECT this_.*, ts1_.*, copolicypo4_.*
  FROM CoPolicyPointer this_
 INNER JOIN CoTransactionSummary ts1_ ON this_.systemAssignId=ts1_.systemAssignId
  LEFT JOIN CoPolicyPointer copolicypo4_ ON ts1_.systemAssignId=copolicypo4_.systemAssignId

You'll notice that your "parent" table (CoPolicyPointer) is joined twice even though your criteria only joins the "children" table. That happens because you're specifying entity names in @Entity annotations but creating your criteria using original class name, making Hibernate think you're joining three separate entities:

  1. Criteria is based on CoPolicyPointerRedo.class
  2. It joins to CoTransactionSummaryRedo.class whose entity name is CoTransactionSummary
  3. Which joins back to CoPolicyPointerRedo.class as ``CoPolicyPointerusing@ManyToOne`

You need to be consistent with naming. Either remove name from @Entity declarations (you can use @Table instead to specify table name) or create your criteria using session.createCriteria(String entityName) method which takes entity name rather than class name as parameter.

0

上一篇:

:下一篇

更多 问答 相关资讯：

精彩评论

暂无评论...
登录 注册
Qedev.com
验证码 换一张
取 消

    关注公众号

    热门标签

    图文推荐

    Delphi - Custom drawing a message list

    Delphi - Custom drawing a message list
    C++ header-only include pattern

    C++ header-only include pattern
    IE7 Margin Collapses Into Padding

    IE7 Margin Collapses Into Padding
    in CoffeeScript, how can I use a variable as a key in a hash?

    in CoffeeScript, how can I use a variable as a key in a hash?
    Interactive visualization of a graph in python [closed]

    Interactive visualization of a graph in python [closed]
    How to customise PHP MYSQL tables?

    How to customise PHP MYSQL tables?
    High quality, simple random password generator

    High quality, simple random password generator
    Image Recognition ApI in android

    Image Recognition ApI in android

    开发者开发者网给大家分享系统运维,大数据运维,云计算,编程开发技巧,路由交换,运维和开发相关的资讯及技术文章，同时StackOverflow中文社区，知识经验交流分享。

    法律声明：本站内容均为网友上传，网站举办方负责审核和监督，如存在版权或非法内容，欢迎举报，我们将尽快予以删除。邮箱：devze@qq.com

    Copyright © 2018-2020 开发者. All rights reserved. Powered by 开发者ICP备案号: 京ICP备10032868号-9