how to set fetch type at runtime ? + Hibernate

[Jigar Naik]

How can we set the fetch type at runtime

customerDAO.beginTransaction();
Customer customer = customerDAO.findByPrimaryKey(getCustomerId());
System.out.println("Total Products : " + customer.getLicense().getProducts().size());
	for (Product product : customer.getLicense().getProducts()) {
		System.out.println("Total Modules : " + product.getModules().size());
	}
session.put("customer", customer);
customerDAO.commitTransaction();

[Paul Sturrock]

You can specify it in your query.

[Cameron Wallace McKenzie]

Here's an example of fetching associated properties in an eagar manner at runtime. Without an HQL query, I don't believe there's anything you can do to dynamically change the FetchType that has been set in a mapping or through a Java Persistence API (JPA) annotation.

from Sale sale
where sale.date > :startDate
left join fetch sale.salesman
left join fetch sale.product
left join fetch sale.product.color
left join fetch sale.product.category

Setting FetchType to Eagar at Runtime with a Hibernate Query

-Cameron McKenzie