Java Class not found error in report prompt

Document ID:KM03770169
Creation Date:30-Dec-2020
Modified Date:30-Dec-2020
- Micro Focus Products:
  operations bridge reporter 10.40

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

The below error appears in the report: The following database error occurred: (CS) "Java Class not found in classpath: com.vertica.jdbc.Driver". For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)

Fix

Sometimes the vertica.sbo file is overwritten after the upgrade, so we need to make sure it has the following rows:

<DataBases>

<DataBase Active="Yes" Name="HP Vertica 6.1">

<JDBCDriver>

<ClassPath>

<Path>$ROOT$/drivers/java/vertica-jdbc.jar</Path>

</ClassPath>

<Parameter Name="JDBC Class">com.vertica.jdbc.Driver</Parameter>

<Parameter Name="URL Format">jdbc:vertica://$DATASOURCE$/$DATABASE___FCKpd___8lt;/Parameter>

</JDBCDriver>

<Parameter Name="Driver Capabilities">Query</Parameter>

<Parameter Name="Extensions">vertica,jdbc</Parameter>

</DataBases>