Stored Procedures AS400: array of cubes instead of text

[Tokajac <im...@hotmail.com>]

Hello!


I'm developing an application with Java/iBatis/AS400. 

When i call a stored procedure with appropriate IN parameters, for every OUT
parameter value i get an array of small cubes instead of data(String).
Data is taken from user table and it should be username, password, e-mail,
status..., but there are only senseless cubes.
OUTput parameter values (cubes) are logged right after the procedure call.

Have U ever had similar problem with 'mysterious cubes' when working on
AS400?
I appreciate any hint!


Regards
-- 
View this message in context: http://www.nabble.com/Stored-Procedures-AS400%3A-array-of-cubes-instead-of-text-tp20217590p20217590.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: Stored Procedures AS400: array of cubes instead of text

[Jeff Butler <je...@gmail.com>]

This is likely because the AS400 file has CCSID set to 65535 (the default).

The solution is to set the "translate binary" connection property to
"true" on your JDBC URL:

jdbc:as400://servername/as400lib;translate binary=true;


Jeff Butler


On Tue, Oct 28, 2008 at 5:44 PM, Tokajac <im...@hotmail.com> wrote:
>
> Hello!
>
>
> I'm developing an application with Java/iBatis/AS400.
>
> When i call a stored procedure with appropriate IN parameters, for every OUT
> parameter value i get an array of small cubes instead of data(String).
> Data is taken from user table and it should be username, password, e-mail,
> status..., but there are only senseless cubes.
> OUTput parameter values (cubes) are logged right after the procedure call.
>
> Have U ever had similar problem with 'mysterious cubes' when working on
> AS400?
> I appreciate any hint!
>
>
> Regards
> --
> View this message in context: http://www.nabble.com/Stored-Procedures-AS400%3A-array-of-cubes-instead-of-text-tp20217590p20217590.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>