Sonny’s Blog

Note - This assumes that Tomcat is installed in c:\tomcat and the JDK is installed in C:\Program Files\Java. If you have installed these file in other locations, you will need to change your ClassPath accordingly.

Note: all these drivers, java servlets and jsp APIs are included. There is no harm in including these, even if your not using them.

For all –

1)    Create folder: C:\jdbcDrivers
2)    Make the a ClassPath in Environment Variables  if one isn’t already there. (Right click My computer> Properties>Advanced> Environment Variables  button).
3)    Add the following into the value.:

.;..;..\..;C:\jdbcDrivers\mysql-connector-java-5.1.12-bin.jar;C:\jdbcDrivers\sqljdbc.jar;C:\jdbcDrivers\ jtds-1.2.5.jar;C:\tomcat\lib\servlet-api.jar;C:\tomcat\lib\jsp-api.jar;C:\tomcat\lib\el-api.jar;C:\Servlets+JSP

MySQL

1)    Get mysql-connector-java-5.1.12-bin.jar from http://dev.mysql.com/downloads/connector/j/ . Download the mysql-connector-java-5.1.12.zip file.
2)    Extract the zip file. Copy the mysql-connector-java-5.1.12-bin.jar file
3)    Copy  mysql-connector-java-5.1.12-bin.jar file into the following files:

C:\jdbcDrivers
C:\tomcat\lib
C:\Program Files\Java\jdk1.6.0_18\jre\lib\ext

SQL Server - jdbc
1)    Get the driver from http://www.microsoft.com/downloads/details.aspx?familyid=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en
2)    Agree to the license and download the sqljdbc_1.2.2828.100_enu.exe file
3)    Extract the zip file and navigate to \Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu
4)    Copy sqljdbc.jar into the following files:

C:\jdbcDrivers
C:\tomcat\lib
C:\Program Files\Java\jdk1.6.0_18\jre\lib\ext

SQL Server – jtds
1)    Get the driver from http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download
2)    Extract the zip file an copy the jtds-1.2.5.jar into the following locations:

C:\jdbcDrivers
C:\tomcat\lib
C:\Program Files\Java\jdk1.6.0_18\jre\lib\ext