Updating database client software
As part of your upgrade, replace your JDBC driver with a new one. You must download the new driver rather than copy them from the installation media, for legal reasons.
Procedure
- Access the Web application or file system location used by your Web service or Java process, and go to the location of your JAR files.
- Remove your existing JDBC driver.
- Depending on your database vendor, go to a Web page that lets you download a JDBC driver.
You can download JDBC drivers from the following locations:
- Oracle: download the JDBC Driver 12.1.0.1 from this location: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
- SQL Server: download the JDBC Driver 4.0 from this location: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11774
- DB2: the JDBC driver is included with your DB2 installation.
- Download the JDBC driver JAR file suited for your Java version from the target location:
Database vendor JDBC Driver File to download Microsoft SQL Server Microsoft JDBC Driver 4.0 for SQL Server sqljdbc4.jar Oracle Oracle JDBC driver 11.2.0.3 ojdbc6.jar for Java 6 and Java 7 Oracle Oracle JDBC driver 12.1.0.1 ojdbc6.jar for Java 6
ojdbc7.jar for Java 7IBM DB2 IBM Data Server Driver for JDBC and SQLJ (9.7 GA) db2jcc.jar - If all of the following apply:
- You are upgrading from SDL Tridion 2011 SP1 HR2
- You have set up integrated security
- You use a Microsoft SQL Server database
then also update the file sqljdbc_auth.dll, available as part of Microsoft JDBC Driver 4.0 for SQL Server (the same download as for sqljdbc4.jar).