Hi Ashish,
The documentation is always the place to go, then complain if the result
does not work as specified. The link for Toolbox/JTOpen properties is:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzahh/page1.htm
The link for native driver properties is:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaha/db2drivr.htm
Incidentally, the link for DataSource properties, which the Toolbox page
notes that it omits, is:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaha/db2drivr.htm
The difference between the toolbox driver and the native driver is
similar to any Type 4 or "thin" driver and a type 2 or "native" driver: The
Type 4 driver typically uses IP connections, generally sockets, introducing
an additional layer and possible network latency. Native drivers can use
any OS specific optimizations since it will, by definition, only work with
that specific OS. For example, Native JDBC by default uses server mode.
In the past, I know I've seen docs that said JTOpen will use the native
driver if the app is running on the AS/400. However, in a recent project,
an IBM'er had never heard of that, and when I did a search of recent
documentation, I could not find that mention. If anyone can point it out,
it would be nice to clear that one up. One question, of course, would be
what happens if the Toolbox driver invokes the native driver with properties
that the native driver doesn't support.
Just to add some gossip, and I would greatly appreciate
clarification/confirmation on any of these, is that I've heard some mention
that the generic drivers included with other DB2 versions outperform AS/400
drivers. Of course, the generic driver is a Type 4, by necessity, so that
has to be taken into consideration.
I'm a little bit concerned that, on a professional list, there seems to
be small knowledge of the details of one of the most important aspects of
business programming. That's not to run down everyone here; rather that
there doesn't seem to be enough detailed information available from IBM, or
it is well hidden. My wish is that we would get more IBM responses here or
at some other known list, wiki, page, whatever.
Incidentally, AFAIK, bugs/errors in either the native or Toolbox drivers
(as opposed to JTOpen) should go through normal channels, like any other
AS/400 problem. HTH,
Joe Sam
Joe Sam Shirah -
http://www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum:
http://www.ibm.com/developerworks/java/
Just the JDBC FAQs:
http://www.jguru.com/faq/JDBC
Going International?
http://www.jguru.com/faq/I18N
Que Java400?
http://www.jguru.com/faq/Java400
----- Original Message -----
From: "Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Wednesday, March 05, 2008 12:12 AM
Subject: Re: need JDBC driver information
Ashish Kulkarni wrote:
Hi
Thank you for clarifying DB2Driver does not support
libraries property,
Some how i have never come across such documentation,
if you know where i can find it, i would really
appreciate if you can share it,
it would be a good information to get approval to
change code .
Actually, it's been a while since I tried the native driver, so I could
be wrong. You might want to double check the documentation.
Joe
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
midrange.com
