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

Hibernate version:
3.1.2

We have a UserType that executes a session.get to replace the value of a property at load time. This seems to be causing problems with Hibernate. The following exception is thrown during a list() operation on an object containing this custom type, but we only see this exception when the UserType is doing session.get within nullSafeGet:



I can't find anywhere in the documentation where it says that you cannot access the Session from within a UserType's nullSafeGet methods (although this makes some degree of sense to avoid). Can someone please confirm that accessing a Session from within a UserType is not allowed? TIA ~

You're allowed access a session, you're just not allowed use the session that you're currently reading a result set from, to get a new result set. This is not an hibernate restriction, it's a JDBC/DBMS one.

You can use a different session to do it. You can also use the current session to do things that don't touch reseult sets (e.g. isDirty, contains, etc.).

Your design sounds strange.. strange enough that I'll risk using the word "flawed". Why do you have to get a different object? Hibernate already does that sort of thing for you via associations. Changing objects on load risks causing unnecessary saves. And there are other reasons not to do this kind of thing. Have you looked for a different design, one that doesn't involve database accesses during database accesses?