Hi.

My company has an application built on Spring and Hibernate + JPA. Because of a legacy application that uses the same db and tables, we globally set our isolation level to 0 in context.xml. What we are seeing is that every select statement from the hibernate app is producing entries in our database's transaction log. The result of this is a log file that grows too fast. Ideally we would like to turn off this logging completely, but have failed to find a way to do so.

Any suggestions?

Sample of the log

--CONNECT-1001-0014636195-csdbo-2012/nov/28 09:13
--BEGIN TRANSACTION-1001-0014636208
BEGIN TRANSACTION
go
--SQL-1001-0014636209
set option csdbo.Isolation_level = '0'
go
--COMMIT-1001-0014636259
COMMIT WORK
go
--BEGIN TRANSACTION-1001-0014636260
BEGIN TRANSACTION
go
--SQL-1001-0014636261
set option csdbo.Isolation_level = '0'
go
--COMMIT-1001-0014636311
COMMIT WORK
go