StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POLazy initialize in Spring MVC
primarykey
Id
7064880
data
AcceptedAnswerId
7065597
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-08-15T12:26:58.203
FavoriteCount
1
LastActivityDate
2012-01-17T17:05:59.087
LastEditDate
2012-01-17T17:05:59.087
LastEditorUserId
231982
OwnerUserId
894913
ParentId
0
PostTypeId
1
Score
1
ViewCount
7941
LastEditorDisplayName
text
Body
Despite using configuration below I got lazy initialize error: <blockquote> org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: beans.Restaurant.tags, no session or session was closed </blockquote> and here the web.xml: <pre><code><?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5"> <display-name>RestFinderWebApp</display-name> <servlet> <servlet-name>spring</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>spring</servlet-name> <url-pattern>*.htm</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file>  </welcome-file-list>  <context-param> <param-name>contextConfigLocation</param-name> <param-value> /WEB-INF/applicationContext-security.xml, /WEB-INF/spring-servlet.xml </param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <filter> <filter-name>springSecurityFilterChain</filter-name> <filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class> </filter> <filter-mapping> <filter-name>springSecurityFilterChain</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <filter> <filter-name>encodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <filter> <filter-name>SpringOpenEntityManagerInViewFilter</filter-name> <filter-class>org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter</filter-class> </filter> <filter-mapping> <filter-name>SpringOpenEntityManagerInViewFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> </code></pre> spring-servlet.xml: <pre><code> <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:lang="http://www.springframework.org/schema/lang" xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd"> <context:annotation-config /> <tx:annotation-driven transaction-manager="txManager" /> <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory"> <ref local="sessionFactory" /> </property> </bean> <bean id="jspViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> <property name="prefix" value="/" /> <property name="suffix" value=".jsp" /> </bean> <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" /> <bean class="org.springframework.jmx.export.MBeanExporter"> <property name="autodetect" value="false" /> <property name="assembler"> <bean id="jmxAssembler" class="org.springframework.jmx.export.assembler.MetadataMBeanInfoAssembler"> <property name="attributeSource"> <bean class="org.springframework.jmx.export.annotation.AnnotationJmxAttributeSource" /> </property> </bean> </property> </bean> <bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource" p:basename="messages" /> <bean id="openSessionInViewInterceptor" class="org.springframework.orm.hibernate3.support.OpenSessionInViewInterceptor"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="persistenceUnitName" value="myPersistence" /> <property name="dataSource" ref="dataSource" /> <property name="jpaDialect"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" /> </property> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"> <property name="showSql" value="false" /> <property name="generateDdl" value="true" /> <property name="databasePlatform" value="org.hibernate.dialect.MySQLDialect" /> </bean> </property> </bean> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> (...) </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="annotatedClasses"> <list> (...) </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.connection.useUnicode">true</prop> <prop key="hibernate.connection.characterEncoding">UTF-8</prop> </props> </property> </bean> <tx:annotation-driven /> <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="myUserDAO" class="dao.UserDAO"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <bean id="myRestaurantDAO" class="dao.RestaurantDAO"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <bean name="/mojekonto.htm" class="web.HomeUserController"> <property name="userDAO" ref="myUserDAO" /> <property name="restaurantDAO" ref="myRestaurantDAO" /> <property name="loggedUser" ref="LoggedUser" /> </bean> </beans> </code></pre> my controller: <pre><code>public class HomeUserController extends MultiActionController { private UserDAO userDAO; private TagDAO tagDAO; public void setTagDAO(TagDAO tagDAO) { this.tagDAO = tagDAO; } public void setUserDAO(UserDAO userDAO) { this.userDAO = userDAO; } private LoggedUser loggedUser; public void setLoggedUser(LoggedUser loggedUser) { this.loggedUser = loggedUser; } private RestaurantDAO restaurantDAO; public void setRestaurantDAO(RestaurantDAO restaurantDAO) { this.restaurantDAO = restaurantDAO; } private FollowDAO followDAO; public void setFollowDAO(FollowDAO followDAO) { this.followDAO = followDAO; } private CommentDAO commentDAO; public void setCommentDAO(CommentDAO commentDAO) { this.commentDAO = commentDAO; } @InitBinder protected void initBinder(HttpServletRequest request, ServletRequestDataBinder binder) throws Exception { super.initBinder(request, binder); binder.registerCustomEditor(List.class, "tags",new CustomCollectionEditor(List.class){ @Override protected Object convertElement(Object element) { Tag tag = new Tag(); if (element != null) { int id = Integer.valueOf(element.toString()); tag.setId(id); } return tag; } }); } public ModelAndView mojekonto(HttpServletRequest request, HttpServletResponse response) throws Exception { User user = loggedUser.getLoggedUser(); ModelMap modelMap = new ModelMap(); Restaurant restaurant = new Restaurant(); Restaurant userRestaurant = new Restaurant(); userRestaurant = restaurantDAO.findRestaurantByUser(user.getUsername()); modelMap.addAttribute("user", user); modelMap.addAttribute("restaurant", restaurant); modelMap.addAttribute("userRestaurant", userRestaurant); return new ModelAndView("mojekonto", modelMap); } </code></pre> My class - restaurant: <pre><code> @Entity @Table(name="restaurants") public class Restaurant { @Id @GeneratedValue private int id; private String name; private String street; private String city; private String country; private String postal_code; private String telephone; private String logo; private String image; private String description; private float longitude; private float latitude; private Date last_update; @ManyToMany //it works fine... @JoinTable(name="user_restaurant_owner", joinColumns={@JoinColumn(name="restaurant_id")}, inverseJoinColumns={@JoinColumn(name="username")}) private List<User> owner; @ManyToMany //but that doesn't... @JoinTable(name="restaurant_tag", joinColumns={@JoinColumn(name="restaurant_id")}, inverseJoinColumns={@JoinColumn(name="tag_id")}) private List<Tag> tags; //getters and setters: </code></pre> my view jsp: <pre><code> <c:forEach items="${userRestaurant.tags}" var="current"> do something </c:forEach> </code></pre> I got error when it is in "{userRestaurant.tags}"
Tags
<hibernate><spring><spring-mvc>
Title
Lazy initialize in Spring MVC
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJeremy S.
UserOwnerUserId
1. USCichy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POLazy initialize in Spring MVC
 UserUserId
 USsimonlord
 VoteTypeVoteTypeId
 VTFavorite
2. VO
 singulars
 PostPostId
 POLazy initialize in Spring MVC
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POLazy initialize in Spring MVC
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
CommentsPostId
1. This table or related slice is empty.

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.