HI Doychi,
I would recommend that you provide the full stack trace as it will be more
informative than the summary line.
regards Malcolm Edgar
On Tue, Oct 20, 2009 at 8:12 PM, Doychi <doychi-li...@doychi-dina.ath.cx>wrote:
>
> Hi all,
>
> I'm hoping someone can help me with a lazy initialisation error. The error
> I am getting is:
>
> failed to lazily initialize a collection of role ... no session or
> session was closed
>
> I am using Click 2's SpringClickServlet configured in the web.xml and JPA.
>
> This is my web.xml, which seems to load everything okay.
>
>
> <web-app>
> <listener>
>
>
> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
> </listener>
> <servlet>
> <servlet-name>SpringClickServlet</servlet-name>
>
> <servlet-class>au.org.pheno.f1.click.SpringClickServlet</servlet-class>
> <load-on-startup>0</load-on-startup>
> </servlet>
> <servlet-mapping>
> <servlet-name>SpringClickServlet</servlet-name>
> <url-pattern>*.htm</url-pattern>
> </servlet-mapping>
> </web-app>
>
>
> The page, which was taken from my login page, is trying to load a user
> (principal) and display its roles to test the lazy loading issue.
>
>
> /*
> * To change this template, choose Tools | Templates
> * and open the template in the editor.
> */
> package au.org.pheno.f1.test.pages;
>
> import javax.annotation.Resource;
>
> import org.apache.click.Page;
> import org.apache.log4j.Logger;
> import org.springframework.stereotype.Component;
>
> import au.org.pheno.f1.domain.attendees.Principal;
> import au.org.pheno.f1.repository.attendees.IPrincipalRepository;
>
> /**
> * The login screen provides a user a way to login to the system.
> *
> * @author doychi
> */
> @Component("au.org.pheno.f1.test.pages.LoginPage")
> public class LoginPage extends Page {
>
> private static final String TITLE = "Test Page";
> public String msg = "";
> private IPrincipalRepository repository;
> private Logger log = Logger.getLogger(LoginPage.class);
> public Principal principal;
>
> private Logger getLogger() {
> return log;
> }
>
> /**
> * Retrieve the title
> *
> * @return the title
> */
> public String getTitle() {
> return TITLE;
> }
>
> /**
> * Set the principal repository to use for the page.
> *
> * @param principalRepository
> * the repository to use
> */
> @Resource(name = "principalRepository")
> public void setPrincipalRepository(IPrincipalRepository
> principalRepository) {
> if (getLogger().isDebugEnabled()) {
> getLogger().debug("IPrincipalRepository set");
> }
>
> this.repository = principalRepository;
> }
>
> public IPrincipalRepository getPrincipalRepository() {
> return repository;
> }
>
> @Override
> public void onInit() {
> super.onInit();
> principal = repository.principalByLogin("admin");
> getLogger().info(principal.toString());
> }
>
> }
>
>
> The principal repository looks like this:
>
>
> package au.org.pheno.f1.repository.attendees.jpa;
>
> import java.util.ArrayList;
> import java.util.List;
> import java.util.Map;
> import java.util.Set;
> import java.util.TreeMap;
>
> import org.apache.commons.lang.StringUtils;
> import org.apache.commons.lang.builder.ReflectionToStringBuilder;
> import org.apache.log4j.Logger;
> import org.springframework.dao.DataAccessException;
> import org.springframework.security.AuthenticationServiceException;
> import org.springframework.security.BadCredentialsException;
> import org.springframework.security.userdetails.UserDetails;
> import org.springframework.security.userdetails.UsernameNotFoundException;
> import org.springframework.stereotype.Component;
> import org.springframework.transaction.annotation.Transactional;
>
> import au.org.pheno.f1.domain.attendees.Principal;
> import au.org.pheno.f1.domain.attendees.Role;
> import au.org.pheno.f1.repository.Repository;
> import au.org.pheno.f1.repository.WrongNumberOfResultsReturnedException;
> import au.org.pheno.f1.repository.attendees.IPrincipalRepository;
>
> /**
> * Class description
> *
> *
> * @version Enter version here..., 07/12/26
> * @author Enter your name here...
> */
> @Component("principalRepository")
> @Transactional(readOnly = true)
> public class PrincipalRepository extends Repository<Principal> implements
> IPrincipalRepository {
>
> private String LOGIN_TAG = "usr";
> private static final Logger log = Logger
> .getLogger(PrincipalRepository.class);
> private static final String FILTER_OP_BOOLEAN = " = ";
> private static final String FILTER_OP_INTEGER = " = ";
> private static final String FILTER_OP_STRING = " LIKE ";
> .
> .
> .
> /**
> * {...@inheritdoc}
> */
> @Override
> public Principal principalByLogin(String login) {
> Principal result;
> String query = "SELECT principal FROM PrincipalJpa principal WHERE "
> + "principal.username = :" + LOGIN_TAG;
> Map<String, Object> params = new TreeMap<String, Object>();
>
> params.put(LOGIN_TAG, login);
>
> result = (Principal) readOne(query, params);
>
> return result;
> }
> .
> .
> .
> }
>
>
> The error appears to be thrown when my template tries to list the roles:
>
>
> <html>
> <body>
> <p class="errorMessage">
> $!msg
> </p>
> ${principal.firstName} ${principal.lastName}
> #foreach( $role in $principal.roles)
> $role.name
> #end
> </body>
> </html>
>
>
> Does anyone have any thoughts on what I'm doing wrong?
>
> Thanks,
> --
> Doychi
> --
> View this message in context:
> http://n2.nabble.com/Click-2-Spring-and-JPA-Lazy-Initialisation-Error-tp3857539p3857539.html
> Sent from the click-user mailing list archive at Nabble.com.
>
