Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

JDBC drivers with DB2

0 views
Skip to first unread message

Bryon Lape

unread,
Sep 27, 2001, 3:33:37 PM9/27/01
to
DB2 7.1 for Linux ships with two different JDBC drivers, they are:

com.ibm.db2.jdbc.app.DB2Driver
com.ibm.db2.jdbc.net.DB2Driver

I know that .app works when the client (in this case WS 3.5) and DB2 are
on the same machine and the .net one work on same or on diff and
requires db2jd to be running, but what type are they? Which is
preferred over the other?

bernd hohmann

unread,
Sep 27, 2001, 4:54:00 PM9/27/01
to
On Thu, 27 Sep 2001 15:33:37 -0400, Bryon Lape wrote:

> com.ibm.db2.jdbc.app.DB2Driver
> com.ibm.db2.jdbc.net.DB2Driver
>
> I know that .app works when the client (in this case WS 3.5) and DB2 are
> on the same machine and the .net one work on same or on diff and
> requires db2jd to be running, but what type are they? Which is
> preferred over the other?

the .app driver needs some native code on the local machine, the .net
driver is pure java.

should be type 3 for .app and type 4 for .net

preferred ? depends. the .app is somewhat faster, the .net more
portable.

bernd


--
the DB2 faq: http://www.harddiskcafe.de/db2faq/index.html

Bryon Lape

unread,
Sep 27, 2001, 4:50:27 PM9/27/01
to
Huh? IBM claims they don't make a type 4 driver for DB2...

bernd hohmann

unread,
Sep 27, 2001, 5:53:13 PM9/27/01
to
On Thu, 27 Sep 2001 16:50:27 -0400, Bryon Lape wrote:

> Huh? IBM claims they don't make a type 4 driver for DB2...

ok, .net should be type 3 and .app should be type 2.

http://java.sun.com/products/jdbc/driverdesc.html

didn't ever thinked about the differences because we're using the
.net driver only

-r

0 new messages