Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Need to determine the version of an Oracle JDBC driver

Posted on 2011-09-05
5
Medium Priority
?
919 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 5

Accepted Solution

by:
DerZauberer earned 2000 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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

609 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