Has any one implemented command pattern to lazy load object associations and collections in 3-tier application using command pattern? I have referred the book "Java Persistence with Hibernate".

It will be great if you can refer me to an working example. In my application, presentation tier access business/data tier via a proxy. So I can't use a OSIV (Open Session In View) pattern.

TIA

Hi sjhyam,

It is a good thing that you don't use OSIV, all the time the hibernate session is open, you are blocking a precious sql Connection instance. The best way to do things is to load relationships you'll need in the business (controller) layer. If you want to factorize some loading methods to be used by many views, the best way is to pass a String[] argument containing all needed dependencies to your business layer. If a command pattern was able to resolve the problem, I think it'd be directly on the hibernate site for a while. Hibernate is an "old" product, no more best practices are to be descovered or invented.

Regards,
Zied Hamdi

Zied,

I have implemented the same approach. I am sending the eager loaded object to business layer first. Then on demand I am reading the lazy loaded properties with a separate business method. But this way, I have to instruct the other person to look different methods to load data. I am still trying to implement a factory based approach to load the data.

As of now i have solved my problem with a temp solution. But looking for more efficient solution.

Thanks
Shyam