Hi,

I have 3 tables :

1. Documents - pk :document-id
2. Attributesets - pk:attribute-id
and a connecting table:
3. DocumentAttributesets - pk: document-id & attribute-id

I have generated the mapping files & classes by MyEclipse plugin.

The DocumentAttributesets mapping file:

<class name="DocumentAttributesets" table="DOCUMENT_ATTRIBUTESETS">
<composite-id name="id" class="DocumentAttributesetsKey">
<key-many-to-one name="taxonomyAttributesets" column="ATTRIBUTESETID" class="TaxonomyAttributesets"/>
<key-many-to-one name="documents" column="DOCUMENTID" class="Documents"/>
</composite-id>
</class>

DocumentAttributesetsKey class contains the following members:

/** The value of the ATTRIBUTESETID component of this composite id. */
private TaxonomyAttributesets taxonomyAttributesets;

/** The value of the DOCUMENTID component of this composite id. */
private Documents documents;

I don't understand how to write select or delete HQL using the using one of the fields from the composite-id for example:

I have run a query on Documents & got a List of Documents.

1. What is the syntax of HQL query to select all DocumentAttributesets
that there Document is in the List of Documents?

2. What is the syntax of HQL query to delete all DocumentAttributesets
that there Document appears in the List of Documents?

When wrote something like:
session.createQuery("from DocumentAttributesets where DocumentAttributesets.documents in ....)
I get syntax error, hibernate doesn't understand the :DocumentAttributesets.documents



[/b]

Does DocumentAttributesets contains any other columns ?
If this table is a simple link table, used to represent many-to-many relationship, than it is better to use this kind of relationship mapping in xml files for Documnt and Attribute tables.
In this case you will be able to search for document by attributes like

where :attribute parameter value is the instance of Attribute object loaded before quering.

I think you plugin for Eclipse simlpy wrongly named the class Documnts instead of 'Document', since it is not a collection but an object in composit key.

DocumentAttributesets doesn't contain any other records, it is used to represent many-to-many relationship.
The eclipse plugin called the object Documents since this is the table name.

I still don't understand,
how can I delete specific documents' records from the table DocumentAttributesets ?

This could be like this:

Thanks,

But basically I would like to know how can I refer to the members of the composite key.

For example:
If I would like to do an inner join between DocumentAttributesets & Attributesets tables in order to get only the attributes that have documents containing them , in simple SQL I would do something like:
Selcect attribute_id from DocumentAttributesets docsAttr,Attributesets attr
where attr.attribute_id=docsAttr.attribute_id.

In HQL, I have tried something like:

session.createQuery("select attr from Attributesets as attr,DocumentAttributesets as docAttr where attr.attributesetid=docAttr.attributesetid").list();

and I keep getting the same error:
"could not resolve property: attributesetid of DocumentAttributesets".
This problem happens only in objects that have composite key
(hibernate resolved the attributesetid of Attributesets)

So, if you have any idea what I wrote wrong in the query...

try to do the following