Tag: jtds
Installing MySQL and SQL Server Database Drivers
by sonny on Apr.03, 2010, under Java
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