aspose file tools*
The moose likes JDBC and the fly likes MySQL Corruption Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL Corruption Problem" Watch "MySQL Corruption Problem" New topic
Author

MySQL Corruption Problem

Ron Patel
Greenhorn

Joined: Apr 11, 2004
Posts: 18
Hi all,

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.

Any thoughts on what could be the problem?
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30929
    
158

Ron,
Does it work if you open a new connection and try to read from it?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Ron Patel
Greenhorn

Joined: Apr 11, 2004
Posts: 18
No. The Control Center freezes too.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30929
    
158

Ron,
It sounds like the database is running out of resources. You would be better off closing the connection as soon as you are done with it to avoid this sort of problem.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: MySQL Corruption Problem