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-972) tests derbynet/csPrepStmt and prepStmt use mechanisms that are not portable over encodings
Date Mon, 13 Feb 2006 21:44:53 GMT
tests derbynet/csPrepStmt and prepStmt use mechanisms that are not portable over encodings
------------------------------------------------------------------------------------------

         Key: DERBY-972
         URL: http://issues.apache.org/jira/browse/DERBY-972
     Project: Derby
        Type: Bug
  Components: Test  
    Versions: 10.1.2.0    
 Environment: z/OS , ibm142 ('Classic', 32 bit jvm)
    Reporter: Myrna van Lunteren
    Priority: Minor
     Fix For: 10.2.0.0


With zOS, with the classic 32 bit jvm, the tests derbynet/csPrepStmt and prepStmt.java fail
because the insert with setAsciiStream of a byte array obtained from a new String.getBytes()
(and/or the retrieval of that inserted value) is not ok. No error is returned, but the select
shows no value.

This is the section in the test csPrepStmt:
-----------------
                	ps.setString(10, "column11string");
			byte[] c11ba = new String("column11vcstring").getBytes();
			int len = c11ba.length;
			ps.setAsciiStream(11, new ByteArrayInputStream(c11ba), 
len);
and the value is retrieved using an ResultSet.getString(#)
--------------------------
28 del
< got row:   1 2 3 4 5.0 6.0 7.0 88.88 99.100 column11string 
      column11vcstring column12lvcstring 
0123456789abcdef10111213202020 0123456789abcdef10111213 
0123456789abcdef10111213 xxxxxxFILTERED-TIMESTAMPxxxxx-04-12 
11:44:30.0
28a28
> got row:   1 2 3 4 5.0 6.0 7.0 88.88 99.100 column11string    
    column12lvcstring 0123456789abcdef10111213202020 
0123456789abcdef10111213 0123456789abcdef10111213 
xxxxxxFILTERED-TIMESTAMPxxxxx-04-12 11:44:30.0
--------------------
(i.e. the string "column11vcstring" is not in the database)

This needs to be replaced by a encoding-neutral (eg. fixed encoding) mechanism and the tests
derbynet/prepStmt.java and csPrepStmt.java need to be checked for other non-portable 
code.



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