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

Article Id: 130232

Status: Published

Updated On: 03-04-2019 11:12

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.