search cancel

SQLJob and 'GENERICJDBC DB-Type Connection


Article ID: 243592


Updated On:


CA Automic Workload Automation - Automation Engine


The database connection objects created using GENERICJDBC connection type to the Oracle RAC database. The jobs using the specific connection objects failed with the following message -

2022-06-08 10:21:59 - U02012000 Agent DB-Type 'ORACLE' doesn't match Connection DB-Type  'GENERICJDBC'.
The DB connection type ORACLE works fine. However, it does not support fully functional Oracle RAC connections.

The VARA objects using the same connection objects using GENERICJDBC run fine.


Release : 12.3, 21.0 and higher

Component :


The database agent can only take single database connection type at a time. The problem appears if the database connection objects created using different database type other than what agent is configured to accept.


Login to the agent machine with an appropriate privileged account.

Stop the agent.

Go to agent install directory and open the agent configuration file (ucxjsqlx.ini) for edit.

Update the property "type=GENERICJDBC" and save the file.

Restart the agent 

Additional Information

Agent SQL -Structure of the INI File ucxjsqlx.ini