I've been looking at different mechanisms people are using to get around the lazy loading issues when using DAO patterns etc. My problem is that I am using Coldfusion as the presentation layer. I have generated a DTO using Hibernate Tools and I wrote a java DAO to perform CRUD for it. I can use the DAO from Coldfusion just fine, as well as the DTO but of course I need to deal with lazy loading for some relations/collections.
Mostly, I don't see how to translate any of the solutions like "Open Session in View" to something useable by another layer. Can this be done and if so does anyone have any insight.

Thanks.

Have you found a solution yet?
We are also looking for a solution. Maybe opening a session before the coldfusion cfm page is constructed (for example in application.cfm) and then close the session at the end. The DAO's should then use this session.

Another hibernate session should be used for coldfusion Session variables. This session will have to be opened when the user starts a http-session and closed when it times-out or disconnects.

Another solution can be: using Spring, like explained in :
http://www.hibernate.org/110.html

Any comments?

Hi,
I tried the filter route but I always run into some class conflicts because of the fact CF is built on top of Jrun. Hibernate will load up and load a cfg.xml file and perform the mappings at startup but when I am requesting a session I get the class conflicts.

I know Spring can handle this but I am not exactly sure how to integrate Spring into this enviornment (Coldfusion either). I have tried different solutions for various issues such as this I have had and it usually turns into a dead end after losing a few days or weeks investigating or some really funky workaround I am not entirely happy with.

For now I have just decided to write the DAOs as CF Components which handle getting the session. This is highly repetative but we'll see how well the pattern works. I really need to break the session factory out in some sort of global var so hibernate is not loading all of the mappings everytime for each application. I'll post the pattern eventually to get some feeback on the robustness. I don't see any problem with it but maybe some of the experts will see a potential problem.

Thanks,
Troy