C Configuring JDBC Database Drivers

This appendix describes how to configure additional JDBC database drivers for use on your Oracle DataLens Administration Servers to facilitate interaction between your server and your EDQP supported database. Oracle provides WebLogic-branded versions of DataDirect drivers for DB2 and MySQL Server though they are not configured for use in the classpath. For more information about using WebLogic-branded DataDirect drivers that are included in the WebLogic Server installation and other JDBC database drivers, see Oracle Fusion Middleware Programming JDBC for Oracle WebLogic Server 11g Release 1 (10.3.6) at

http://docs.oracle.com/cd/E23943_01/web.1111/e13726/dd.htm

Note:

You must configure your database driver for use before attempting to establish a database connection on your Oracle DataLens Administration Servers.

Use the following steps to install your JDBC database driver:

1. Download the appropriate JDBC driver for your database or use the WebLogic-branded DataDirect driver.

2. Copy the JDBC driver to the WL_HOME\server\lib\ directory on your Oracle DataLens Administration Server.

3. Edit the following EDQP environment file to configure the driver for use:

   On Linux and UNIX:

   WL_HOME\common\bin\commEnv.sh

   On Windows:

   WL_HOME\common\bin\commEnv.cmd

4. Add the new JDBC driver to the classpath, WEBLOGIC_CLASSPATH, as in the following example that configures the Oracle database, My SQL, DB2, and PostgreS QL drivers:

   set WEBLOGIC_CLASSPATH=%WEBLOGIC_CLASSPATH%;%WL_HOME%\server\lib\ojdbc6.jar;
   %WL_HOME%\server\lib\mysql-connector-java-commercial-5.1.17-bin.jar;%WL_HOME%\server\lib\wldb2.jar;%WL_HOME%\server\lib\postgresql-9.2-1002.jdbc4.jar
   

5. Save and close the file.