[Mono-bugs] [Bug 381151] DataAdapter returns 0 rows after an SQL timeout occured

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=381151

User vvaradhan at novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=381151#c21





--- Comment #21 from Veerapuram Varadhan <vvaradhan at novell.com>  2008-04-29 12:07:36 MST ---
While working on the fix, found out that this will still hang - even after the
fix, when you close/open the connection in the catch block of Mark's sample
program.

--- snip code ----
               try {

                SqlDataReader datr = cmd.ExecuteReader();
                Console.WriteLine("Records Affected:
"+datr.RecordsAffected.ToString());
                Console.ReadLine();
                while (datr.Read())
                {
                        Console.WriteLine(datr.GetValue(1));
                }
                //Works OK
                datr.Close();
                }
                catch(Exception exc)
                {
                        Console.WriteLine(exc.ToString());
                        //Console.ReadLine();
                        Console.WriteLine("--DataReader threw exception--"); 
                        cnn1.Close(); 
                        Console.WriteLine("--Closed Connection--"); 
                        cnn1.Open(); 
                        Console.WriteLine("--Reopened Connection--"); 
                }

--- snip code ---


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.