augblay
asked on
oracle connection not closing
i am accessing oracle database within cold fusion and asp.net. but i am noticeing that oracle is not releasing the connections. when i look at toad i see multiple inactive sessions. can someone point me to the right direction
Are you closing connections? I dont know much about asp.Net but in asp you should close connections.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept RichW's comment as answer.
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Henka
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
Accept RichW's comment as answer.
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Henka
EE Cleanup Volunteer
I forgot about this question. The answer I discovered is to remember to dispose of the reader and/or datadaptor objects along with the connection objects.
Once you dispose of the connection and other data objects the inactive session objects in the Oracle server go away.
RichW
Once you dispose of the connection and other data objects the inactive session objects in the Oracle server go away.
RichW