CODEWITHSUNDEEP
c#sql-servernhibernatebulkinsert
Gyanendra Singh
Gyanendra Singh

Reputation: 1005

Transaction not connected, or was disconnected error

I am getting

"Transaction not connected, or was disconnected error"

error when the transaction is either committed/rolled back after doing a bulk insert (along with some other operations).

using(var tran = Session.Session().BeginTransaction(IsolationLevel.Serializable))
    {
       // do something
       fullSession.Session().CreateSQLQuery(query).ExecuteUpdate();// this query bulk insert in a temp db
       // do something else
       tran.Commit()/ tran.RollBack();// if transaction is active and not already rolled back/committed
    }

If the query to bulk insert from a file into a temp database fails, I get this error on tran.Commit/rollback.

Upvotes: 1

Views: 11613

Answers (3)

xxarchexx
xxarchexx

Reputation: 11

I had some problem, but it gone after I close connection in MS SQL Managment studio.

Upvotes: 0

Louis Somers
Louis Somers

Reputation: 2964

I was getting this exact same error using NHybernate while persisting an entity that had a property of type System.Data.SqlTypes.SqlDateTime? (Nullable).

Changing the property to a regular System.DateTime? fixed the problem.

Upvotes: 0

praveen
praveen

Reputation: 12271

Bulk Insert is a combination of Insert statements so if it fails it doesn't roll back the transaction so if you really want to catch the error try using Try and catch block inside BEGIN and END transaction

Upvotes: 1

Related Questions