[nhibernate-issues] [JIRA] Created: (NH-2107) Database connection is not closed after rollback in TransactionScope

[NHibernate J. <nh...@gm...>]

Database connection is not closed after rollback in TransactionScope
--------------------------------------------------------------------

                 Key: NH-2107
                 URL: http://nhjira.koah.net/browse/NH-2107
             Project:  NHibernate
          Issue Type: Bug
          Components: Core
    Affects Versions: 2.1.2.GA
            Reporter: William Lai
            Priority: Critical


.Net Framework Version: 3.5
Database: SQL Server 2005

We have just migrated from version 1.2.1 to 2.1.2GA since we need to integrate multiple layer of components using the TransactionScope. After some testing, we find that the database connection increases continuously after every transaction rollback. At the end, all the connections in the connection pool are used up. The problem does not occur in commit case. 

Here is the testing code:

            ISession session = null;
            Test test = null; // Database object

            using (TransactionScope scope = new TransactionScope())
            {

                session = NHibernateHelper.OpenSession();

                Test test2 = new Test();
                test2.Name = DateTime.Now.ToString();

                session.SaveOrUpdate(test2);

                //scope.Complete();

            }

After running the above case, a new connection will be used in SQL Server. The connection will not free up in SQL Server until we close our application.

Any advise for the problem? Thanks in advance.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://nhjira.koah.net/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira