469,924 Members | 1,361 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,924 developers. It's quick & easy.

ASP.NET Hangs While Opening A Connection To An Oracle Database


Just wondering if anyone's heard of this issue.

It relates to accessing an Oracle 9i database from ASP.NET 1.1. The
first time you do this (e.g., run a sproc) it works fine. However
doing this multiple times causes ASP.NET to freeze permanently. Its
memory consumption increases and its CPU usage hangs at around 50%.
The only way to proceed afterward is to use the Windows Task Manager
to close the ASP process.

In code, the reason behind the freeze is that when Open() is called on
a System.Data.OracleClient.OracleConnection object, a null reference
exception is thrown - even though the object does not appear to be
null!

Is this familiar to anyone? If so, are you aware of any causes or
solutions?

Apr 24 '07 #1
1 2003
Connection pooling with Oracle doesn't appear to be that reliable and it may
be connected to that as the provider can run out of connection threads. I
have heard of people manually setting the pool to be off using pooling=false
inthe connection string, and ensuring they close the connection at the end
of each page request.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
<s_*******@telus.netwrote in message
news:11**********************@c18g2000prb.googlegr oups.com...
>
Just wondering if anyone's heard of this issue.

It relates to accessing an Oracle 9i database from ASP.NET 1.1. The
first time you do this (e.g., run a sproc) it works fine. However
doing this multiple times causes ASP.NET to freeze permanently. Its
memory consumption increases and its CPU usage hangs at around 50%.
The only way to proceed afterward is to use the Windows Task Manager
to close the ASP process.

In code, the reason behind the freeze is that when Open() is called on
a System.Data.OracleClient.OracleConnection object, a null reference
exception is thrown - even though the object does not appear to be
null!

Is this familiar to anyone? If so, are you aware of any causes or
solutions?

Apr 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Hai Ly Hoang \(MT00KSTN\) | last post: by
3 posts views Thread by Tor Erik Soenvisen | last post: by
4 posts views Thread by =?Utf-8?B?U3RlcGhhbmllIERvaGVydHk=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.