If you are using the Oracle SID, the JDBC connection string must be in the format of jdbc:oracle:thin:@::SID; Additionally, the data source connection string cannot be updated directly in the IBM Cognos BI 10.1 interface. You must delete the data source and recreate the data source in Cognos using a connection type of Other type. Jun 20, 2019 A JDBC example to show you how to connect to a Oracle database with a JDBC driver. Tested with: Java 8; Oracle database 19c; Oracle JDBC driver for Java 8, ojdbc8.jar; 1. Download Oracle JDBC Driver. Visit Oracle database website and download the Oracle JDBC Driver.
In my case, this error appeared when I attempted to load a class from a batch file in the Windows command prompt.
“Caused by: java.lang.UnsupportedClassVersionError: (*myclassname*) bad major version at offset=6”
This error indicates that your projects were compiled with a higher level Java compiler than the runtime can support.
Oracle 12c Jdbc Driver
![Cognos oracle jdbc driver oracledriver windows 7 Cognos oracle jdbc driver oracledriver windows 7](/uploads/1/1/9/3/119351543/318722433.jpg)
Firstly, confirm what version of Java is installed on your machine. In Windows, open a command prompt window and enter the following command:
Cognos Oracle Jdbc Driver Oracledriver Installer
java -version
The output will look something like:
java version '1.5.0_22'
Java(TM) SE Runtime Environment (build 1.5.0_22-b03)
Java HotSpot(TM) Client VM (build 1.5.0_22-b03, mixed mode, sharing)
This message confirmed that my runtime environment was Java 5 – but error above was stating the classes had been compiled in Java 6. The next step is to check what version of Java is being used to compile your project. In my case, I was using Eclipse.
![Oracledriver Oracledriver](/uploads/1/1/9/3/119351543/686744194.jpg)
Go to Window > Preferences > Java > Installed JREs and make sure your 5.0 runtime shows up in the list and is checked. If nothing suitable appears in the list of options, then you need to download the correct Java version from the Sun website.
Finally, go to Window->Preferences->Java->Compiler and ensure that your Compiler compliance level is set to 1.5.
Cognos 11 Oracle Jdbc Driver
Hello fellow Cognos Now! enthusiasts. Sorry for the long delay in posting, work has been crazy. Been busy with some interesting stuff, specifically merging data from Salesforce and Oracle ERP systems - not easy (watch for an upcoming blog on this).Also, next week is Cognos Forum at the Rosen Shingle Creek Resort in Orlando! I'll be attending, most likely hanging around the Cognos Now booth, and joining as many workshops as possible. Stay tuned for pics and info from this fun event.
Happy Friday!
-NM