Following is the code iam executing from a stateless session bean in Websphere 5.1:

Session s = Singleton.getInstance().getSessionFactory().openSession();
Dept d = new Dept();
d.setName("IT");
System.out.println("Dept ID:" + d.getId());
s.save(d);
System.out.println("Dept ID:" + d.getId());
s.close();

This method is running under CMT but after completion of method execution, the row is not inserted into Database but sequence is get forwarded.

Following is the excerpt from hibernet.cfg.xml:

<!-- Data Source -->
<property name="connection.datasource">jdbc/hrds</property>

<!-- Database Settings -->
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
<property name="show_sql">true</property>
<!--
<property name="use_outer_join">true</property>
-->

<!-- Transaction API -->
<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory
</property>
<property name="transaction.manager_lookup_class">
net.sf.hibernate.transaction.WebSphereTransactionManagerLookup
</property>


Thanx
Muhammad Aamir

Turn on JDBC trace and hibernate debugging as a first line of attack

How ??

repost