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

  1. 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.
  2. Remove your existing JDBC driver.
  3. 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:
  4. Download the JDBC driver JAR file suited for your Java version from the target location:
    Database vendorJDBC DriverFile to download
    Microsoft SQL ServerMicrosoft JDBC Driver 4.0 for SQL Serversqljdbc4.jar
    OracleOracle JDBC driver 11.2.0.3ojdbc6.jar for Java 6 and Java 7
    OracleOracle JDBC driver 12.1.0.1

    ojdbc6.jar for Java 6

    ojdbc7.jar for Java 7
    IBM DB2IBM Data Server Driver for JDBC and SQLJ (9.7 GA)db2jcc.jar
  5. 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).