restrict queries in association while fetching data....

[Bhavin Sanghani]

Hi

I want to restrict few queries while fetching the data. I have kept lazy="false" in my code with fetch="subselect" and "join" as appropriate. Now, I want to fetch objects upto one level and at second level except one association i want to discard everything in query. e.g.

In following mapping strucutre, I want to load all QuestionsAnswer with Question & Answer objects only and not Feature which has association in Answer:

	<class name="QuestionAnswer" table="solutiondetails" lazy="false">
		<id name="questionAnswerId" type="java.lang.Long" column="questionAnswerId">
			<generator class="increment" />
		</id>
		<many-to-one name="request" column="REQUESTID" class="Request" not-null="true"/>
		<many-to-one name="question" column="QUESTIONID" class="Question" not-null="true"/>
		<many-to-one name="answer" column="ANSWERID" class="Answer" not-null="true"/>
		<property name="answerValue" column="ANSWERVALUE" type="java.lang.String" length="1000" />
	</class>


	<class name="Question" table="QUESTION" lazy="false">
		<id name="questionId" type="java.lang.Long" column="QUESTIONID" >
			<generator class="increment" />
		</id>
		<property name="questionName" type="java.lang.String" column="QUESTIONNAME" length="1000" />
		<many-to-one name="questionType" column="QUESTIONTYPEID" class="QuestionType" not-null="true" fetch="join" lazy="false"/>
		<many-to-one name="questionSet" column="QUESTIONSETID" class="QuestionSet" not-null="true"/>
		<bag name="answers" inverse="true" cascade="all" order-by="answerId" fetch="subselect" lazy="false">
			<key column="questionId"/>
			<one-to-many class="Answer"/>
		</bag>
	</class>


	<class name="Answer" table="ANSWER" lazy="false">
		<id name="answerId" type="java.lang.Long" column="ANSWERID" >
			<generator class="increment" />
		</id>
		<property name="answerName" type="java.lang.String" column="ANSWERNAME" length="1000" />
		<property name="sequence" type="big_integer" column="SEQUENCE" />
		<many-to-one name="question" column="questionId" class="Question" not-null="true"/>
		<many-to-one name="feature" column="FEATUREID"  class="Feature" cascade="all"/> 
	</class>

Any idea how can I do this?

Thanks,
Bhavin

[Paul Sturrock]

You'll need to map the association to feature as lazy and not eagerly fetch it in your HQL/Criteria.