Hi,

After playing around some time, I finally sort out how to use XDoclet to generate a table with composite key by having two classes while one class for Primary key properties

However, I don't know how to write the hql as the primary keys are under another java class.

If only one java class, I can write something like this
from BatchControl ct where ct.resourceName = :resource_name and batchId = :batch_id

But, since the resourceName and batchId are on BatchConrolCompositeKey class but I want to return the whole BatchControl.

How can I write the hql then?

public class BatchControl implements Serializable {
private BatchControlCompositeKey key;
private String attribute;
private Timestamp lastUpdate;
private String status;

public BatchControlCompositeKey getKey() {
return key;
}
public void setKey(BatchControlCompositeKey key) {
this.key = key;
}
public String getAttribute() {
return attribute;
}
public void setAttribute(String attribute) {
this.attribute = attribute;
}
public Timestamp getLastUpdate() {
return lastUpdate;
}
public void setLastUpdate(Timestamp lastUpdate) {
this.lastUpdate = lastUpdate;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
}


public class BatchControlCompositeKey implements Serializable {
private String resourceName;
private long batchId;

public String getResourceName() {
return resourceName;
}
public void setResourceName(String resourceName) {
this.resourceName = resourceName;
}
public long getBatchId() {
return batchId;
}
public void setBatchId(long batchId) {
this.batchId = batchId;
}
public boolean equals(Object o) {
if (o == null) {
return false;
}
if (getClass().equals(o.getClass()) &&
resourceName.equals(((BatchControlCompositeKey) o).getResourceName()) &&
batchId == ((BatchControlCompositeKey) o).getBatchId() ) {
return true;
}
else {
return false;
}
}
public int hashCode() {
return resourceName.hashCode();
}
}