Re: need JDBC driver information

Good one, Gary, thanks! Everyone should also note that the default driver property is "toolbox". So even with everything else set up, it won't act as native unless the property is set to "native".


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: "Gary L Peskin" <garyp@xxxxxxxxxxxx>
To: "'Java Programming on and around the iSeries / AS400'" <java400-l@xxxxxxxxxxxx>
Sent: Wednesday, March 05, 2008 12:12 PM
Subject: RE: need JDBC driver information

Joe Sam --

JTOpen does not invoke the native driver when running on platform. Rather,
the JTOpen driver itself is a type 4 or a type 2 driver depending on whether
you're using jt400.jar or the jt400Native.jar. The documentation is at
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahh/rzahnm0503
.htm#rzahnm0503

As it states, see Note 1 in the "Jar files" link.

The page does state that you get better performance from the native driver
than from the JTOpen/Toolbox driver using native optimizations but I've
never checked this out myself.

HTH,
Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Joe Sam Shirah
Sent: Wednesday, March 05, 2008 5:20 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: need JDBC driver information

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

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