Hibernate: 2.1

Database: Informix 7.2

I am trying to move some values between rows which happen to be unique. I am setting the values inside of a transaction but when I commit the transaction I get a uniqueness constraint violation due to the fact that Hibernate is trying to do the work in the wrong order, thus violating my constraints. Infomix supports deferred constraints but only inside of the context of a transaction, and when I try to do this I get an error saying that I am not in a transaction (apparently, even though I have asked hibernate to open a transaction it has not actually done it yet).

Any help and/or suggestions appreciated!

Once again, i think i answered my own question. The answer seems to be an intermittent flush. Not ideal, but it solves the problem.