Hi,
I am using Hibernate 3.2.2 and Websphere 7.5.5.

Hibernate.cfg.xml

<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.datasource">jdbc/merlinDS</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="current_session_context_class">jta</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<property name="jta.UserTransaction">java:comp/UserTransaction</property>
<property name="show_sql">true</property>
<mapping resource="sample/Address.hbm.xml"/>
</session-factory>
</hibernate-configuration>


This is the code

Session sessionObj = HibernateUtil.getSessionFactory().getCurrentSession();
sessionObj.beginTransaction();
String SQL="from sample.ConfigurationOption as configoption";
Query query=sessionObj.createQuery("from sample.Address as addr");
Collection coll=query.list();
System.out.println("size"+coll.size());
sessionObj.getTransaction().commit();

I am getting the exception No TransactionManagerLookup. Any help is appreciated.

Thanks
Sudha

What happens if you use:

org.hibernate.transaction.WebSphereExtendedJTATransactionLookup

In place of <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>