I am going ahead using Hibernate :-) and integrate it with my EJBs .
I have a question : Hibernate provides its own SessionFactory , Transactions .. But I dont want to use them. If I am using a Session Bean(CMT) then all my transaction handling is already done by the container. I dont want to mess my code with all transaction and exception handling doing rollback commit etc. This is VERY IMPORTANT

Please let me know is this possible? I dont want code like calling begin transaction and rollback.

sf = cfg.buildSessionFactory();
session = sf.openSession();
tx = session.beginTransaction();


If any examples demonstrating these kinda stuff...pls let me know..

If you are in a CMT, then set the datasource as your connection provider,

and don't use hibernate Tx API, It'll work fine

Thanks emmanuel . It worked fine.