hibernate: couldn't turn off autocommit

[will zhang]

I'm using hibernate annotations, my database in is MySQL5.0.

I tried to persist a bunch of objects and commit at the end, which means insert all or insert none of them.
For example, I want to insert 10 objects one time, if exception happens at the 9th object, because I didn't do commit, there should be no new data in database. However, I do find the 8 datas. Anyone has experience/solution for this?

BTW, I didn't use Spring. I also used rollback but doesn't work.

The thing is like my save() already commit the transaction without closing the session.

      try{               
          for (Student student : students)
          {      
                 studentDAO.save(student);         
          }//end loop      
          studentDAO.commitTransaction(); //insert to do as one atomic transaction, if failes - DO NOT DO ANY INSERT      
      }catch(Exception e)
      {
         studentDAO.rollback();      
      }finally
      {
         studentDAO.close();
      }    

Here's some of my hibernation configuration:

            config.setProperty("hibernate.connection.pool_size", "10");
            config.setProperty("hibernate.connection.autocommit", "false");
            config.setProperty("hibernate.cache.provider_class", "org.hibernate.cache.NoCacheProvider");                 
            config.setProperty("hibernate.transaction.factory_class", "org.hibernate.transaction.JDBCTransactionFactory");
            config.setProperty("hibernate.current_session_context_class", "thread");    

[Paul Sturrock]

Hibernate doesn't autocommit unless you tell it to. Which storage engine are you using? Not all MySQL engines support transactions.

[will zhang]

Paul Sturrock wrote:Hibernate doesn't autocommit unless you tell it to. Which storage engine are you using? Not all MySQL engines support transactions.

Thanks for reply. But how to check storage engine?

BTW, We have another project which has exactly the same setting as this one. However, autocommit is off on that project, even if I turn it on.

In other words, in project A, autocommit is on regardless of my setting config.setProperty("hibernate.connection.autocommit", "false");

in project B, autocommit is off regardless of my setting config.setProperty("hibernate.connection.autocommit", "true");

It seems config.setProperty("hibernate.connection.autocommit", "false/true"); doesn't do its job at all.