Thanks everyone that contributed to this discussion; it really helped me out, and it was excellent to know your personal  experiences on this. As I promised to share Hibernate's thread with you guys here is the link for further follow-ups:

http://forum.hibernate.org/viewtopic.php?t=979018

Sorry for my long absence but I will come back to individual  posts as needed later when I get a chance.