How to fix Hibernate LazyInitializationException failed to lazily initialize a collection of roles could not initialize proxy - no Session

Question

In the custom AuthenticationProvider from my spring project  I am trying read the list of authorities of the logged user  but I am facing the following error   org hibernate LazyInitializationException  failed to lazily initialize a collection of role  com horariolivre entity Usuario autorizacoes  could not initialize proxy - no Session     at org hibernate collection internal AbstractPersistentCollection throwLazyInitializationException AbstractPersistentCollection java 566      at org hibernate collection internal AbstractPersistentCollection withTemporarySessionIfNeeded AbstractPersistentCollection java 186      at org hibernate collection internal AbstractPersistentCollection initialize AbstractPersistentCollection java 545      at org hibernate collection internal AbstractPersistentCollection read AbstractPersistentCollection java 124      at org hibernate collection internal PersistentBag iterator PersistentBag java 266      at com horariolivre security CustomAuthenticationProvider authenticate CustomAuthenticationProvider java 45      at org springframework security authentication ProviderManager authenticate ProviderManager java 156      at org springframework security authentication ProviderManager authenticate ProviderManager java 177      at org springframework security web authentication UsernamePasswordAuthenticationFilter attemptAuthentication UsernamePasswordAuthenticationFilter java 94      at org springframework security web authentication AbstractAuthenticationProcessingFilter doFilter AbstractAuthenticationProcessingFilter java 211      at org springframework security web FilterChainProxy VirtualFilterChain doFilter FilterChainProxy java 342      at org springframework security web authentication logout LogoutFilter doFilter LogoutFilter java 110      at org springframework security web FilterChainProxy VirtualFilterChain doFilter FilterChainProxy java 342      at org springframework security web header HeaderWriterFilter doFilterInternal HeaderWriterFilter java 57      at org springframework web filter OncePerRequestFilter doFilter OncePerRequestFilter java 107      at org springframework security web FilterChainProxy VirtualFilterChain doFilter FilterChainProxy java 342      at org springframework security web context SecurityContextPersistenceFilter doFilter SecurityContextPersistenceFilter java 87      at org springframework security web FilterChainProxy VirtualFilterChain doFilter FilterChainProxy java 342      at org springframework security web context request async WebAsyncManagerIntegrationFilter doFilterInternal WebAsyncManagerIntegrationFilter java 50      at org springframework web filter OncePerRequestFilter doFilter OncePerRequestFilter java 107      at org springframework security web FilterChainProxy VirtualFilterChain doFilter FilterChainProxy java 342      at org springframework security web FilterChainProxy doFilterInternal FilterChainProxy java 192      at org springframework security web FilterChainProxy doFilter FilterChainProxy java 160      at org springframework web filter DelegatingFilterProxy invokeDelegate DelegatingFilterProxy java 343      at org springframework web filter DelegatingFilterProxy doFilter DelegatingFilterProxy java 260      at org apache catalina core ApplicationFilterChain internalDoFilter ApplicationFilterChain java 243      at org apache catalina core ApplicationFilterChain doFilter ApplicationFilterChain java 210      at org apache catalina core StandardWrapperValve invoke StandardWrapperValve java 222      at org apache catalina core StandardContextValve invoke StandardContextValve java 123      at org apache catalina authenticator AuthenticatorBase invoke AuthenticatorBase java 502      at org apache catalina core StandardHostValve invoke StandardHostValve java 171      at org apache catalina valves ErrorReportValve invoke ErrorReportValve java 99      at org apache catalina valves AccessLogValve invoke AccessLogValve java 953      at org apache catalina core StandardEngineValve invoke StandardEngineValve java 118      at org apache catalina connector CoyoteAdapter service CoyoteAdapter java 408      at org apache coyote http11 AbstractHttp11Processor process AbstractHttp11Processor java 1023      at org apache coyote AbstractProtocol AbstractConnectionHandler process AbstractProtocol java 589      at org apache tomcat util net JIoEndpoint SocketProcessor run JIoEndpoint java 312      at java util concurrent ThreadPoolExecutor runWorker ThreadPoolExecutor java 1145      at java util concurrent ThreadPoolExecutor Worker run ThreadPoolExecutor java 615      at java lang Thread run Thread java 744    Reading other topics from here in StackOverflow  I understand this happens due the way this type of atribute is handled by the framework  but i can t figure out any solution for my case  Someone can point what i am doing wrong and what I can do to fix it   The code of my Custom AuthenticationProvider is    Component public class CustomAuthenticationProvider implements AuthenticationProvider         Autowired     private UsuarioHome usuario       public CustomAuthenticationProvider             super                Override     public Authentication authenticate Authentication authentication  throws AuthenticationException           System out println  CustomAuthenticationProvider authenticate             String username   authentication getName            String password   authentication getCredentials   toString             Usuario user   usuario findByUsername username            if  user    null                if user getSenha   equals password                     List lt AutorizacoesUsuario gt  list   user getAutorizacoes                     List  lt String gt  rolesAsList   new ArrayList lt String gt                     for AutorizacoesUsuario role   list                       rolesAsList add role getAutorizacoes   getNome                                        List lt GrantedAuthority gt  authorities   new ArrayList lt GrantedAuthority gt                     for  String role name   rolesAsList                        authorities add new SimpleGrantedAuthority role name                                       Authentication auth   new UsernamePasswordAuthenticationToken username  password  authorities                   return auth                            else                   return null                          else               return null                        Override     public boolean supports Class lt   gt  authentication            return authentication equals UsernamePasswordAuthenticationToken class              My Entity classes are   UsuarioHome java   Entity  Table name    usuario   public class Usuario implements java io Serializable        private int id      private String login      private String senha      private String primeiroNome      private String ultimoNome      private List lt TipoUsuario gt  tipoUsuarios   new ArrayList lt TipoUsuario gt         private List lt AutorizacoesUsuario gt  autorizacoes   new ArrayList lt AutorizacoesUsuario gt         private List lt DadosUsuario gt  dadosUsuarios   new ArrayList lt DadosUsuario gt         private ConfigHorarioLivre config       public Usuario                public Usuario String login  String senha            this login   login          this senha   senha             public Usuario String login  String senha  String primeiroNome  String ultimoNome  List lt TipoUsuario gt  tipoUsuarios  List lt AutorizacoesUsuario gt  autorizacoesUsuarios  List lt DadosUsuario gt  dadosUsuarios  ConfigHorarioLivre config            this login   login          this senha   senha          this primeiroNome   primeiroNome          this ultimoNome   ultimoNome          this tipoUsuarios   tipoUsuarios          this autorizacoes   autorizacoesUsuarios          this dadosUsuarios   dadosUsuarios          this config   config             public Usuario String login  String senha  String primeiroNome  String ultimoNome  String tipoUsuario  String   campos            this login   login          this senha   senha          this primeiroNome   primeiroNome          this ultimoNome   ultimoNome          this tipoUsuarios add new TipoUsuario this  new Tipo tipoUsuario             for int i 0  i lt campos length  i                this dadosUsuarios add new DadosUsuario this  null  campos i                 Id      Column name    id   unique   true  nullable   false       GeneratedValue strategy GenerationType AUTO      public int getId             return this id             public void setId int id            this id   id              Column name    login   nullable   false  length   16      public String getLogin             return this login             public void setLogin String login            this login   login              Column name    senha   nullable   false      public String getSenha             return this senha             public void setSenha String senha            this senha   senha              Column name    primeiro nome   length   32      public String getPrimeiroNome             return this primeiroNome             public void setPrimeiroNome String primeiroNome            this primeiroNome   primeiroNome              Column name    ultimo nome   length   32      public String getUltimoNome             return this ultimoNome             public void setUltimoNome String ultimoNome            this ultimoNome   ultimoNome              ManyToMany cascade CascadeType ALL       JoinTable name    tipo usuario   joinColumns      JoinColumn name    fk usuario      inverseJoinColumns      JoinColumn name    fk tipo           LazyCollection LazyCollectionOption TRUE      public List lt TipoUsuario gt  getTipoUsuarios             return this tipoUsuarios             public void setTipoUsuarios List lt TipoUsuario gt  tipoUsuarios            this tipoUsuarios   tipoUsuarios              ManyToMany cascade CascadeType ALL       JoinTable name    autorizacoes usuario   joinColumns      JoinColumn name    fk usuario      inverseJoinColumns      JoinColumn name    fk autorizacoes           LazyCollection LazyCollectionOption TRUE      public List lt AutorizacoesUsuario gt  getAutorizacoes             return this autorizacoes             public void setAutorizacoes List lt AutorizacoesUsuario gt  autorizacoes            this autorizacoes   autorizacoes              ManyToMany cascade CascadeType ALL       JoinTable name    dados usuario   joinColumns      JoinColumn name    fk usuario      inverseJoinColumns      JoinColumn name    fk dados           LazyCollection LazyCollectionOption TRUE      public List lt DadosUsuario gt  getDadosUsuarios             return this dadosUsuarios             public void setDadosUsuarios List lt DadosUsuario gt  dadosUsuarios            this dadosUsuarios   dadosUsuarios              OneToOne      JoinColumn name  fk config       public ConfigHorarioLivre getConfig             return config             public void setConfig ConfigHorarioLivre config            this config   config            AutorizacoesUsuario java   Entity  Table name    autorizacoes usuario   uniqueConstraints    UniqueConstraint columnNames    id    public class AutorizacoesUsuario implements java io Serializable        private int id      private Usuario usuario      private Autorizacoes autorizacoes       public AutorizacoesUsuario                public AutorizacoesUsuario Usuario usuario  Autorizacoes autorizacoes            this usuario   usuario          this autorizacoes   autorizacoes              Id      Column name    id   unique   true  nullable   false       GeneratedValue strategy GenerationType AUTO      public int getId             return this id             public void setId int id            this id   id              OneToOne      JoinColumn name    fk usuario   nullable   false  insertable   false  updatable   false      public Usuario getUsuario             return this usuario             public void setUsuario Usuario usuario            this usuario   usuario              OneToOne      JoinColumn name    fk autorizacoes   nullable   false  insertable   false  updatable   false      public Autorizacoes getAutorizacoes             return this autorizacoes             public void setAutorizacoes Autorizacoes autorizacoes            this autorizacoes   autorizacoes             Autorizacoes java   Entity  Table name    autorizacoes   public class Autorizacoes implements java io Serializable        private int id      private String nome      private String descricao       public Autorizacoes                public Autorizacoes String nome            this nome   nome             public Autorizacoes String nome  String descricao            this nome   nome          this descricao   descricao              Id      Column name    id   unique   true  nullable   false       GeneratedValue strategy GenerationType AUTO      public int getId             return this id             public void setId int id            this id   id              Column name    nome   nullable   false  length   16      public String getNome             return this nome             public void setNome String nome            this nome   nome              Column name    descricao   length   140      public String getDescricao             return this descricao             public void setDescricao String descricao            this descricao   descricao            Full project available on github  --  https   github com klebermo webapp horario livre

