This content has been marked as final. Show 3 replies
I'm not quite sure I understand your question. If you want to open only a single connection and use only that connection, you'll have to do that in your code.
What is your DBA complaining about exactly though? Do you accumulate sessions, is that why he/she is concerned? You have idle sessions not being used? How many sessions? etc.
I'd check to make sure your code is cleaning up properly, and use connection pooling if you're not already.
Hope it helps,
Well i have an applicationt that connects and disconnect about 2400 times a day. I tried to ask about connection pooling here but i didnt get any response I think this can help me but i dont quite understand what is doing. i end my sessions and my connections everytime the application is done processing but he suggested I just stay connected and use that connection for everytime my app runs.
I hope i make sense.