Adding JDBC Drivers

If you want to use MySQL or Oracle as the JDBC-based SmartMapper service, you need to add drivers separately for design time and runtime.

Procedure

  1. Download drivers from official website:
    • MySQL: mysql-connector-java-5.1.29-bin.jar
    • Oracle: ojdbc6.jar
  2. Copy the drivers to the TIBCO_HOME\bw\6.3\config\design\thirdparty directory.
  3. Optional: If you want to use the database at runtime,
    1. Copy the drivers to the corresponding directories.
      • MySQL:

        TIBCO_HOME\bw\6.3\config\drivers\shells\jdbc.mysql.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.mysql\lib

      • Oracle:

        TIBCO_HOME\bw\6.3\config\drivers\shells\jdbc.oracle.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.oracle\lib

    2. On a command line, navigate to TIBCO_HOME\bw\6.3\bin, run command:
      • MySQL: bwinstall.exe mysql-driver
      • Oracle: bwinstall.exe oracle-driver