Re: Stored Procedures: JDBC native driver

[rstearns@xxxxxxxxxxxxx]

It's possible the CCSID of user QEJB and or QUSER is at the invalid
default, change them to 37 or some other valid CCSID and your output will
be translated correctly.
Thanks,
Royce Stearns
Manage, Inc.
(503) 353-1721 x103
www.manageinc.com



                    Sepp Mügeli
                    <technews@bluewin.        To:     java400-l@midrange.com
                    ch>                       cc:
                    Sent by:                  Subject:     Stored Procedures: 
JDBC native driver
                    java400-l-admin@mi
                    drange.com


                    12/17/01 12:11 PM
                    Please respond to
                    java400-l






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

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