db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-583) networkserver does not return error message strings in native encoding to ij on zseries
Date Wed, 21 Sep 2005 19:43:34 GMT
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


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


Mime
View raw message