Ask a Question related to IBM DB2, Design and Development.

  1. #1

    Default DB2 JDBC Driver

    What should I use for the DB2 JDBC driver form JDBC SPs? I'm using
    "DriverManager.getConnection("jdbc:default:connect ion");" at the moment. Is
    there a faster way to connect?


    Brien Schultz Guest

  2. Similar Questions and Discussions

    1. SQL 2005 JDBC 1.1 driver
      I tried installing and using the new SQL 2005 JDBC 1.1 driver and read and followed the technote at...
    2. New MS JDBC Driver Availability?
      In late January 2006, Microsoft released an updated JDBC driver specifically for their SQL 2005 product. I am interested in if / when Adobe will...
    3. Still bad driver for JDBC / ODBC
      Hello Since Oct 05 there is version 3.5 available in the package macromedia_drivers.jar and still we got the error 'no more data available to...
    4. JDBC Driver Issue
      It is always highly worrying when the solution to a problem involves the blunderbus. In this case: windows 2003 server sp1 / MX7 + updates (02,...
    5. com.mysql.jdbc.Driver
      I need to create a 'standalone' connection to a MySQL database. Using this code works: <cfset clazz = CreateObject('java', 'java.lang.Class') />...
  3. #2

    Default Re: DB2 JDBC Driver

    How would I know if it was? I've been told DB2 has a type 4 driver...I
    think I'm defaulting to a Type 2 driver but I'm unsure how to findout.

    "PM (pm3iinc-nospam)" <Pm3iinc.NoSpam@sympatico.ca> wrote in message
    news:02hMa.2652$eF3.372137@news20.bellglobal.com.. .
    > You can use the javax.sql.DataSource.* if it's supported in your
    > configuration.
    >
    > PM
    >
    > "Brien Schultz" <zulucrew@hawkaccess.com> a écrit dans le message de news:
    > bdr4gr$8ip$1@news.chatlink.com...
    > > What should I use for the DB2 JDBC driver form JDBC SPs? I'm using
    > > "DriverManager.getConnection("jdbc:default:connect ion");" at the moment.
    > Is
    > > there a faster way to connect?
    > >
    > >
    >
    >

    Brien Schultz Guest

  4. #3

    Default Re: DB2 JDBC Driver

    Should I use connection pooling in my procedures? Anyone have any examples?

    "Larry Menard" <lmenard@ca.ibm.com> wrote in message
    news:bdsoi2$ime$1@hanover.torolab.ibm.com...
    > Java Stored procedures still use the old ".app" (Type 2) driver.
    > --
    > Larry Menard
    > IBM Workstation Database (DB2) Performance Team
    > Defender of Geese and of All Things Natural
    >
    >
    > "Brien Schultz" <zulucrew@hawkaccess.com> wrote in message
    > news:bdsdem$r7i$1@news.chatlink.com...
    > > How would I know if it was? I've been told DB2 has a type 4 driver...I
    > > think I'm defaulting to a Type 2 driver but I'm unsure how to findout.
    > >
    > > "PM (pm3iinc-nospam)" <Pm3iinc.NoSpam@sympatico.ca> wrote in message
    > > news:02hMa.2652$eF3.372137@news20.bellglobal.com.. .
    > > > You can use the javax.sql.DataSource.* if it's supported in your
    > > > configuration.
    > > >
    > > > PM
    > > >
    > > > "Brien Schultz" <zulucrew@hawkaccess.com> a écrit dans le message de
    > news:
    > > > bdr4gr$8ip$1@news.chatlink.com...
    > > > > What should I use for the DB2 JDBC driver form JDBC SPs? I'm using
    > > > > "DriverManager.getConnection("jdbc:default:connect ion");" at the
    > moment.
    > > > Is
    > > > > there a faster way to connect?
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

    Brien Schultz Guest

  5. #4

    Default Re: DB2 JDBC Driver

    Are they adding support for the Type 4 driver?

    "Larry Menard" <lmenard@ca.ibm.com> wrote in message
    news:bdsoi2$ime$1@hanover.torolab.ibm.com...
    > Java Stored procedures still use the old ".app" (Type 2) driver.
    > --
    > Larry Menard
    > IBM Workstation Database (DB2) Performance Team
    > Defender of Geese and of All Things Natural
    >
    >
    > "Brien Schultz" <zulucrew@hawkaccess.com> wrote in message
    > news:bdsdem$r7i$1@news.chatlink.com...
    > > How would I know if it was? I've been told DB2 has a type 4 driver...I
    > > think I'm defaulting to a Type 2 driver but I'm unsure how to findout.
    > >
    > > "PM (pm3iinc-nospam)" <Pm3iinc.NoSpam@sympatico.ca> wrote in message
    > > news:02hMa.2652$eF3.372137@news20.bellglobal.com.. .
    > > > You can use the javax.sql.DataSource.* if it's supported in your
    > > > configuration.
    > > >
    > > > PM
    > > >
    > > > "Brien Schultz" <zulucrew@hawkaccess.com> a écrit dans le message de
    > news:
    > > > bdr4gr$8ip$1@news.chatlink.com...
    > > > > What should I use for the DB2 JDBC driver form JDBC SPs? I'm using
    > > > > "DriverManager.getConnection("jdbc:default:connect ion");" at the
    > moment.
    > > > Is
    > > > > there a faster way to connect?
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

    Brien Schultz Guest

  6. #5

    Default Re: DB2 JDBC Driver

    misread your post...

    PM


    PM \(pm3iinc-nospam\) Guest

  7. #6

    Default Re: DB2 JDBC Driver

    what platform did you think I was refering to?

    "Larry Menard" <lmenard@ca.ibm.com> wrote in message
    news:bdumo7$5v6$1@hanover.torolab.ibm.com...
    > I don't think they will ever use the Universal Type 4 driver, but I
    > believe they will switch to the Universal Type 2 driver soon.
    > --
    > Larry Menard
    > IBM Workstation Database (DB2) Performance Team
    > Defender of Geese and of All Things Natural
    >
    >
    > "Brien Schultz" <zulucrew@hawkaccess.com> wrote in message
    > news:bdt1vk$64g$1@news.chatlink.com...
    > > Are they adding support for the Type 4 driver?
    > >
    > > "Larry Menard" <lmenard@ca.ibm.com> wrote in message
    > > news:bdsoi2$ime$1@hanover.torolab.ibm.com...
    > > > Java Stored procedures still use the old ".app" (Type 2) driver.
    > > > --
    > > > Larry Menard
    > > > IBM Workstation Database (DB2) Performance Team
    > > > Defender of Geese and of All Things Natural
    > > >
    > > >
    > > > "Brien Schultz" <zulucrew@hawkaccess.com> wrote in message
    > > > news:bdsdem$r7i$1@news.chatlink.com...
    > > > > How would I know if it was? I've been told DB2 has a type 4
    > driver...I
    > > > > think I'm defaulting to a Type 2 driver but I'm unsure how to
    findout.
    > > > >
    > > > > "PM (pm3iinc-nospam)" <Pm3iinc.NoSpam@sympatico.ca> wrote in message
    > > > > news:02hMa.2652$eF3.372137@news20.bellglobal.com.. .
    > > > > > You can use the javax.sql.DataSource.* if it's supported in your
    > > > > > configuration.
    > > > > >
    > > > > > PM
    > > > > >
    > > > > > "Brien Schultz" <zulucrew@hawkaccess.com> a écrit dans le message
    de
    > > > news:
    > > > > > bdr4gr$8ip$1@news.chatlink.com...
    > > > > > > What should I use for the DB2 JDBC driver form JDBC SPs? I'm
    > using
    > > > > > > "DriverManager.getConnection("jdbc:default:connect ion");" at the
    > > > moment.
    > > > > > Is
    > > > > > > there a faster way to connect?
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

    Brien Schultz Guest

  8. #7

    Default Re: DB2 JDBC Driver

    Brien,

    I'm not referring to any single platform. I meant all platforms
    supported by DB2 for Linux/Unix/Windows.
    --
    Larry Menard
    IBM Workstation Database (DB2) Performance Team
    Defender of Geese and of All Things Natural


    "Brien Schultz" <zulucrew@hawkaccess.com> wrote in message
    news:be7hmj$kvo$1@news.chatlink.com...
    > what platform did you think I was refering to?
    >
    > "Larry Menard" <lmenard@ca.ibm.com> wrote in message
    > news:bdumo7$5v6$1@hanover.torolab.ibm.com...
    > > I don't think they will ever use the Universal Type 4 driver, but I
    > > believe they will switch to the Universal Type 2 driver soon.
    > > --
    > > Larry Menard
    > > IBM Workstation Database (DB2) Performance Team
    > > Defender of Geese and of All Things Natural
    > >
    > >
    > > "Brien Schultz" <zulucrew@hawkaccess.com> wrote in message
    > > news:bdt1vk$64g$1@news.chatlink.com...
    > > > Are they adding support for the Type 4 driver?
    > > >
    > > > "Larry Menard" <lmenard@ca.ibm.com> wrote in message
    > > > news:bdsoi2$ime$1@hanover.torolab.ibm.com...
    > > > > Java Stored procedures still use the old ".app" (Type 2) driver.
    > > > > --
    > > > > Larry Menard
    > > > > IBM Workstation Database (DB2) Performance Team
    > > > > Defender of Geese and of All Things Natural
    > > > >
    > > > >
    > > > > "Brien Schultz" <zulucrew@hawkaccess.com> wrote in message
    > > > > news:bdsdem$r7i$1@news.chatlink.com...
    > > > > > How would I know if it was? I've been told DB2 has a type 4
    > > driver...I
    > > > > > think I'm defaulting to a Type 2 driver but I'm unsure how to
    > findout.
    > > > > >
    > > > > > "PM (pm3iinc-nospam)" <Pm3iinc.NoSpam@sympatico.ca> wrote in
    message
    > > > > > news:02hMa.2652$eF3.372137@news20.bellglobal.com.. .
    > > > > > > You can use the javax.sql.DataSource.* if it's supported in your
    > > > > > > configuration.
    > > > > > >
    > > > > > > PM
    > > > > > >
    > > > > > > "Brien Schultz" <zulucrew@hawkaccess.com> a écrit dans le
    message
    > de
    > > > > news:
    > > > > > > bdr4gr$8ip$1@news.chatlink.com...
    > > > > > > > What should I use for the DB2 JDBC driver form JDBC SPs? I'm
    > > using
    > > > > > > > "DriverManager.getConnection("jdbc:default:connect ion");" at
    the
    > > > > moment.
    > > > > > > Is
    > > > > > > > there a faster way to connect?
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

    Larry Menard Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139