Professional Web Applications Themes

DB2 JDBC Driver - IBM DB2

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?...

  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. #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.NoSpamsympatico.ca> wrote in message
    news:02hMa.2652$eF3.372137news20.bellglobal.com.. .
    > You can use the javax.sql.DataSource.* if it's supported in your
    > configuration.
    >
    > PM
    >
    > "Brien Schultz" <zulucrewhawkaccess.com> a écrit dans le message de news:
    > bdr4gr$8ip$1news.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

  3. #3

    Default Re: DB2 JDBC Driver

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

    "Larry Menard" <lmenardca.ibm.com> wrote in message
    news:bdsoi2$ime$1hanover.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" <zulucrewhawkaccess.com> wrote in message
    > news:bdsdem$r7i$1news.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.NoSpamsympatico.ca> wrote in message
    > > news:02hMa.2652$eF3.372137news20.bellglobal.com.. .
    > > > You can use the javax.sql.DataSource.* if it's supported in your
    > > > configuration.
    > > >
    > > > PM
    > > >
    > > > "Brien Schultz" <zulucrewhawkaccess.com> a écrit dans le message de
    > news:
    > > > bdr4gr$8ip$1news.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. #4

    Default Re: DB2 JDBC Driver

    Are they adding support for the Type 4 driver?

    "Larry Menard" <lmenardca.ibm.com> wrote in message
    news:bdsoi2$ime$1hanover.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" <zulucrewhawkaccess.com> wrote in message
    > news:bdsdem$r7i$1news.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.NoSpamsympatico.ca> wrote in message
    > > news:02hMa.2652$eF3.372137news20.bellglobal.com.. .
    > > > You can use the javax.sql.DataSource.* if it's supported in your
    > > > configuration.
    > > >
    > > > PM
    > > >
    > > > "Brien Schultz" <zulucrewhawkaccess.com> a écrit dans le message de
    > news:
    > > > bdr4gr$8ip$1news.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. #5

    Default Re: DB2 JDBC Driver

    misread your post...

    PM


    PM \(pm3iinc-nospam\) Guest

  6. #6

    Default Re: DB2 JDBC Driver

    what platform did you think I was refering to?

    "Larry Menard" <lmenardca.ibm.com> wrote in message
    news:bdumo7$5v6$1hanover.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" <zulucrewhawkaccess.com> wrote in message
    > news:bdt1vk$64g$1news.chatlink.com...
    > > Are they adding support for the Type 4 driver?
    > >
    > > "Larry Menard" <lmenardca.ibm.com> wrote in message
    > > news:bdsoi2$ime$1hanover.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" <zulucrewhawkaccess.com> wrote in message
    > > > news:bdsdem$r7i$1news.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.NoSpamsympatico.ca> wrote in message
    > > > > news:02hMa.2652$eF3.372137news20.bellglobal.com.. .
    > > > > > You can use the javax.sql.DataSource.* if it's supported in your
    > > > > > configuration.
    > > > > >
    > > > > > PM
    > > > > >
    > > > > > "Brien Schultz" <zulucrewhawkaccess.com> a écrit dans le message
    de
    > > > news:
    > > > > > bdr4gr$8ip$1news.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

  7. #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" <zulucrewhawkaccess.com> wrote in message
    news:be7hmj$kvo$1news.chatlink.com...
    > what platform did you think I was refering to?
    >
    > "Larry Menard" <lmenardca.ibm.com> wrote in message
    > news:bdumo7$5v6$1hanover.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" <zulucrewhawkaccess.com> wrote in message
    > > news:bdt1vk$64g$1news.chatlink.com...
    > > > Are they adding support for the Type 4 driver?
    > > >
    > > > "Larry Menard" <lmenardca.ibm.com> wrote in message
    > > > news:bdsoi2$ime$1hanover.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" <zulucrewhawkaccess.com> wrote in message
    > > > > news:bdsdem$r7i$1news.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.NoSpamsympatico.ca> wrote in
    message
    > > > > > news:02hMa.2652$eF3.372137news20.bellglobal.com.. .
    > > > > > > You can use the javax.sql.DataSource.* if it's supported in your
    > > > > > > configuration.
    > > > > > >
    > > > > > > PM
    > > > > > >
    > > > > > > "Brien Schultz" <zulucrewhawkaccess.com> a écrit dans le
    message
    > de
    > > > > news:
    > > > > > > bdr4gr$8ip$1news.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

Similar Threads

  1. SQL 2005 JDBC 1.1 driver
    By BrianO in forum Coldfusion Server Administration
    Replies: 0
    Last Post: December 13th, 02:09 PM
  2. New MS JDBC Driver Availability?
    By SQLCraftsman in forum Coldfusion Database Access
    Replies: 4
    Last Post: June 8th, 05:41 PM
  3. Still bad driver for JDBC / ODBC
    By JanM in forum Coldfusion Database Access
    Replies: 7
    Last Post: February 18th, 03:04 AM
  4. JDBC Driver Issue
    By UKJools in forum Coldfusion Database Access
    Replies: 0
    Last Post: September 23rd, 01:16 PM
  5. com.mysql.jdbc.Driver
    By Pekka in forum Coldfusion Database Access
    Replies: 1
    Last Post: February 21st, 08:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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