Hi,
I have a question about using Hibernate (2.1.3) + second level cache within a webapplication running inside of Tomcat (5.0.24). I use MySQL 4.x as my RDBMS. No clustering is used and no other system updates the database from "another way in" then the "Tomcat way".

I use EHCache as my cache provider and I have set transaction factory to
net.sf.hibernate.transaction.JDBCTransactionFactory.

This "seems to work", but when reading the docs this should not be used, also I get some log-entries indicating that second-level-cache should not be used without JTA.

My wish is to be able to use "Tomcat-only" + second-level cache due to the simplicity of things. I guess that one way would be to utilize Spring for transaction management but at this stage my project has gone to far to make that level of refactoring.

Is it possible to use second-level cache with this setup?

What could go wrong ignoring these warnings and combnie JDBCTransactionFactory with second level cache?

Thanks // Torben Norling