vi**********@gmail.com wrote:
Is this still true?
http://groups.google.com/group/comp....8f98749d8e2983
would a standard type 4 driver, jar file copy into the WEB-INF/lib
folder not work?
I am trying to access db2 8 on z/os though a java app server.
Excerpt from
http://tinyurl.com/s4gce [ibm.com]:
Q: "My understanding is that DB2 Version 8.1 ships a Java client
(Type 4 JDBC driver), which has DRDA function built into it and
therefore does not need a DB2 client or DB2 Connect. Does this mean that
I will no longer need DB2 Connect to access my host data source if I
use a Type 4 JDBC driver?"
A: "You must license access by any means for distributed clients to
zSeries- and iSeries-based versions of DB2. The JDBC drivers shipped
with DB2 Version 8.1 may be used for connecting to a properly licensed
DB2 databases on a Linux, UNIX, or Windows servers only without DB2
Connect. These JDBC drivers are not licensed for use with DB2 for z/OS
and DB2 for i5/OS database servers without DB2 Connect – again, you must
purchase an appropriate DB2 Connect product. You should be aware that a
Type 4 JDBC driver will give you access to DB2 host and mainframe data
through the JDBC or SQLJ API, but that's it. DB2 Connect is a middleware
product that is far more than a ‘bag’ of drivers. DB2 Connect offers
support for the following APIs: ODBC, JDBC, SQLJ, DB2 CLI, ADO, ADO.NET,
and embedded SQL. DB2 Connect also gives users transparent access
through heterogeneous joins across the DB2 family, Informix IDS; access
to mainframe resources like CICS, VSAM, and IMS are easily exposed
through stored procedures; a connection concentrator to maximize
mainframe usage; automatic client reroute for transparent failover,
complete application development support including the DB2 Development
Center and plug-ins for the world’s most popular IDEs, a mobile database
with a complete synchronization architecture, a heath monitoring
system, and more."