HOWTO setup tomcat5 and mysql java connector jdbc

From Chaos

This article is part of the HOWTO series.

Summary

This was actually extremely easy. This is based on OS X Server 10.3.6 with the latest security patches and Java updates, as well as the latest Xcode tools.

Details

1. Download the latest jakarta-tomcat5.
2. Download the latest mysql-jdbc connector.
3. Uncompress both:

tar -zxvf jakarta-tomcat-<version>.tar.gz
tar -zxvf mysql-connector-java-<version>.tar.gz

4. Move the jakarta-tomcat folder to /usr/local/
5. Make a symlink (more on this later):

cd /usr/local
ln -s jakarta-tomcat-<version> tomcat5

6. Modify the tomcat5/bin/catalina.sh with some tweaks:

# Home.
CATALINA_HOME="/usr/local/tomcat5"

# Options.
CATALINA_OPTS="$CATALINA_OPTS -server -Xms512m -Xmx512m"

# Java.
JAVA_OPTS="$JAVA_OPTS -Djava.awt.headless=true"

# Raise stack size.
ulimit -s 2048

7. Modify tomcat5/bin/startup.sh and tomcat5/bin/shutdown.sh with some additional environmental settings:

export CATALINA_HOME="/usr/local/tomcat5"
export JAVA_HOME="/System/Library/Frameworks/JavaVM.framework/Versions/CurrentJDK/Home/"

8. Go back to wherever the mysql-jdbc connector was decompressed and copy it to '/Library/Java/Extensions/':

cp mysql-connector-java-<version>.jar /Library/Java/Extensions/

9. Done! If you wish, you may add aliases for /usr/local/tomcat5/bin/startup.sh and /usr/local/tomcat5/bin/shutdown.sh, and add an 'alias' for 'restart_tomcat' (this alias syntax is for a bash shell, /etc/bashrc on OS X):

alias stop_tomcat="echo \"Stopping Tomcat5...\" ; /usr/local/tomcat5/bin/shutdown.sh ; sleep 5 ; ps auxwww | grep Java | grep -v grep | awk -F ' ' '{print $2}' | xargs kill -9"
alias start_tomcat="echo \"Starting Tomcat5...\" ; /usr/local/tomcat5/bin/startup.sh"
alias restart_tomcat="stop_tomcat ; echo ; start_tomcat ; echo"