RE: iSeries DB2 Driver in VAJ

["Patrick Goovaerts" <pgoovaerts@xxxxxxxxxx>]

I understand this.  We too use only the Toolbox driver.  Problem is
that, after installing new PTF's (SQL / Toolbox), our application
doesn't work anymore!  An update-statement isn't functioning anymore.
Running in VAJAVA TestEnvironment is functioning normal.

Because we're only using this class in WAS355, we thought to give the
native DB2 driver a try.

Patrick Goovaerts
pgoovaerts@pandora.be
TEL: 0032-3-6472715
GSM:0498610325

Ps. Extract of our std_out.log with our own tests/messages displaying
the error using Toolbox-driver

Updating record with : 20 1 12 7 66
    autocommit=false, TransActionIsolationLevel=1
Record not available for update: 20 1 12 7 66
   SQLCODE             =-601
   SQL message         =[PWS0043] Unable to use the parameter marker
values
provided. Cause . . . . . :   Either the parameter marker values or the
parameter marker description was not provided or was not valid. Recovery
.
. . :   Verify that the following are correct and run the function
again.
-- Parameter marker data and an existing descriptor handle are provided.
-- The descriptor provided matches the parameter marker data.
   SQL LocalMsg        =[PWS0043] Unable to use the parameter marker
values
provided. Cause . . . . . :   Either the parameter marker values or the
parameter marker description was not provided or was not valid. Recovery
.
. . :   Verify that the following are correct and run the function
again.
-- Parameter marker data and an existing descriptor handle are provided.
-- The descriptor provided matches the parameter marker data.
   SQL State           =HY001
   autoCommit          =false
   transactionIsolation=1
Record in use ?


-----Oorspronkelijk bericht-----
Van: java400-l-admin@midrange.com [mailto:java400-l-admin@midrange.com]
Namens Paul Holm
Verzonden: vrijdag 19 april 2002 19:49
Aan: java400-l@midrange.com
Onderwerp: iSeries DB2 Driver in VAJ



Patrick,

The iSeries Db2 driver you loaded in VAJ will only run on the iSeries.
It makes direct CLI db2 calls into OS400. This "native" driver can give
you better performance but will only run directly on the iSeries  (it is
not network enabled).

We typically develop in VAJ with the toolbox jdbc driver (type 4) and
then change our property files use use the native when running on the
400.

-Paul Holm


_______________________________________________
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.