Link to home
Start Free TrialLog in
Avatar of Williams225
Williams225

asked on

Need to determine the version of an Oracle JDBC driver

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
ASKER CERTIFIED SOLUTION
Avatar of DerZauberer
DerZauberer

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Williams225
Williams225

ASKER

ok thanx, what is the command to locate it?
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.
not working, i am using solaris
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial