RE: iSeries DB2 Driver in VAJ -- JAVA400-L

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


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