473,396 Members | 1,772 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

reutilize the database connection without close the connection

dmjpro
2,476 2GB
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
3 1787
r035198x
13,262 8TB
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
2,476 2GB
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
r035198x
13,262 8TB
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

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

Similar topics

4
by: Macca | last post by:
Hi, I have an windows forms application that accesses a SQL database I have a few questions as to connecting to the database. This application will run 24 hours a day. It is a monitoring...
11
by: pradeep_TP | last post by:
Hi all, I have a few questions that I have been wanting to ask for long. These are all related to ADO.net and specifically to conenction to database. 1) If I have opened a connection to a...
2
by: Bryan | last post by:
Hello, I'm just starting to develop in asp.net and i have a question about using a database connection globally in my app. I have set up the procedures for getting all my connection string info...
14
by: Nick Gilbert | last post by:
Hi, I have an asp.net application which runs from a CD-ROM using Cassini. As such, it is single user only. The application connects to an Access database when it is loaded, and keeps the same...
10
by: jt | last post by:
The program works like this: There is a form with a button. When the form is loaded, a separate thread is started which is retreiving/updating data in the database every x seconds. When clicked...
3
by: Martin B | last post by:
Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database...
35
by: Terry Jolly | last post by:
Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection...
4
by: Sierra | last post by:
Problem: Database connections are not being reused properly. SP_WHO2 shows upwards of 200 connections being created per page request. Most connections exist for 60 seconds then close without...
20
by: fniles | last post by:
I am using VS2003 and connecting to MS Access database. When using a connection pooling (every time I open the OLEDBCONNECTION I use the exact matching connection string), 1. how can I know how...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.