I've been google-ing and searching for the answers to my problem but no luck so far.
I have a JSP application with MySQL database, and one of the form has cascading dropdown list. So here is how the page works. There are 2 dropdown list: Term List and Class List. When the page is loading, it will populate the term list from the database. Based on the user selection on the term, it will run the database query for the Class List to display a list of class under that selected term.
The dropdown list is working just fine. But after doing several selections, the page will just keep loading and the server just died.
Anybody has a suggestion of what could be the problem? Thank you so much for the help.
Joined: Nov 15, 2007
After doing more research, I just changed the maxActive value for the database connection to 100 (it was 8 before), and now everything is working. I have done a lot of selection attempts and so far the site is still up.
My question now: is this just a temporary fix or not? Will this create another problem?