Troubleshooting
Problem
In IBM Cognos Analytics, the JDBC driver (JAR) files must be located in the
Environment
The old locations are:
<ca_location>/webapps/p2pd/WEB-INF/lib
<ca_location>/v5dataserver/lib
The Java Runtime Environment (JRE) used by Cognos Analytics places the <ca_location>/drivers folder at the end of the class path that Java uses to load the JAR files from. When the JRE attempts to load a driver class name, it searches the class path for a JAR file that includes that class.
As of Cognos Analytics 11.0.5, when testing a data source connection in the administration component, an information message is displayed when a JDBC driver file was loaded from the deprecated location. If the driver was loaded from the <ca_location>/drivers folder, no message is displayed.
As of Cognos Analytics 11.0.6, an exception is thrown if a JDBC driver file was loaded from the old location.
If Cognos Analytics detects that a driver file is being loaded from the old folders, the administrator should remove the JAR files from those folders and ensure that the files are moved to the <ca_location>/drivers folder.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22001003