Error:"com.ddtek.jdbc.openaccess.OpenAccessDriver cannot be found by" When Creating a Data Adapter for Service Desk in JasperStudio
book
Article ID: 130232
calendar_today
Updated On:
Products
CA Service Management - Asset Portfolio ManagementCA 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)
Environment
JasperSoft Studio 6.XX Service Desk Manager (SDM) 14.1 and later
Cause
The data adapter cannot find the library needed to establish the connection to SDM object layer
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: