I am using "component" to map some of the columns to an aggregated class. The mapping is done with annotation and works fine with loadAll. However the find failed with the following error. Can anyone give me any direction for the troubleshooting? Thanks.

2008-11-20 20:20:50,109 - c.e.c.d.ContractDao [main] [ERROR]: find by property name failed
org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: contracttag of: com.eclipseoptions.eodata.persistence.instrument.Instrument [from com.eclipseoptions.eodata.persistence.instrument.Instrument as model where model.contracttag= ?]; nested exception is org.hibernate.QueryException: could not resolve property: contracttag of: com.eclipseoptions.eodata.persistence.instrument.Instrument [from com.eclipseoptions.eodata.persistence.instrument.Instrument as model where model.contracttag= ?]


The code fragment to build the query string and retrieve the record:

String queryString = "from Instrument as model where model." + "contracttag" + "= ?";
return getHibernateTemplate().find(queryString, value);



The class structure is like this.

package com.eclipseoptions.eodata.persistence.instrument;
@Entity
@Table(name = "contracts")
public class Instrument
{
.
private InstrumentId instrumentId;
.
}
@Embeddable
public class InstrumentId{

.
@Column
private int contracttag;
.
}
The table schema:
CREATE TABLE contracts
(
id integer NOT NULL ,
username char(64),
contracttag integer NOT NULL ,
.
.
)

You'll need to "go into" the component using dot notation. Try:

Hi nordborg,
Yes it works finally. I tried using model.InstrumentId which is the class name but failed. Thanks a lot for your help

Can i define the @Id of the whole structure in an embedded object?

ie.

package com.eclipseoptions.eodata.persistence.instrument;
@Entity
@Table(name = "contracts")
public class Instrument
{
.
private InstrumentId instrumentId;
.
}

@Embeddable
public class InstrumentId{

.
@Id
private int contracttag;
.
}

CREATE TABLE contracts
(
id integer NOT NULL ,
username char(64),
contracttag integer NOT NULL ,
.
.
)