User · Answer

For those using JaVers  given an audited entity class  you may want to ignore the properties causing the LazyInitializationException exception  e g  by using the  DiffIgnore annotation   This tells the framework to ignore those properties when calculating the object differences  so it won t try to read from the DB the related objects outside the transaction scope  thus causing the exception

User · Answer

I too had this problem when I was doing unit Testing  A very Simple Solution to this problem is to use  Transactional annotation which keeps the session open till the end of the execution

User · Answer

The best way to handle the LazyInitializationException is to use the JOIN FETCH directive for all the entities that you need to fetch along  Anyway  DO NOT use the following Anti-Patterns as suggested by some of the answers   Open Session in View hibernate enable lazy load no trans  Sometimes  a DTO projection is a better choice than fetching entities  and this way  you won t get any LazyInitializationException

User · Answer

There are cases where you don t need to put  Transactional annotation to your service method  like integration testing  I was getting this org hibernate LazyInitializationException when testing a method that just selects from database  which did not need to be transactional  The entity class I try to load has a lazy fetch relation that caused this  OneToMany mappedBy    quot parent quot   fetch   FetchType LAZY  private List lt Item gt  items   so I ended up adding the  Transactional to only to the test method   Test  Transactional public void verifySomethingTestSomething

User · Answer

Adding following property to your persistence xml may solve your problem temporarily   lt property name  hibernate enable lazy load no trans  value  true    gt    As  vlad-mihalcea said it s an antipattern and does not solve lazy initialization issue completely  initialize your associations before closing transaction and use DTOs instead

