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


Countries

49.3%United States United States
7.4%India India
6.9%United Kingdom United Kingdom
5.2%Australia Australia
5.1%Canada Canada

Visitors

Today: 503
Yesterday: 589
This Week: 1923
Last Week: 2932
This Month: 9650
Last Month: 12457
Total: 543468


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?
 
cognos  ibm  cam  error  data  object  manager  crp  content  def  file  rqp  sds  req  request  source  store  specified  database  invalid  level  occurred  service  sys  cognoscnc  dimension  user  query  unable  type