Stored Procedures: JDBC native driver

[Sepp Mügeli <technews@xxxxxxxxxx>]

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