I was working on setting the transaction isolation level for the first CF9 ORM application I have put into production and thought I would share what I learned.
The first thing I learned is that by default, hibernate will use whatever isolation the datasource it is using has set. In the drivers Coldfusion uses for MSSQL, the default is TRANSACTION_READ_COMMITTED.
What I needed for my application was TRANSACTION_READ_UNCOMMITTED, so I knew that this had to change. I researched how to change it at the datasource level, but couldn't find a "quick and dirty" way to do that, so I decided that since this application was using hibernate ORM, I would set it there. If anyone of you knows how to change this setting at the datasource level on CF9, feel free to chime in. I know how to change it on CF 6/7, but that doesn't work on CF 9.