How Long a connection Object is valid before time out ?
Chandra A Sekhar
Joined: Dec 11, 2000
We have a strange problem, we have 9 different threads accessing one table (ofcourse thro a synchrnized DBClass method) , each time each thread needs around 2-3 mins and thread will come back in 30 mins. In other words this is more of a continuous process. Once in a week we need to clean up the complete table during that process our clean up procedure will archive all previous weeks data on to archive data base. My question here is the archivel process takes some time (about 30 mins) during that process my 9 threads will try to write on to that table and they will keep waiting for clean up procedure to leave the lock , so here can anybody tell me how much time will that connection be valid and how much time it waits or keeps polling for a write access on to that table ? Some times all 9 threads die at this very particular time so we are suspecting that some thing is going wrong during thar process.!! Any input will be greatly appreciated