Home Knowledge Articles IBM Cognos 8 BI How to check the version of an Oracle JDBC driver?
Follow us on Twitter


Countries

48%United States United States
7.4%India India
7%United Kingdom United Kingdom
5.6%Canada Canada
5.4%Australia Australia

Visitors

Today: 214
Yesterday: 64
This Week: 214
Last Week: 3477
This Month: 8120
Last Month: 12049
Total: 724252


How to check the version of an Oracle JDBC driver? Print E-mail
(4 votes, average 4.25 out of 5)
Monday, 26 April 2010 00:00

Problem
How to determine the version of an Oracle JDBC driver?

Solution
Steps:
1.  Locate the classes12.jar file being used. This is located in: <Cognos Installation Location>\c8\webapps\p2pd\WEB-INF\lib
2.  Make a copy of the classes12.jar file.
3.  Rename the classes12.jar to classes12.zip
4.  Use Winzip or some other file compression tool, extract the content of the classes12.zip to a temporary location.
5.  In the temporary location, locate the file called MANIFEST.MF
6.  Open the MANIFEST.MF file with notepad
7.  Look for the line Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.8" indicates that the version of this JDBC classes12 driver is 9.0.2.0.8.

This Oracle JDBC Driver version, must be exactly same as the version of the Oracle database server were you want to create a metric or content store. Ask the Oracle DBA how to obtain the correct JDBC version is necessary.

www.cogknowhow.com

Comments

Please login to post comments or replies.
 
 

CogKnowHow Newsletter

Newsletter
Please register to the site before you can sign for a list.
No account yet? Register
Banner

Polls

How many users are working on your Cognos environment?