Oracle® Enterprise Data Quality for Product Data Oracle DataLens Server Installation Guide Release 11g R1 (11.1.1.6) Part Number E29137-05 |
|
|
PDF · Mobi · ePub |
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:
Download the appropriate JDBC driver for your database or use the WebLogic-branded DataDirect driver.
Copy the JDBC driver to the WL_HOME
\server\lib\
directory on your Oracle DataLens Administration Server.
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
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
Save and close the file.