I defined a named query in my mapping file,

<sql-query name="getFlexibleAttributes">
<return alias="attribute" class="com.xxx.app.dal.AttributeTO"/>
<![CDATA[SELECT fd.LABEL as {attribute.attributeName}, fn.ATTRIBUTE_VALUE as
{attribute.attributeValue}
FROM TABLE_PART_NUM pn, TABLE_FA_PART_NUM fn, TABLE_FLEX_DEFN fd
WHERE fn.FA_PART_NUM2PART_NUM = pn.OBJID and
fd.ATTRIBUTE_NAME = fn.ATTRIBUTE_NAME and
pn.PART_NUMBER = :partNumber]]>
</sql-query>

What I'm trying to do is to pull data from three different tables into object AttributeTO. There is no physical table for the object AttributeTO. Is it doable? If the answer is yes, whatelse do I have to define in the mapping file?


Thanks.

No, this is not possible. sql-queries can only return Hibernate mapped classes.

Is it possible to select data from 2 tables into 1 mapped class? To be more specific a class called JobClassification with variables jc_id and jc_name and a table job_classification with fields jc_id, jc_name and jc_code where jc_code is a foreign key for a job_classification_code table with a PK field jcc_id and a further field jcc_product. Ultimately, i want to populate the JobClassification class with the jc_id (from job_classification) and jcc_product (from job_classification_code) concatenated with the jc_name (from job_classification) field.

I can run such a sql query from an Oracle client:

select jc_id, jcc_code || ' || ' || jc_name as jc_name from job_classificat
ion inner join job_classification_code on jc_code = jcc_id;

What about hibernate?

Paul

Doese Hibernate mapped classes have to map to a physical table?