This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have a Web Service that uses a MySQL Database as its storage mechanism.
However, I'm seeing some kind of corruption problem with the database. After not sending anything to the database overnight, I cannot seem to get any data out from the database. However, I am able to write as much data as I want to the database. I have to clear the database and restart my app server for the database to work again.
I checked the validity of the connections and they are valid (they haven't expired).
This problem does not surface if I continue to write data to the database overnight.