|
midrange.com
--
[ 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> </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&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>
--
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
