attaching Criteria to a query instantiation

kochcp · **Posted:** Wed Aug 31, 2005 2:33 pm

Hibernate version:
3.0.5

I'm trying to use the Criteria to override lazy initialization for a query.
Is there a way to add criteria to a query? something starting along the lines of the following code

Code:

               Query query = session.getNamedQuery("fromJobQueueList");
               query.setProperties(jql);

               session.createCriteria(jql.getClass()).setFetchMode("JobQueueSysins", FetchMode.JOIN);
 

I'm trying to use the criteria because I don't want to have lazy="false" declared for the entire class and I don't want to use Hibernate.initialize because that gets me the whole N+1 problem.

... or am I generating too much trouble for myself and go ahead and just initialize lazy="false" for the class in the hbm file?

pksiv · **Posted:** Wed Aug 31, 2005 2:40 pm

You should just code the join in your query.

kochcp · **Posted:** Wed Aug 31, 2005 4:07 pm

awww and I did all that research into criteria.

is there any way to declare an association as not lazy instead of the whole class. I tried the following but it doesn't work. I have to move the lazy="false" up inside the class definition area of the hbm file to get it to work

Code:

    <!-- associations -->
    <!-- uni-directional one-to-many association to JobQueueSysin -->

    <list
        name="jobQueueDetails"
        cascade="all-delete-orphan"
        lazy="true"
        fetch="join" 
   outer-join="true"

    >
        <key>
            <column name="instidq" />
             ....
        </key>
        <index column="user_seq_no" />
        <one-to-many 
            class="dars.apis.audit.JobQueueSysin"
        />
    </list>