I have a class Evenement and a class Utilisateur which are mapping into a Evenement's Mysql table and a Utilisateur's Mysql table as following :

<class name="com.cfort.calendrier.Evenement" table="evenement">
<id name="id" column="id">
<generator class="hilo"/>
</id>
<property name="moment" type="string" length="12"/>
<property name="debut" type="string" length="10"/>
<property name="fin" type="string" length="10"/>
<property name="titre" type="string" length="40"/>
<property name="description" type="string" length="200"/>
</class>
<class name="com.cfort.utilisateur.Utilisateur" table="utilisateur" >
<id name="identifiant" column="identifiant" type="string" length="20">
<generator class="assigned"/>
</id>
<property name="dateAbonnement" type="date"/>
<property name="datePaiement" type="date"/>
<property name="modeReglement">
<column name="modeReglement" sql-type="varchar(30)"/>
</property>
<property name="nbPoints" type="integer"/>
<set name="evenements">
<key column="utilisateur_numero"/>
<one-to-many class="com.cfort.calendrier.Evenement"/>
</set>
</class>

When i insert a evenement with the code as below :

public void insererEvenement(Evenement evt) {
try
{
Session session = HibernateDAOFactory.creerConnection();
Transaction tx = session.beginTransaction();
boolean toggleAutoCommit = session.connection().getAutoCommit();
System.out.println("Valeur de toggle" + toggleAutoCommit);
session.save(evt);
tx.commit();
}
catch(Exception e)
{
e.printStackTrace();
}

}
[/code]

i have the error :

java.sql.SQLException : can't call commit when autocommit=true

while the toggleAutoCommit's value return false

Can you explain to me what wrong because this kind of code works well
in others circumstances

I would like to specify

Read this:

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

I read this and done it but it does not work.
The method getAutoCommit() return false but i have always the message
can't call commit when autocommit=true

WHY ?

Then, if getAutoCommit() returns false, and you get an Exception saying that autocommit is on, the return value of getAutoCommit() is not correct? Please, try to verify this problem without Hibernate. I don't know where to continue, also because you don't show the full stack trace of your error.

Try a better database with real transaction support.

which i don't understand is that the code i have written works well in the context of the application with others objects map in the same database.

Try to isolate the problem by removing all unnecessary code.

I had a similar problem but it got fixed when i changed the generator from hilo to "identity".

Any clue?

cheers
sushil

As per the doc, hilo algorithm cannot be used within Tx context