Tomcat

Homepage

http://jakarata.apache.org/tomcat

Where to put the JDBC driver

{TOMCAT_HOME}/common/lib/

Creating database connection pool

There are two ways to do this, either by editing the server.xml configuration file found in {TOMCAT_HOME}/conf/ directory, or by logging into tomcat web admin and adding the connection pool there, either as a global data source or as a local web app data source. The latter method is the simplest.

Before logging into the Tomcat web admin, you must configure and add a user with admin privileges in the file {TOMCAT_HOME}/conf/tomcat-users.xml. Below is an example.

<user username="user" password="password" roles="admin,manager" />

Start a web browser and enter http://tomcat_server_host:port/admin and then log in. When logged into the admin, navigate to Resources -> Data Sources using the menu on the left. The choose 'Create New Data Source' from the drop down menu on the right. Fill in everything but the 'Validation Query' field. See database vendor tips for details on the JDBC url and driver format.

How to install a Web Application Archive

Copy the WAR file to {TOMCAT_HOME}/webapps/ and restart the application server.