Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2006
    Posts
    97

    Unanswered: How do I find out What JDBC driver I had.

    and How to Installed different JDBC driver???

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    1) java.sql.DriverManager.getDriver(url).getMajorVers ion()
    java.sql.DriverManager.getDriver(url).getMinorVers ion()

    2) Class.forName("com.ibm.db2.jcc.DB2Driver").newInst ance();

    Andy

  3. #3
    Join Date
    Sep 2006
    Posts
    97
    Sorry I didn't inform you much. How do I find this infor in db2 database server


    DB21085I Instance "DEV" uses "64" bits and DB2 code release "SQL09013"
    with level identifier "01040107".
    Informational tokens are "DB2 v9.1.0.3", "s070914", "U813650", and Fix Pack
    "3a".
    Product is installed at "/opt/IBM/db2/V9.1_03".

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    SELECT * FROM SYSIBMADM.ENV_INST_INFO

    Andy

  5. #5
    Join Date
    Sep 2006
    Posts
    97
    My bad . Thanks for replying ARWinner

    I can't even type message properly.

    My environment is

    DB21085I Instance "DEV" uses "64" bits and DB2 code release "SQL09013"
    with level identifier "01040107".
    Informational tokens are "DB2 v9.1.0.3", "s070914", "U813650", and Fix Pack
    "3a".
    Product is installed at "/opt/IBM/db2/V9.1_03".


    I need to find what type of JDBC drivers I had on my database serve from command line.

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    There is no command or program that I know of to get you this info. The only way is to load the driver and query it like I posted in my first post.

    Andy

  7. #7
    Join Date
    Sep 2006
    Posts
    97
    thanks for info bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •