RE: iSeries DB2 Driver in VAJ

--
[ Picked text/plain from multipart/alternative ]
Yes,
outside the AS/400 you must use the jt400.jar.

For your UPDATE problem look at the joblog on the AS/400 on you job (something 
like "..QZASOINIT..)

Ciao.

--Original Message Text---
From: Patrick Goovaerts
Date: Fri, 19 Apr 2002 20:50:46 +0200

Files are under journal.

It is the statement 'Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
which already gives errors.
I want to use this driver to access AS400 from within VAJAVA (or the
web).

Do I understand it right that I should be able to use it from the web
but not from within VAJAVA?

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



-----Oorspronkelijk bericht-----
Van: java400-l-admin@midrange.com [mailto:java400-l-admin@midrange.com]
Namens Franco Biaggi
Verzonden: vrijdag 19 april 2002 20:34
Aan: java400-l@midrange.com; Patrick Goovaerts
Onderwerp: RE: iSeries DB2 Driver in VAJ


I think you cannot use the native DB2 driver ouside the AS/400.

Are your files under journal ?

Ciao.

On Fri, 19 Apr 2002 19:58:33 +0200, Patrick Goovaerts wrote:

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





Franco Biaggi
SISA Studio Informatica SA
R&D Services
Via Carvina 1
CH-6807 Taverne
Efax +1 801 705 2839






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


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



<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Franco Biaggi">
<meta name="GENERATOR" content="Franco Biaggi">
</head>

<body>

<p>&nbsp; </p>

<table BORDER="1" COLS="1" WIDTH="452" BGCOLOR="#FFFF00">
  <tr>
    <td width="446"><font face="Comic Sans MS"><small><small><br>
    <font color="#3333FF"><a href="http://www.ticino.com/usr/fbiaggi/";>Franco 
Biaggi</a></font><small><br>
    <font color="#3333FF"><a href="http://www.sisa.ch";>SISA Studio Informatica 
SA</a></font><small><small><small> <br>
    </small></small></small><font color="#3333FF">R&amp;D 
Services</font><small><small><small>
    <br>
    </small></small></small><font color="#3333FF">Via Carvina 
1</font><small><small><small> <br>
    </small></small></small><font color="#3333FF">CH-6807 
Taverne</font><small><small><small> <br>
    </small></small></small><font color="#3333FF">Efax +1 801 705 
2839</font></small></small></small><br>
<br>
</font></td>
  </tr>
</table>
</body>
</html>


--