Executing native SQL within the same transaction

Legga · **Joined:** Thu Jun 30, 2005 10:29 am **Posts:** 4

Good day,
I have to execute session.save() and my stored procedure in the same transaction.
My stored proc doesn't return resultset - it is used for update/insert.
This sort of stored procs is not supported by Hibernate through native SQL queries. So, I use session.connection().
But apparently, my stored proc is NOT executed in the same transaction.

Am I doing something wrong or this is the way it supposed to be?

I configured session factory with hibernate.current_session_context_class=thread.
and get session using factory.getCurrentSession()

Hibernate ver. 3.1.2
MS SQL Server 2000

I'd appreciate any help
Thanks!

max · **Posted:** Tue Oct 31, 2006 6:42 am

h3.2 has support .executeUpdate() with native sql.

baliukas · **Posted:** Tue Oct 31, 2006 9:09 am

Probably "autocommit" is on, "session.connection()" works without problems.

Legga · **Joined:** Thu Jun 30, 2005 10:29 am **Posts:** 4

max wrote:

h3.2 has support .executeUpdate() with native sql.

Thanks! That'll solve all my problems.

P.S. the autocommit is off, but thanks anyway =)