[ http://issues.apache.org/jira/browse/DERBY-583?page=all ]
Myrna van Lunteren updated DERBY-583:
-------------------------------------
Attachment: ijzrepro.jar
> networkserver does not return error message strings in native encoding to ij
> on zseries
> ---------------------------------------------------------------------------------------
>
> Key: DERBY-583
> URL: http://issues.apache.org/jira/browse/DERBY-583
> Project: Derby
> Type: Bug
> Versions: 10.1.1.0
> Environment: OS/390 (zseries) 1.06, ibm 1.4.2 jre
> Reporter: Myrna van Lunteren
> Fix For: 10.2.0.0
> Attachments: ijzrepro.jar
>
> When running ij on an OS/390 without specifying any encoding or locale
> properties, and starting network server without any locale properties,
> various error messages do not get converted into the native encoding.
> Thus the messages are unreadable and not helpful.
> The problem is not limited to ij, just easy to reproduce with ij.
> Some errors return readable message strings are returned with jcc, but not
> with derbyclient, for instance the test lang/forupdate.sql has this line in
> it:
> select i from t1, t2 for update;
> which on linux & windows results in an error message 42Y90, "FOR UPDATE is
> not permitted in this type of statement." On OS/390 this error message is
> readable with jcc, but with derbyclient, only the string 'ERROR' is readable.
> Other messages - especially those with indirection in it like error 42X04 are
> equally unreadable with both clients.
> To reproduce 1 situation:
> - start networkserver
> - in another shell window, use the following string to run the in.sql file &
> save the output for jcc-client and derbyclient respectively:
> ----------
> java -Dij.database='jdbc:derby:net://localhost:1527/wombat3;create=true'
> -Dij.retrieveMessagesFromServerOnGetMessage=true
> -Dij.protocol=jdbc:derby:net://localhost:1527/
> -Dij.driver=com.ibm.db2.jcc.DB2Driver -Dij.user=APP -Dij.password=APP
> org.apache.derby.tools.ij in.sql > jcc.out 2>&1
> ----------
> java -Dij.database='jdbc:derby://localhost:1527/wombat2;create=true'
> -Dij.protocol=jdbc:derby://localhost:1527/
> -Dij.driver=org.apache.derby.jdbc.ClientDriver -Dij.user=APP
> -Dij.password=APP org.apache.derby.tools.ij in.sql > client.out 2>&1
> ----------
> in.sql contains:
> ----------
> drop table a;
> create table a (a int);
> insert into a values (2342323423);
> disconnect;
> exit;
> ----------
> I'll attach a jar with the .out files and in.sql. This means that the out
> files are in EBCDIC, to read them, one needs to run them through native2ascii
> -encoding Cp1047.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
