Hi,

I am using Hibernate and Firebird (via Spring). I basically need a full table lock, and so need to grab the Connection object, cast it to a FirebirdConnection object, and set some Transaction settings on it as their mapping of Serializable Isolation does not include a full table lock (we are using Firebird Connection pool to allow us access to the actual Firebird connection).

I have successfully created a transaction with the right settings using JDBC correctly, and am having trouble using that single connection in a Hibernate transaction that spans numerous calls to read / write to the database. When I look at the Hibernate debug statements, it appears that multiple connections are being used.

I would be most grateful if someone could guide me to how to do this, as I am quite confused, and seem to be going in circles. Can I use hibernateTemplate? or do I need to use doInSession/doInTransaction? What settings should I use in the TransactionInterceptor? Using JDBC, the transaction is started when the first statement is executed - how does session.beginTransaction() affect this?

Many thanks,

David

http://sandbox.sourcelabs.com/kosta/hb- ... ation.html

I suggest not to use HibernateTemplate, it is wery ineffective.