Re: need JDBC driver information

Hi Ashish,

i guess the toolbox driver,

There should be no guessing here. Take a look at the driver you've
requested and compare it with the URL's below. The paragraphs are taken
from the Toolbox for Java & JTOpen JDBC FAQ :

The "Native" JDBC driver. This is shipped as part of the IBM Developer Kit
for Java (57xxJV1). It is implemented by making native method calls to the
SQL CLI (Call Level Interface). Consequently, it only runs on the i5/OS JVM.
The class name to register is com.ibm.db2.jdbc.app.DB2Driver . The URL
subprotocol is db2 .

The "Toolbox" JDBC driver. This is shipped as part of the IBM Toolbox for
Java (57xxJC1). It is implemented by making direct socket connections to the
database host server. This happens to be the same route that the IBM System
iT Access for Windows ODBC driver takes. However, IBM System iT Access for
Windows is NOT required. The Toolbox runs on any JVM. The class name to
register is com.ibm.as400.access.AS400JDBCDriver . The URL subprotocol is
as400 .


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: "Ashish Kulkarni" <kulkarni_ash1312@xxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Wednesday, March 05, 2008 2:54 PM
Subject: 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
>