I have been using JSTL's sql calls to build a datasource and retrieve information from a database and then iterate through what I need with c:forEach.
My question is 2 fold.
1. Is there a rule of thumb as far as accessing a database through JSTL or from a
Servlet the best approach. (keeping in mind I do nothing but display the data, no computations, etc)
2. Is there a Tag way to use a ConnectionPool inside of a
JSP page without using scriplets? I am using Resin and I think they may have a tag I can use but can't find the documentation anywhere if there is. (This of course will primarily depend on the answer to the first question.
Thanks.