Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have requirement to switch DB connection if one connection is failed to connect.
Sometimes it happens that after fetching 2-3 tables data, Timeout error occurred in fetching data from 4th table.
So on that scenario how to handle to switch DB connection immediately and start fetching the data from 4th table onward again
Hi Push,
I had this type of problem before and also was usually when I dd extractions using a loop.
My suggestion is you using SLEEP(10000)
this causes a pause between the closing of a connection and opening a connection. it does not have to be 10 seconds, you can make it to be 5 seconds. i.e SLEEP (5000);.
Do this between the load of the tables
Thanks Wilson for your reply but in my case SLEEP is not working, after retry it's getting same Timeout error.