Hibernate version:3.0


If MSSql Server 2000 encounters a syntax error it automatically rolls back the transaction without the rollback ever getting to hibernate

For example:

create table t1 (a int Primary key )

begin tran

insert into t1 values("test")

--never gets here
insert into t1 values(1)
commit tran



Hibernate's transaction never gets the information of rollback.

The relevant code would be

tx=session.beginTransaction();

try
{
session.save(entity);
tx.commit();
}
catch(Exception e)
{
//throws new Exception because transaction on sql server
//is rolled back
tx.rollback();
}


Any way we could overcome this issue?

Thanks