More specifically the steps I did to test MySQL connectivity were: 1. Download mysql-connector-java 5.0.4 (from the MySQL website) and put the jar file in /usr/share/tomcat5.5/common/lib. 2. Create the database exactly as in the Tomcat example for MySQL: http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html 3. Create a test webapp (see below). 4. Run Tomcat without a security manager. (Turning on the security manager requires granting the correct permissions, which should be straightforward.) 5. Deploy the webapp with the Ant manager task: "ant install".
(You need to create a build.properties file with the required properties for the manager tasks first. See the Tomcat docs.) The test webapp is attached.
dbtest.tar.gz
Description: application/tgz
pgpyGeAqRRXnX.pgp
Description: PGP signature
