How are the WebCenter Enterprise Capture Client Scripts Stored on the Client Workstations? (Doc ID 2290713.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Goal

Implementing a requirement which includes using a custom script to make a database query. How does the Capture Client script get rendered and stored on the end user machine after the script starts?  Using Document 2171997.1 this requirement can be met. However, there is a security concern in that the script works by putting in all the the database details, including the username, password, host name, port, and service name in plain text for connecting through the JDBC driver manager.  Also, in this document, the instructions state:

Oracle Driver .jar File Installation Instructions

For Capture 11g:
This script requires the Oracle JDBC driver (i.e. ojdbc6.jar) to be installed in the 32-bit Java extensions directory to be usable. On the client Windows workstation this directory is: C:\Program Files (x86)\Java\jre<1.x.y_z>\lib\ext.  If more than one JRE version is installed, it is easiest to copy the .jar file to all versions' folder to ensure proper operation.

For Capture 12c:
Capture 12c installs its own Java libraries, so the directory to copy the driver .jar file on the client Windows workstation is:
C:\Users\{user name}\AppData\Local\Oracle\capture\runtime\jre\lib\ext

 

Why is it necessary to install this jar file on the client workstation?  Is it possible to run this on the server? How does the jdbc driver that is installed on the client machine get the database parameters from the client script?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms