Thursday, 8 October 2009

Quick unix command to determine JDBC driver version

Thought this was alot easier then extracting the actual JDBC JAR file and viewing META-INF/MANIFEST.MF. Of course you can still use the JDBC API via DatabaseMetaData, but normally you don't need to go to that effort.

UNIX

> unzip -p ojdbc14.jar META-INF/MANIFEST.MF | grep -C 1 version

WINDOWS

> unzip -p ojdbc14.jar META-INF/MANIFEST.MF

Note: If you have grep.exe for windows you could use this.

> unzip -p ojdbc14.jar META-INF/MANIFEST.MF | grep -C version

Output (Unix demo)
------------------------

[oracle@beast lib]$ unzip -p ojdbc14.jar META-INF/MANIFEST.MF | grep -C 1 version
Manifest-Version: 1.0
Implementation-Version: "Oracle JDBC Driver version - 10.1.0.5.0"
Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"
Specification-Version: "Oracle JDBC Driver version - 10.1.0.5.0"
Implementation-Title: "ojdbc14.jar"

If your using 11g JDBC driver then you can do it as follows.

http://theblasfrompas.blogspot.com/2007/09/fast-way-to-determine-exact-11g-jdbc.html

14 comments:

  1. Great blog! I truly love how it’s easy on my eyes and the details are well written. I am wondering how I could be notified whenever a new post has been made. I have subscribed to your rss feed which ought to do the trick! Have a nice day!

    ReplyDelete
  2. Useful publication and excellent presentation!

    ReplyDelete
  3. I twitt it. I very enjoy entertaiment indutry in this country.
    Bob Siris, New york

    ReplyDelete
  4. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts

    ReplyDelete
  5. Glad I detected this on google .

    ReplyDelete
  6. Hello, it really interesting, thanks

    ReplyDelete
  7. Hello. It's good news !

    ReplyDelete
  8. Your site is really good and the posts are just wonderful. Thank you and keep doing your great work.

    ReplyDelete
  9. very nice post, i certainly love this website, keep on it

    ReplyDelete

  10. Good day! This is my 1st comment here so I just wanted to give a quick shout out and say I truly enjoy reading through your blog posts.

    ReplyDelete

  11. Sweet blog! I found it while surfing around on Yahoo News.

    ReplyDelete

  12. I will be sure to bookmark it and come back to learn extra of your useful info. Thank you for the post. I will certainly return.

    ReplyDelete

  13. Your writing style has been amazed me. Thanks, very nice post.

    ReplyDelete