Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 2005 > C# 2005
|
C# 2005 For discussion of Visual C# 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 2nd, 2008, 09:27 AM
Registered User
 
Join Date: Apr 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default ContextSwitchDeadlock was detected

I am programming in VB 2008 using VB script. I have a query that should get me data from Oracle database and fill the table in VB. It usually gets about 4 out of 40 records and then I get this error. If I run this query using TOAD the results are returned in less than 1 minute. There are times when I do not get this error and the table is filled with no issues.
I also tried disabling the ContextSwitchDeadlock through the Debug menu. Then it just hangs.

Any help/advice will be greatly appreciated.



It chokes on the line :
adoDA.Fill(adoDS, TableName)




Public Sub GetOracleTable(ByVal SQL As String, ByVal TableName As String, ByRef adoDS As DataSet, ByVal ConnString As String, Optional ByVal ClearTable As Boolean = True)

Using adoDA As New OracleClient.OracleDataAdapter(SQL, ConnString)

Try

If ClearTable AndAlso adoDS.Tables.Contains(TableName) Then

adoDS.Tables(TableName).Clear()

End If

adoDA.Fill(adoDS, TableName)

Catch ex As Exception

Throw ex

End Try

End Using

End Sub







Similar Threads
Thread Thread Starter Forum Replies Last Post
VS .NET has detected...not running ASP.NET version rstelma ASP.NET 1.0 and 1.1 Professional 17 May 24th, 2008 04:04 AM
ContextSwitchDeadlock was detected akumarp2p C# 2005 1 May 17th, 2007 10:36 AM
web server not detected maniaug81 .NET Web Services 2 February 18th, 2005 08:01 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.