User · Answer

For those who have this problem with collection of enums here is how to solve it    Enumerated EnumType STRING   Column name    OPTION    CollectionTable name    MY ENTITY MY OPTION    ElementCollection targetClass   MyOptionEnum class  fetch   EAGER  Collection lt MyOptionEnum gt  options

User · Answer

Your Custom AuthenticationProvider class should be annotated with the following       Transactional   This will make sure the presence of the hibernate session there as well

User · Answer

The reason is that when you use lazy load  the session is closed   There are two solutions    Don t use lazy load   Set lazy false in XML or Set  OneToMany fetch   FetchType EAGER  In annotation  Use lazy load    Set lazy true in XML or Set  OneToMany fetch   FetchType LAZY  In annotation   and add OpenSessionInViewFilter filter in your web xml   Detail See my post   https   stackoverflow com a 27286187 1808417

User · Answer

First of all I d like to say that all users who said about lazy and transactions were right  But in my case there was a slight difference in that I used result of  Transactional method in a test and that was outside real transaction so I got this lazy exception   My service method    Transactional User get String uid        My test code   User user   userService get  123    user getActors      org hibernate LazyInitializationException  failed to lazily initialize a collection of role   My solution to this was wrapping that code in another transaction like this   List lt Actor gt  actors   new ArrayList lt  gt     transactionTemplate execute  status    - gt  actors addAll userService get  123   getActors

