Re: need JDBC driver information -- JAVA400-L

Hi
The documentation did answer my question,
the DB2Driver library property adds library to the
current user library list
"In the case where naming is set system, each of the
libraries specified for this property is added to the
user portion of the library list and the library list
is searched to resolve unqualified table references."

So it is not a bug, but just the way native driver
works,

Although the library list is not the current jobs
library, but the user's library list defined in job
description,

This is what is bothering me, and there is no
clarification about which library list it will take,
weather current job, or job description

Ashish
--- Joe Sam Shirah <joe_sam@xxxxxxxxxxxxx> wrote:

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.

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

____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping