Setting up JNDI on Tomcat documentation needs improvement

The Setting Up JNDI on Tomcat article could use improvement, especially around expected / best practices around how to “install” the drivers and where.

Specifically, it would be helpful to have more clarification on the following details:

  • Which version of the JDBC drivers should we be adding to the Tomcat lib folder? The latest/best version, the version already bundled with our version of Liferay, or some other version?
  • What are we expected to do with the JDBC driver .jar provided by Liferay? Should we remove it from the default location (tomcat/webapps/ROOT/WEB-INF/shielded-container-lib)? I.e. Is the expectation to end up with just one JDBC driver .jar in tomcat/lib or two JDBC driver .jars, one in each of the locations (tomcat/webapps/ROOT/WEB-INF/shielded-container-lib and tomcat/lib)?

The opening paragraphs attempts to address these questions, but is “too high-level” without enough detail. As a specific example, on our team, out of two team members, one understood the expectation to download the latest JDBC driver jar from the internet and add it to the tomcat/lib directory, leaving the Liferay-provided one in place, and another understood the expectation to be to move the Liferay-provided .jar from its default location to tomcat/lib.