• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

breaking of oracle connection

HI ALL:
I have a very common problem
When my program sits idle for more than 30 or more minutes (no communication with Oracle server)
Than my connection breaks up,
Offcourse i do make a check before executing  query but than it make the process a bit slow and i do want to avoid this.
Any ideas??
Hemant
0
corgi1000
Asked:
corgi1000
1 Solution
 
CalronCommented:
Have a separate thread send a simple query every 10 few mintues (less than 30). In taht way you can keep your connection open.
0
 
gmhegdeCommented:
HI
this is probably because the setting in Oracle is that a client gets disconnected if idle for 30minutes
If you are using Database pooling for you application the setting could be for half hour

Ganu
0
 
shyamkumarreddyCommented:
Hi Corgi

Hi I am suggestion for you.

Check your dba for user to have more idle time. Oracle itself will close the connection.

Before u query any object use con.isClosed() before checking it.

I say please check the oracle documentation or dba to increase the idle time
U don't have anything in your hand

Cheers
Shyam
0
 
sudhakar_koundinyaCommented:
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:


--  points to shyamkumarreddy


Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
sudhakar_koundinya
EE Cleanup Volunteer
---------------------
If you feel that your question was not properly addressed, or that none of the comments received were appropriate answers, please post your concern in THIS thread.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now