Solved

Need to determine the version of an Oracle JDBC driver

Posted on 2011-09-05
5
895 Views
Last Modified: 2012-05-12
Hello I need to find the version of an oracle jdbc driver.

I have used the method bellow , but i can't find it please help!!



•      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.

•      Check in the crontab for DB BACKU SCHEDULE
0
Comment
Question by:cismoney
  • 3
  • 2
5 Comments
 
LVL 5

Accepted Solution

by:
DerZauberer earned 500 total points
ID: 36483730
The *.jar for the Oracle driver can have different names, e.g. ojdbc14.jar, ojdbc5.jar or ojdbc6.jar.
Well it should always be a *.jar file that contains a zipped file named "OracleDriver.class", so maybe you can search for a *.jar with "OracleDriver.class" in it.
0
 

Author Comment

by:cismoney
ID: 36483789
ok thanx, what is the command to locate it?
0
 
LVL 5

Expert Comment

by:DerZauberer
ID: 36484067
Something like this should do:

findstr /M /C:OracleDriver.class /D:<Cognos Installation Location>\c8\webapps\p2pd\WEB-INF\lib *.jar

You can use /S option to search subdirectories.
0
 

Author Comment

by:cismoney
ID: 36484110
not working, i am using solaris
0
 
LVL 5

Assisted Solution

by:DerZauberer
DerZauberer earned 500 total points
ID: 36484154
Ah i only saw the backslashes and thougt you are on windows box.
Ehm you have winzip on solaris box? ^^

cd <Cognos Installation Location>\c8\webapps\p2pd\WEB-INF\lib
grep -rl "OracleDriver.class" *.jar
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question