Hi all,
I want to configure my hibernate for JBoss. i have given hibernate.cfg.file contents below. My problem is that, when I call tx.commit, nothing is commited to Database. No add/update/delete operation gets reflected in tables

my Code is as simple as below:


Session currentSession = HibernateUtils.currentSession();
Transaction tx =currentSession.beginTransaction();
currentSession.save(myObj); //myObject is Dataobj
tx.commit();
currentSession.close();

Please can anybody tell me why data is not getting saved to DB?
Thanks in advance


Hibernate version: 3.0

Mapping documents: <property name="connection.autoReconnect">true</property>
<property name="connection.autoReconnectForPools">true</property>
<property name="connection.is-connection-validation-required">true</property>
<property name="show_sql">true</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_statements">50</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
<property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
<property name="hibernate.cache.use_query_cache">false</property>
<property name="hibernate.cache.use_second_level_cache">false</property>
<property name="jta.UserTransaction">UserTransaction</property>


Name and version of the database you are using: MySQL 5.0

I've already experienced this one. Try using the session.flush(). Then don't forget to close the session. Try looking at the logs. When you something like:

skipping auto-flush due to session closed

It only means that you all the transactions (add/edit/delete) were already there but not directly applied to the database itself.[/code]