Where can I find an example of good architecture for a high database traffic JSP application using connection pooling?
For example, let's says you have a JSP that has a FORM where a user can type in the name of an movie director. When they click "Submit", they should see a page listing all the movies that the director they selected directed.
A sound implementation of this would be to have the JSP containing the FORM submit to a servlet. The servlet would, in turn, handle all the data retrieval. This includes possibly obtaining a database connection from a pool, determining what class(es) to use to retreive the data, and populating the response/session object with this data (in this case - movie titles). Finally, the servlet would redirect the response to a JSP responsible for displaying these movie titles.
As far as implementing a database connection pool, that is really out of the scope of this FAQ. However, you may find this FAQ answer helpful.