(RPA) Support Tip: Connection to DB2 database

0 Likes

On an RPA designer when using the SQL object command to ran flows against a DB2 server, it sent an error related to the driver used.

As a workaround, drivers for db2 (db2jcc4.jar) and MySQL (mysql-connector-java-5.1.35.jar) are needed. It is needed to build this structure on the machines and then copy the driver in each respective location.
For MySQL: microfocus/oo_designer/designer/var/repo/mysql/mysql-connector-java/5.1.35/mysql-connector-java-5.1.35.jar
For DB2: /microfocus/oo_designer/designer/var/repo/com/ibm/db2/jcc/db2jcc/db2jcc4/db2jcc-db2jcc4.jar.

To run the flow on a central the paths are identical but the folders should be central:
Mysql:
microfocus/oo/central/var/repo/mysql/mysql-connector-java/5.1.35/mysql-connector-java-5.1.35.jar 
DB2: microfocus/oo/central/var/repo/com/ibm/db2/jcc/db2jcc/db2jcc4/db2jcc-db2jcc4.jar 

Labels:

Support Tip
Comment List
Related
Recommended