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

reutilize the database connection without close the connection

dmjpro
100+
P: 2,476
My web application sometimes exceeds the maximum open cursors..
My database server is oracle9i.
I want to reutilize the connection without closing the connection.
How can i trap the idle cursors and close those cursors through my program...
Plz help me immediately!!!!!!!!!!!!!!!!!!!!!!
Jan 31 '07 #1
Share this Question
Share on Google+
3 Replies


10K+
P: 13,264
My web application sometimes exceeds the maximum open cursors..
My database server is oracle9i.
I want to reutilize the connection without closing the connection.
How can i trap the idle cursors and close those cursors through my program...
Plz help me immediately!!!!!!!!!!!!!!!!!!!!!!
Post the code for the program using code tags. If it is too long post only the part that does the connections
Jan 31 '07 #2

dmjpro
100+
P: 2,476
thanks for approach.....

I think u didn't understand my problem.
There are so many programmers working in this project...
Some newcomers never close the statement and resutset after executing a query ...
That's why once upon a time the maximum open cursors exceeds..
But still the connection is alive but i want the connection to be reutilized without making a new one...
I want to build a program which constantly requests server ...is maximum opened cursors exceeded or not..If yes then reutilize the connection without closing that connection.
Is there any way to do it...
Plz help me..................
Jan 31 '07 #3

10K+
P: 13,264
thanks for approach.....

I think u didn't understand my problem.
There are so many programmers working in this project...
Some newcomers never close the statement and resutset after executing a query ...
That's why once upon a time the maximum open cursors exceeds..
But still the connection is alive but i want the connection to be reutilized without making a new one...
I want to build a program which constantly requests server ...is maximum opened cursors exceeded or not..If yes then reutilize the connection without closing that connection.
Is there any way to do it...
Plz help me..................
I see. I don't know how to do that without changing the clients code.
Jan 31 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.