Re: need JDBC driver information

Hi

So if i have jt400native.jar in class path and JDBC
url as below
driver = "com.ibm.db2.jdbc.app.DB2Driver";
url = "jdbc:db2:*local/;naming=system;date
format=iso;time format=hms;prompt=false;transaction
isolation=read
committed;trace=true;errors=full;libraries=QTEMP MYLIB
QGPL"
I do not have driver="native" in URL
so will it use native driver, or the toolbox driver,
i guess the toolbox driver,
then why it wont set the library list to what i want,
rather then trying to add library to existing library
list

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

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.

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

A$HI$H


____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs