MySQL JDBC JSP Example on Sphera Tomcat

1. Copy mysql-connector-java-3.0.8-stable-bin.jar to your /var/tomcat/common/lib Directory
2. Restart Tomcat from the command line using ssh with:

   /etc/rc.d/init.d/apachectl restart
   

3. Make sure that you have enabled remote access for your MySQL database. (This requires an IP address)
4. Copy this code to a file named mysqljdbc.jsp in your /var/tomcat4/webapps/hw Directory. Be sure to replace IP_ADDRESS with your Database's External IP address. For this example you will need to add a table to your test database named "foo".
5. Call your jsp page from within a web browser like: http://www.yourdomain.com/hd/mysqljdbc.jsp

• mysql-connector-java-3.0.8-stable-bin.jar
• example_code.txt