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.
This week we would like to showcase Label A's ColdBox case study. They have some excellent applications and products based on the ColdBox Platform that is really awesome work. Their case study can be found here:
