'connection rolls back before released back to the pool'

def testRollbackOnRelease(self):

    pool = cx_Oracle.SessionPool(USERNAME, PASSWORD, TNSENTRY, 1, 8, 3)
    connection = pool.acquire()
    cursor = connection.cursor()
    cursor.execute('truncate    table    TestExecuteMany')
    cursor.execute('insert    into    TestExecuteMany    (IntCol)    values    (1)')
    pool.release(connection)
    pool = cx_Oracle.SessionPool(USERNAME, PASSWORD, TNSENTRY, 1, 8, 3)
    connection = pool.acquire()
    cursor = connection.cursor()
    cursor.execute('select    count(*)    from    TestExecuteMany')
    (count,) = cursor.fetchone()
    self.failUnlessEqual(count, 0)
