× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi.
I'm using JDBC to call some stored procedures on the AS/400. I use
VisualAge to develop the java application. Because there is no platform
specific code in the application, I can run it from VisualAge on my PC. In
this case, the toolbox JDBC driver is used to call the stored procedures on
the AS/400.
 From time to time I export my code to the IFS to run and test the
application on the AS/400. In this case, the application uses the native
JDBC driver.
The problem is, that the out-parameters of the stored procedures are
different when called with the toolbox or with the native driver (with the
toolbox driver, the result is how it should be).
Example: the stored procedure has two out-parameters, a two character
return code and a 26 character timestamp.
I made a System.out.println of the two values after calling the stored
procedure. Here is what I get after the call of the stored procedure with
the toolbox driver (the value in brackets is the character-array of the
String):

RC='00' (00)
TS='2001-12-14-13.39.15.632000' (2001-12-14-13.39.15.632000)

And here is what I get when I call the stored procedure via the native
driver:

RC=' ' (¢C@7a91baf)
TS=' ' (¢C@590b7cad)

So this is not how it should be.

I don't know the AS/400 system very good, so any hints for a solution would
be a great help.

Sepp Mügeli
DV Bern AG
______________________________________________________________________
mailto:sepp.muegeli@dvbern.ch / http://www.dvbern.ch
Briefpost: Sulgenauweg 40 , CH-3007 Bern
Telefon: ++41+31 378 24 54
Telefax: ++41+31 378 24 74



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.