Error:"com.ddtek.jdbc.openaccess.OpenAccessDriver cannot be found by" When Creating a Data Adapter for Service Desk in JasperStudio

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

The following error appears in JasperSoft Studio when creating a Data Adapter to connect to Service Desk Manager object layer:

net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: com.ddtek.jdbc.openaccess.OpenAccessDriver cannot be found by net.sf.jasperreports_6.6.0.final
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:173)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)
    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122)

 

Cause

The data adapter cannot find the library needed to establish the connection to SDM object layer

Environment

JasperSoft Studio 6.XX
Service Desk Manager (SDM) 14.1 and later

Resolution

The driver classpath has not been set to find the oajc.jar. Refer to step 6 in the following document to set the driver classpath:


How to configure Jasper Studio for editing existing reports and creating new reports for CA Service Desk Manager data on Jasper Server.