By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,696 Members | 1,522 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,696 IT Pros & Developers. It's quick & easy.

Oracle Simultaneous Sessions Problem

P: n/a
I have created a aspx page that requires me to pull data from multiple
tables in an Oracle DB. The data is pulled down and then stored in
local variables, and then closed and disposed. I have implimented an
error handling to prevent sessions from remaining open and yet I'm
still noticing that sessions to the oracle db are remaining open.

I cannot figure out what is going on. I have gone proceedure to
proceedure looking for poorly terminated connections. Has any one else
experienced this issue?

-Peter

Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I experienced a similar problem recently. It turned out that when
making return trips to the DB that the connection I was using came from
an Oracle connection pool rather than a new connection. In my case, it
seemed like the connection maintained some stateful characteristics
that caused me a lot of grief. Here is how I got around it using the
oracle data provider for .NET.

strCon="user id=<USERID>;data
source=<DATABASE>;password=<PASSWORD>;pooling=fals e"

Hope this helps.

Corey

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.