Hibernate Query by Example

[yusuf nazir]

Hi All,
I'm stuck with a problem.
I want to use Hibernate Query by Example but am getting a problem with my result.
I'm querying over two tables, a parent-child situation.

I have a class called CheckSum and a class called Record.
CheckSum has a set of Record.
When i execute the query, the resultset of CheckSum is equal to all the resultset of Record.
I'm not getting a parent-child resultset.

Thus is CheckSum has {chk01,chk02,chk03}
chk01 has {rec01,rec02}
chk02 has {rec03,rec04,rec05}
chk03 has {rec06,rec07,rec08}

if I query chk02 and all his record I get a list of 3 CheckSum and in all those 3 the same amount of record is repeated.

How does query by example work with joins???

thanks in advance.

[Paul Sturrock]

Does Record have a primary key?

[yusuf nazir]

Hi Paul,

Record does have a primary key and so does checksum

This is the record class:

    
package sr.dsb.oos.service.parser;

import java.text.SimpleDateFormat;
import java.util.Date;

public class Record {
	
	private static final String DEFAULT_BANK="DSB";
	private static final Long DEFAULT_CURRENCY = new Long(968);

	private int id;
	private int clientId;
	private String clientName;
	private String client;
	private Long clientAccountNumber;
	private String sign;
	private String description1;
	private String description2;
	private String description3;
	private Double amount;
	private String beneficiaryBank = DEFAULT_BANK;
	private Integer beneficiaryBankNumber;
	private Long beneficiaryAccountNumber;
	private String beneficiaryName;
	private Long currency = DEFAULT_CURRENCY;
	private String dsbBankCode;
	private String clientBankCode;
	private String checkSum;
	private String dateProcessed = (new SimpleDateFormat("yyyy-MM-dd").format(new Date()));
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public int getClientId() {
		return clientId;
	}
	public void setClientId(int clientId) {
		this.clientId = clientId;
	}
	public String getClientName() {
		return clientName;
	}
	public void setClientName(String clientName) {
		this.clientName = clientName;
	}
	public String getClient() {
		return client;
	}
	public void setClient(String client) {
		this.client = client;
	}
	public Long getClientAccountNumber() {
		return clientAccountNumber;
	}
	public void setClientAccountNumber(Long clientAccountNumber) {
		this.clientAccountNumber = clientAccountNumber;
	}
	public String getSign() {
		return sign;
	}
	public void setSign(String sign) {
		this.sign = sign;
	}
	public String getDescription1() {
		return description1;
	}
	public void setDescription1(String description1) {
		this.description1 = description1;
	}
	public String getDescription2() {
		return description2;
	}
	public void setDescription2(String description2) {
		this.description2 = description2;
	}
	public String getDescription3() {
		return description3;
	}
	public void setDescription3(String description3) {
		this.description3 = description3;
	}
	public Double getAmount() {
		return amount;
	}
	public void setAmount(Double amount) {
		this.amount = amount;
	}
	public String getBeneficiaryBank() {
		return beneficiaryBank;
	}
	public void setBeneficiaryBank(String beneficiaryBank) {
		this.beneficiaryBank = beneficiaryBank;
	}
	public Integer getBeneficiaryBankNumber() {
		return beneficiaryBankNumber;
	}
	public void setBeneficiaryBankNumber(Integer beneficiaryBankNumber) {
		this.beneficiaryBankNumber = beneficiaryBankNumber;
	}
	public Long getBeneficiaryAccountNumber() {
		return beneficiaryAccountNumber;
	}
	public void setBeneficiaryAccountNumber(Long beneficiaryAccountNumber) {
		this.beneficiaryAccountNumber = beneficiaryAccountNumber;
	}
	public String getBeneficiaryName() {
		return beneficiaryName;
	}
	public void setBeneficiaryName(String beneficiaryName) {
		this.beneficiaryName = beneficiaryName;
	}
	public Long getCurrency() {
		return currency;
	}
	public void setCurrency(Long currency) {
		this.currency = currency;
	}
	public String getDsbBankCode() {
		return dsbBankCode;
	}
	public void setDsbBankCode(String dsbBankCode) {
		this.dsbBankCode = dsbBankCode;
	}
	public String getClientBankCode() {
		return clientBankCode;
	}
	public void setClientBankCode(String clientBankCode) {
		this.clientBankCode = clientBankCode;
	}
	public String getCheckSum() {
		return checkSum;
	}
	public void setCheckSum(String checkSum) {
		this.checkSum = checkSum;
	}
	public String getDateProcessed() {
		return dateProcessed;
	}
	public void setDateProcessed(String dateProcessed) {
		this.dateProcessed = dateProcessed;
	}
}

this is the hibernate record mapping:

    
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="sr.dsb.oos.service.parser">
	<class name="Record" table="Record">
		<id name="id" type="integer">
			<column name="ID" />
			<generator class="increment" />
		</id>
		<property name="checkSum" column="checksum_id"/>
		<property name="clientId" column="opdrachtgever_id"/>
		<property name="clientName" column="klantNaam" />
		<property name="clientAccountNumber" column="klantRekeningNummer" />
		<property name="sign" column="teken" />
		<property name="description1" column="omschrijving1"/>
		<property name="description2" column="omschrijving2"/>
		<property name="description3" column="omschrijving3"/>
		<property name="amount" column="bedrag" />
		<property name="beneficiaryBank" column="banknaam" />
		<property name="beneficiaryBankNumber" column="banknummer" />
		<property name="beneficiaryAccountNumber" column="rekeningnummer" />
		<property name="beneficiaryName" column="naam" />
		<property name="currency" column="valuta" />
		<property name="dateProcessed" column="datumvanverwerking"></property>
	</class>
</hibernate-mapping>

This is the checksum class:

    
package sr.dsb.oos.domain;

import java.util.HashSet;
import java.util.Set;

import sr.dsb.oos.service.parser.Record;

public class CheckSum {
	
	private String date;
	private String checkSum;
	private Integer checkSumId;
	private Integer clientId;
	private Set<Record> records;
	
	public String getCheckSum() {
		return checkSum;
	}
	public void setCheckSum(String checkSum) {
		this.checkSum = checkSum;
	}
	public Integer getCheckSumId() {
		return checkSumId;
	}
	public void setCheckSumId(Integer checkSumId) {
		this.checkSumId = checkSumId;
	}
	public Set<Record> getRecords() {
		return records;
	}
	public void setRecords(Set<Record> records) {
		this.records = records;
	}
	
	public void addRecord(Record record){
		if(this.records==null){
			this.records = new HashSet<Record>();
		}
		this.records.add(record);
	}
	public String getDate() {
		return date;
	}
	public void setDate(String date) {
		this.date = date;
	}
	public Integer getClientId() {
		return clientId;
	}
	public void setClientId(Integer clientId) {
		this.clientId = clientId;
	}
	

}

this is the checksum hibernate mapping:

    
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="sr.dsb.oos.domain">

	<class name="CheckSum" table="checksum">
	
		<id name="checkSumId" type="integer">
			<column name="checksum_id" />
			<generator class="increment" />
		</id>
		
		<property name="date" column="datum" />
		<property name="checkSum" />
		<property name="clientId" column="opdrachtgever_id"></property>
  		
<!-- toegevoegd 20090519 -->
		<set name="records" cascade="all">
			<key column="checksum_id"/>
			<one-to-many class="sr.dsb.oos.service.parser.Record"/>
		</set>
<!-- 20090519 -->		

	</class>
</hibernate-mapping>