Tuesday, July 14, 2009

Form data submiting error SOLVED!

Finally! I have solved the problem that have prevented me from making any progress of the project. Couple posts ago, I wrote I knew problem was connection error with database - something was wrong to prevent the servlet to connect to the mySQL database. I thought it was problem with mismatched password or limited privilege grant, and I was not able to solve the problem from these two aspects. Yesterday, I finally decided to re-install mySQL database think perhaps it's problem with system that's causing the error. Indeed, I was right!

With first couple failed efforts to reinstall the data, I was even more assured the problem was from the database itself, not me. As now I recall, I was not very successful when I tried to install mySQL database first time when I started the project. That failed installation left some records of the old service, and confused the system when I finally successfully installed the database. For some reason, the system kept referering to the old service from failed installation. I tried to find a way to completely do a clean uninstallation of mySQL; however, I couldn't find any software or method. So, eventually, I decided to manually clean the registry - but that's not a clever idea, for I could with uncarefullness mess up my entire operating system, and force myself to reinstall my operating system completely. I use it was an last resort, but I'm fortunate enough, and was able to successfully erase all records of the old installations. After successfully installing mySQL, testing shows the problem is solved. Horray!

No comments:

Powered By Blogger