Absent Member.. JasonCantrell Absent Member..
Absent Member..
214 views

[OO Tip] How to enable MySQL Connector for the JDBC operations in OO 10

Problem:

How to enable the MySQL connector for the operations found at "Library/Operations/Databases/JDBC" using Operations Orchestration (OO) 10.00.

 

Solution:

To enable the MySQL connector for the operations found at "Library/Operations/Databases/JDBC"  on OO 10.00:

1. In Studio, the MySQL JDBC driver needs to be copied to %STUDIO_HOME%/debugger/lib

2. Restart Studio

3. In Central, Edit and add a line to file %CENTRAL_HOME%/conf/central-wrapper.conf
Example: "wrapper.java.classpath.4=<path_to_MySQL_connector>" (for example: wrapper.java.classpath.4=c:\mysql-connector-java-5.1.25-bin.jar) and then restart HP OO Central service

If the database type is not in the SQL Database Type selection list, update the selection list to include, for example, MySQL or just assign the 'DbType' input to the value 'MySQL', if a Selection List is used, otherwise just add MySQL as the value for DbType.
In OO 10.0 dbClass and dbURL inputs do not need to be set, like it was done in 9.0.

 

Direct link to the document here:

http://support.openview.hp.com/selfsolve/document/KM00705817

HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Labels (2)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.