Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

NHibernate 2.0.1

NHibernate.LazyInitializationException: failed to lazily initialize a collection, no session or session was closed

SQLite 3

Hi every body,

I have the following problem.

1) All my collections are lazy
2) I try to add a record with a duplicate fied value "Name", when I try to do this, a NHibernate.Exceptions.GenericADOException is fired
3) When I try to make a second insert (not a duplicate), the previous insert is still pending and regenrates the same execution
3) ISession.Clear() solves the problems but when I try to access my collection, an exception of a type NHibernate.LazyInitializationException

What can I do please ?

Best regards

When you get an exception the session gets invalid. YOu have to close it and open a new one.

Hi,

What about the already loaded objects ?

P.S : My SessionFlags IsOpen and IsConnected are still to true but in the log, it tells me that the session has been shut down.

These objects are ok, but if you want to update, you have to attach them to a new session.

Hi,

Instead of using db secondary index, is there a way to apply unique constraints on Hibernate rather than the DB layer ?

You can have a look at NHibernate.Validator project. But regardless of the way you implement it, it will probably break lazy-loading, meaning hibernate will load the complete collection for checking the constraint. As an alternative you can implement a function somewhere in your repository, that checks the name before you add the new item to the collection (select id from ... where name = :name).