data refresh after every 24 hours

Question

I have developed an application using websphere6.1 which is required to query the database(oracle) after one day(24hours) periodically. But the it is not getting executed properly since I am getting an dataaccess exception.I am using connection pooling and spring jdbc.I wonder why this is happening since the test for smaller time intervals (say) 25 mins is running successfully.Is the connection with database getting dropped or do I need to adjust some parameters to get the output .

Answer 1

I had spend a while trying to figure out how to fix it. Finally, in my case the problem was related to stale connections. I saw StaleConnectionException in SystemOut.log after 24 hours. I found the answers here.

Good luck!