Cognos Oracle Jdbc Driver Oracledriver
The normal way to use a JDBC driver is to have the driver on the application classpath, and simply specify the right driver URL. JDBC 4.0 (Java 6) or higher compliant drivers will be automatically loaded from the classpath (as specified with -cp, the Class-Path manifest entry etc). On an unrelated note, oracle.jdbc.driver.OracleDriver is. Oct 09, 2015 Hi Rajitha, I just found the place where I can create a DataSource connection as you were mentioning. I went into IBM Cognos Administration Configuration tab clicked on to get the form to create a Datasource connection. But when I tried to Test a MySQL connection that I created, it says: 'Failed XQE-JDB-0004 A problem occurred finding the driver class 'com.mysql.jdbc.Driver'.
Test data source connectivity on Oracle data source using few Oracle users fail in DQM mode. Below error is observed in XQE logs and Cognos portal:XQE-DS-0014 Unable to logon to the data source. An unexpected error from the JDBC driver 'oracle.jdbc.driver.OracleDriver':'java.lang.RunTimeException:java.lang.NullPointerException'.-There are few Oracle users with which the data source connectivity test succeeds.-All the Oracle users discussed here has same roles and privileges.-Connectivity to Oracle(Using both type of users using which the data source connectivity test succeeds and fails) in JDBC mode succeeds on Cognos machine. Steps to resolve the issue:-1. Check the exact version of the Oracle Database server.
Confirm for the supported version of Oracle JDBC driver on Oracle website.2. Identify if the ojdbcX.jar jdbc driver files have been placed at the right location by following the below steps:2.a) Execute below command in DOS window. Take me to the king youtube video. Make sure your current working directory is Cognos Install Dir.dir /a-d-h /od /s cogfilesorted.txtThe output would be written to cogfilesorted.txt file.2.b) Search for string ojdbc in the cogfilesorted.txt, in order to figure out the location of the jar files. Any location other then the below mentioned location is considered as incorrect location for jar files.webappsp2pdWEB-INFlibv5dataserverlib3. Remove unsupported version or unwanted ojdbc jar files(For example:- If ojdbc6.jar is supported then all other versions of Jar files like ojdbc5.jar, ojdbc7.jar should be removed) from all the unwanted locations.Also you should not have multiple version of the same jar files at the same location.4. If the Jar file is missing from any of the location mentioned in point(2.b) then you need to copy the right jar files at the location.5.
Cognos Could Not Load Driver Oracle.jdbc.oracledriver
Restart Cognos services.6. Test the datasource connection. It should now be successful.
Hi all,I got a problem that I can not solve for a few days.I created a simple class to connection to an Oracle database. It worked fine as the code returned a 'connection successful' message.
I then zipped up the file and save it on a disk. So, is the 'could not load driver' message a polite version of a ClassNotFoundException? If that's the case then the JVM obviously can't find the driver class in your classpath. Is the driver in classes12.zip? Really double-check.
Oracle Jdbc Driver Versions
What's the idea of having./lib on the classpath? Have you tried running with -classpath on the command line?
Do you stil have your original before you put it on disk? Does that still work? If so have you tried to run a diff?Anyway, I hope this gives you some ideas but I can't see any obvious reason why it isn't working for you.Jules.