Re: Stored Procedures: JDBC native driver

[Sepp Mügeli <technews@xxxxxxxxxx>]

Hi again.

One important point I forgot: I do also use "normal" SQL-queries with JDBC
(select, insert, etc.), not only stored procedures. This queries work fine
both with the toolbox and the native driver. Only the stored procedures
called with the native driver give strange results. Any ideas?

Sepp

At 21:11 17.12.01 +0100, you wrote:
>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