You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Sunitha Kambhampati (JIRA)" <de...@db.apache.org> on 2006/04/25 00:02:06 UTC

[jira] Commented: (DERBY-972) tests derbynet/csPrepStmt and prepStmt use mechanisms that are not portable over encodings

    [ http://issues.apache.org/jira/browse/DERBY-972?page=comments#action_12376119 ] 

Sunitha Kambhampati commented on DERBY-972:
-------------------------------------------

I'd like to port these test changes to the 10.1 codeline.  The merge command is 

 svn merge -r 396033:396034 https://svn.apache.org/repos/asf/db/derby/code/trunk

Ran these two tests OK on 10.1. Can someone please port this. Thanks. 


> 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
>  Attachments: Derby972.diff.txt, Derby972.stat.txt
>
> 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