Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You only have access to the Hibernate Session in the DAO layer. If your associations don't have a <code>FetchType</code> configured, or if they have <code>FetchType.LAZY</code>, then you have two choices, both inside the DAO:</p> <ol> <li>Use <code>Hibernate.initialize</code></li> <li>Get some aspect of the association which forces Hibernate to initialize it</li> </ol> <p>Example 1: <code>Hibernate.initialize(myEntity.getMyAssociation());</code></p> <p>Example 2:</p> <pre><code>if(myEntity.getMyAssociation() != null) { myEntity.getMyAssociation().size(); // forces the association to be loaded } </code></pre> <p>I generally use example 2, because then I can also take advantage of <code>BatchSize</code> for Hibernate to optimize lazy fetches.</p> <p>-----------EDIT 1-----------</p> <p>Example for this case using HibernateTemplate and a callback:</p> <pre><code> public Restaurant load(final Long id) { // need to drop down to Hibernate because of lazy loading, and make sure all properties are loaded HibernateCallback&lt;Restaurant&gt; callBack = new HibernateCallback&lt;Restaurant&gt;() { public User doInHibernate(Session session) throws HibernateException { Query query = session.createQuery("from Restaurant r where r.id=:id").setInt("id", id); Restaurant restaurant = (Restaurant)query.uniqueResult(); Hibernate.initialize(restaurant.getOwner()); Hibernate.initialize(restaurant.getTags()); return restaurant; } }; return getHibernateTemplate().execute(callBack); </code></pre> <p>}</p> <p>-----------EDIT 2----------- And here's how to do it directly in Hibernate:</p> <pre><code>@Repository public class RestaurantDAOImpl implements RestaurantDAO { private SessionFactory factory; @Autowired public RestaurantDAOImpl(SessionFactory factory) { this.factory = factory; } public Restaurant load(Long id) { Query query = session.createQuery("from Restaurant r where r.id=:id").setInt("id", id); Restaurant restaurant = (Restaurant)query.uniqueResult(); Hibernate.initialize(restaurant.getOwner()); Hibernate.initialize(restaurant.getTags()); /* --OR -- if(restaurant.getTags() != null) { restaurant.getTags().size(); } */ return restaurant; } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POLazy initialize in Spring MVC
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USatrain
    1. USatrain
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHow to do that in my class restaurantDAO? : public class RestaurantDAO { private HibernateTemplate hibernateTemplate; public void setSessionFactory(SessionFactory sessionFactory){ this.hibernateTemplate = new HibernateTemplate(sessionFactory); } public void saveRestaurant(Restaurant restaurant){ hibernateTemplate.save(restaurant); } public List<Restaurant> GetAllRestaurants(){ return hibernateTemplate.loadAll(Restaurant.class); } }
      singulars
      1. PO
      1. USCichy
    2. COIf you are using HibernateTemplate, then you need to drop down into Hibernate via a callback. Current Spring standards are not to do that, but to call Hibernate directly. I can show you either one. Which would you prefer?
      singulars
      1. PO
      1. USatrain
    3. COdirectly, please :)
      singulars
      1. PO
      1. USCichy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload