• Manuals

Browse the manual

• Introduction
  • System requirements
  • Licensing
  • Latest improvements
• Installation
  • Quick installation guide
  • Installing the database
    • Download and install a Database Management System
    • Create a new database and user/role
    • Initialize the database
  • Installing and running the Server
    • Installing the Server software
  • Installation modes - console and silent
  • Upgrading an existing installation
    • Upgrading major versions
  • Allowing access through your firewall
  • Downloading a license
    • Windows license download
    • macOS license download
    • Linux license download
    • Download a static license on a non-networked machine
  • Starting and stopping the server
    • Microsoft Windows
    • macOS
    • Linux
  • Installing relevant plugins in the Workbench
• Configuration
  • Logging into the administrative interface
  • Adding locations for saving data
    • Adding a file system location
    • Adding a database location
    • Rebuilding the index
  • Changing the listening port
  • Setting the amount of memory available for the JVM
  • HTTP settings
  • Deployment of server information to CLC Workbenches
• Managing users and groups
  • Logging in the first time and changing the root password
  • User authentication using the web interface
    • Authentication options
    • Managing users using the web interface
    • Managing groups using the web interface
  • User authentication using the Workbench
    • Managing users through the Workbench
    • Managing groups through the Workbench
    • Adding users to a group
• Access privileges and permissions
  • Controlling access to CLC Server data
    • Setting permissions on a folder
    • Recycle bin
    • Technical notes about permissions and security
• Queue
• Status and management
  • User statistics
  • System statistics
  • Server maintenance
• Audit log
  • Customized attributes on data locations
    • Filling in values
    • What happens when a clc object is copied to another data location?
    • Searching
• Appendix
  • Troubleshooting
    • Check setup
    • Bug reporting
  • Database configurations
    • Getting and installing JDBC drivers
    • Configurations for MySQL
  • SSL and encryption
    • Enabling SSL on the server
    • Logging in using SSL from the Workbench
    • Logging in using SSL from the CLC Server Command Line Tools
  • Third party libraries
• Bibliography

Getting and installing JDBC drivers

For MySQL or Oracle databases, the appropriate JDBC driver must be available for the application. If you do not already have the appropriate JDBC driver, it needs to be downloaded from the provider and then placed in the userlib directory in the installation area of the CLC software.

Details for the MySQL JDBC Driver

1. Go to the page http://dev.mysql.com/downloads/connector/j/ to download the driver.
2. Please choose the option Platform Independent when selecting a platform.
3. After clicking on the button to Download, you can login if you already have an Oracle Web account, or you can just click on the link that says No thanks, just start my download further down the page.
4. Uncompress the downloaded file and move the driver file, which will have a name of this form: mysql-connector-java-X.X.XX-bin.jar, to the folder called userlib.

Details for the Oracle JDBC Driver

1. Go to the page http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html.
2. Select the version for your Oracle database version that will work with Java 1.7.

   For example, for 11g, the ojdbc6.jar includes classes for use with JDK 1.7.

   You will need an Oracle account to download the driver.

3. Move the driver jar file to the folder called userlib.

Completing the installation

After the JDBC driver is in the userlib folder, then:

• For a stand-alone Server instance, restart the Server software.
• For a CLC job node setup, the JDBC driver file must be placed in the userlib folder in the CLC software installation area on the master node as well as each job node system. The CLC software needs to be restarted after the driver is placed in this folder.
• If running a grid setup, the JDBC driver file is placed in the userlib folder in the CLC Server software installation area. After the driver file is in place, restart the Server software. This will deploy the changes to the grid workers.

---