Last updated on AUGUST 01, 2017
Applies to:Oracle WebCenter Enterprise Capture - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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:
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?
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