Hello together,

Im working on a developing a webapplication with Spring 3.0.5, Hibernate 3.6. and mySQL Community Server 5.1. I have a question regarding the transaction management.

1) First of all: is it correct, that when you use hibernate you MUST use transactions? there is no way to avoid that transactions must be used? I read that all over the internet, but I thought that the database itself would be responsible for transactions, not hibernate. (I read so often, that hibernate needs to use transactions always, even when only reading data, but its mySQL which provides the implementation of transactional behaviour)

2) If I must use transactions with hibernate, how is it then possible that myISAM storage engines can be used? they don't support transactions so I dont understand why its possible to use them.

3) I researched if its possible to use both together, myIsam and innoDB, in one hibernate application. is it correct, that it is possible by defining two different session factories (working on the same database, but with different tables?) Im not sure if thats a good solution.

It would be great to get some answers! thank you! :-)