The following code makes changes to the database, and, if I understand transactions properly, it doesn't seem like it should.

Also, this database is affected irrespective of wether session.getTransaction().rollback() is called.

Any Ieas?

Hibernate version: 3

Mapping documents: Annotations

Code between sessionFactory.openSession() and session.close():

session.beginTransaction();

Course c = new Course();
c.setName("Raferrrr");

session.save(c);

session.getTransaction().rollback();



Full stack trace of any exception that occurs:

Name and version of the database you are using:MySQL 4.1.20-standard

The generated SQL (show_sql=true):
Hibernate: insert into Course (name, level) values (?, ?)

Debug level Hibernate log excerpt:

If your MySQL database is set up with the defaults, you're using MyISAM tables, which are not transactional. In order to use transactions with MySQL, you need to create your tables using the InnoDB table type.

Ryan-