User · Answer

A common practice is to put a  Transactional above your service class   Service  Transactional public class MyServiceImpl implements MyService

User · Answer

Add the annotation    JsonManagedReference   For example    ManyToMany cascade CascadeType ALL   JoinTable name    autorizacoes usuario   joinColumns      JoinColumn name    fk usuario      inverseJoinColumns      JoinColumn name    fk autorizacoes       JsonManagedReference public List lt AutorizacoesUsuario gt  getAutorizacoes         return this autorizacoes

User · Answer

You can use hibernate lazy initializer     Below is the code you can refer  Here PPIDO is the data object which I want to retrieve  Hibernate initialize ppiDO   if  ppiDO instanceof HibernateProxy        ppiDO    PolicyProductInsuredDO    HibernateProxy  ppiDO  getHibernateLazyInitializer            getImplementation        ppiDO setParentGuidObj policyDO getBasePlan         saveppiDO add ppiDO       proxyFl   true

User · Answer

I believe rather than enabling eager fetch  it make sense to re-initialise your entity where its needed to avoid LazyInitializationException exception  Hibernate initialize your entity

User · Answer

You need to either add fetch FetchType EAGER inside your ManyToMany annotations to automatically pull back child entities    ManyToMany fetch   FetchType EAGER    A better option would be to implement a spring transactionManager by adding the following to your spring configuration file    lt bean id  transactionManager      class  org springframework orm hibernate4 HibernateTransactionManager  gt       lt property name  sessionFactory  ref  sessionFactory    gt   lt  bean gt    lt tx annotation-driven   gt    You can then add an  Transactional annotation to your authenticate method like so    Transactional public Authentication authenticate Authentication authentication    This will then start a db transaction for the duration of the authenticate method allowing any lazy collection to be retrieved from the db as and when you try to use them

[java] How to fix Hibernate LazyInitializationException: failed to lazily initialize a collection of roles, could not initialize proxy - no Session

Examples related to java

Examples related to spring

Examples related to hibernate

Examples related to spring-mvc

Examples related to spring-security