Hi,

I have a mapping-file like this:

Mapping documents:

<?xml version="1.0"?>
...
<hibernate-mapping>
<class name="de.fhkempten.model.sap.Spfli" table="spfli">
<composite-id name="id" class="de.fhkempten.model.sap.SpfliId">
<key-many-to-one name="scarr" class="de.fhkempten.model.sap.Scarr">
<column name="carrid" length="5" />
</key-many-to-one>
<key-property name="connid" type="string">
<column name="connid" length="5" />
</key-property>
</composite-id>
<property name="airpfrom" type="string">
<column name="airpfrom" length="45" not-null="true" />
</property>
...
<set name="sflights" inverse="true">
<key>
<column name="carrid" length="5" not-null="true" />
<column name="connid" length="5" not-null="true" />
</key>
<one-to-many class="de.fhkempten.model.sap.Sflight" />
</set>
</class>
</hibernate-mapping>


My aim is to access the "scarr" column of this table.
Something like "select spfli.scarr from de.fhkempten.model.sap.Spfli as spfli", throws an error: "could not resolve property: scarr".


Anyone got an idea how I can do this?


Thanks
Jonny

Sorry,

inserted the wrong subject. Will post again as "HQL question - How to access certain keys"

Cheers
Jonny

scarr is not a property of spfli, it's a property of spfli.id so I would think you would access it as spfli.id.scarr ?

Thanks for the quick reply. Now its working!!

Thank you very much!! You saved the day

P.S.: If some admin could please change the subjetc of this message to "HQL question - How to access certain keys" (if this wrong subject bothers anyone), how I dummy intended it.

Cheers
Jonny

One last question:

My mapping-file

<class name="de.fhkempten.model.sap.Sflight" table="sflight">
<composite-id name="id" class="de.fhkempten.model.sap.SflightId">
<key-many-to-one name="spfli" class="de.fhkempten.model.sap.Spfli">
<column name="carrid" length="5" />
<column name="connid" length="5" />
</key-many-to-one>
<key-property name="fldate" type="date">
<column name="fldate" length="10" />
</key-property>
</composite-id>
...


If I do a query like this (to return a single column): "SELECT sf.id.spfli.carrid FROM Sflight sf" I get the following error: "Operand should contain 1 column(s)".

When I do a similar query on the mapping-file posted before, like: "select sp.id.scarr.carrid from Spfli sp" it works (to return this column).

What am I doing wrong now?

Thanks
Jonny