HOWTO setup tomcat5 and mysql java connector jdbc
From Chaos
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"
