Unfortunately, this information has some errors, and lacks any help
for decision making. The basis of my last message was based on practical
experience, *after* I used the info below to get started. I've commented
below on the errors in this information.
On Thu, Aug 16, 2001 at 03:59:31PM +0200, Joachim Mueller wrote:
>
> Hello Bill,
>
> these answer I found in the DB2 Knowledge Base:
>
> Which DB2 JDBC driver should I use?
>
> Applicable version(s): Version 7, Version 6
> Applicable platform(s): AIX, HP-UX, Linux,
> OS/2, Solaris, SunOS, UNIX, Windows 2000,
> Windows 95, Windows 98, Windows NT
> Abstract: Which DB2 JDBC driver should I
> use--the application driver or the net driver?
>
> If you are concerned with speed and
> performance, you should always use the
> application (app) driver, which is provided in
> the COM.ibm.db2.jdbc.app.DB2Driver class.
>
> If you can install the Application Development
> Client for V7 or the Client Application Enabler
> (CAE) for V6 on the client's workstation, or if
> the database server is installed on the same
> machine as the client, you should always use
> the app driver, which is provided in the
> COM.ibm.db2.jdbc.net.DB2Driver class.
The referenced Java class is incorrect. It should be:
COM.ibm.db2.jdbc.app.DB2Driver class.
> The app driver, or thick client, is a type 2
> driver. This means that the Application
> Development Client or CAE has to be installed
> on the client's workstation.
> The net driver, or thin client, is a type 3
> driver that communicates with DB2 through the
> JDBC Applet Server. The net driver was designed
> to be used by applets only. To use it
> otherwise, you must ensure that the db2java.zip
> file on the client's workstation or web server
> and the DB2 server are from the same DB2
> version and fixpack. If the versions of
> db2java.zip do not match, you may be unable to
> connect to the database server or risk
> corruption of the data transmitted between
> client and server.
This is a little misleading. The "Applet Server" is in fact, the "db2jd"
process, a bit of information that is hard to associate. The comment "The
net driver was designed to be used by applets only", is simply not true.
This makes it sound like you need a webserver to use the net driver. The
fact is, *any* platform that supports Java can use the net driver in any
application (or applet) to connect to a remote db, with the limitations
described above.
> ... it's depend on the Hardware do you wnat to have, a thick or a thin
> machine.
The decision really has nothing to do with hardware. It's all about
functionality, ease of configuration, performance and the problem
you are trying to solve.
Best regards,
Doug Carter
WebCriteria
> BILL.GALLAGHER@phoenix
>
> wm.com An: [EMAIL PROTECTED]
>
> Gesendet von: Kopie:
>
> [EMAIL PROTECTED] Thema: DB2EUG: JDBC Drivers - App
>vs. Net
> a.best.com
>
>
>
>
>
> 16.08.2001 14:27
>
> Bitte antworten an
>
> db2eug
>
>
>
>
>
>
>
>
>
> Hi,
>
> Can anybody explain to me the difference between a JDBC App driver and a
> JDBC Net driver? I've looked in the UDB v7.2 manuals for information, and
> all I've been able to find is that the "app" driver is an "application"
> driver (type 2), and that the "net" driver is an "applet" driver (type 3).
>
> My problem is that I'm not in the least bit Java literate, so "application"
> vs. "applet" driver means nothing to me, and neither does type 2 vs. type
> 3.
>
> Can anybody explain to me in fairly simple terms what the difference is
> between the two, and more importantly, under what circumstances would you
> want to use one instead of the other?
>
> Thanks,
>
> Bill Gallagher, DBA
> Phoenix Life Insurance
>
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
>
>
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
