How-To Install MySQL Connector/J on Windows 2003/Plesk 7.5.6
The below is an exact explanation of how to install the MySQL Connector/J in a Windows 2003/Plesk 7.5.6 environment (thought it may apply to other cases on Windows also). The How-To Install provided by MySQL is almost worthless (at least for the Windows side of it) and I have been unable to locate the exact info I have below anywhere else on the web, so please enjoy and bookmark or copy for later use if you want!
1) Download the needed version of MySQL Connector/J from http://www.mysql.com/products/connector/j/ onto the Windows server.
2) Extract the download ZIP file and place the “mysql-connector-java-3.1.12-bin.jar” file in your TOMCAT_INSTALL\shared\lib folder.
3) Edit your TOMCAT_INSTALL\conf\jkconf.ant.xml to make sure the following line is in there:
Once this is done you’ll need to restart your Apache Tomcat or (in this case) Plesk.
[NOTE: TOMCAT_INSTALL is the folder where Tomcat was installed]
Written by: Logan Rogers-Follis on 05-18-2006