[
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12422405 ]
Tomohito Nakayama commented on DERBY-1535:
------------------------------------------
The result of the test told that the errors happen when uploaded binary data
was stored into the character type column such as CHAR(60), VARCHAR(60) , LONG
VARCHAR .
These errors were considered as correct behavior in the test of Engine(and DB2
driver) as shown in the next output of diff between master .out files.
[EMAIL
PROTECTED]:~/derby/dev/trunk/java/testing/org/apache/derbyTesting/functionTests/master$
diff parameterMapping.out DerbyNetClient/parameterMapping.out
<snip>
1823,1826c1354,1357
< setBinaryStream() IC JDBC MATCH (INVALID)
< setBinaryStream() as batch IC JDBC MATCH (INVALID)
< setBinaryStream(null) IC JDBC MATCH (INVALID)
< setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
---
> setBinaryStream() getString=EncodedString: > 33347 51966 50 32 32 32 32 32
> 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
> 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
> < was null false CLOUD EXT (OK)
> setBinaryStream() as batch getString=EncodedString: > 33347 51966 50 32 32
> 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
> 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
> 32 32 32 < was null false CLOUD EXT (OK)
> setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
> setBinaryStream(null) as batch getString=null was null true CLOUD EXT (OK)
1831,1838c1362,1369
< setClob() IC JDBC MATCH (INVALID)
< setClob() as batch IC JDBC MATCH (INVALID)
< setClob(null) IC JDBC MATCH (INVALID)
< setClob(null) as batch IC JDBC MATCH (INVALID)
< setBlob() IC JDBC MATCH (INVALID)
< setBlob() as batch IC JDBC MATCH (INVALID)
< setBlob(null) IC JDBC MATCH (INVALID)
< setBlob(null) as batch IC JDBC MATCH (INVALID)
---
> setClob() getString=72
> was null false CLOUD EXT (OK)
> setClob() as batch getString=72
> was null false CLOUD EXT (OK)
> setClob(null) getString=null was null true CLOUD EXT (OK)
> setClob(null) as batch getString=null was null true CLOUD EXT (OK)
> setBlob() getString=EncodedString: > 12867 29251 55 32 32 32 32 32 32 32 32
> 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
> 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was
> null false CLOUD EXT (OK)
> setBlob() as batch getString=EncodedString: > 12867 29251 55 32 32 32 32 32
> 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
> 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
> < was null false CLOUD EXT (OK)
> setBlob(null) getString=null was null true CLOUD EXT (OK)
> setBlob(null) as batch getString=null was null true CLOUD EXT (OK)
<snip>
2057,2060c1526,1529
< setBinaryStream() IC JDBC MATCH (INVALID)
< setBinaryStream() as batch IC JDBC MATCH (INVALID)
< setBinaryStream(null) IC JDBC MATCH (INVALID)
< setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
---
> setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null
> false CLOUD EXT (OK)
> setBinaryStream() as batch getString=EncodedString: > 33347 51966 50 < was
> null false CLOUD EXT (OK)
> setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
> setBinaryStream(null) as batch getString=null was null true CLOUD EXT (OK)
2065,2072c1534,1541
< setClob() IC JDBC MATCH (INVALID)
< setClob() as batch IC JDBC MATCH (INVALID)
< setClob(null) IC JDBC MATCH (INVALID)
< setClob(null) as batch IC JDBC MATCH (INVALID)
< setBlob() IC JDBC MATCH (INVALID)
< setBlob() as batch IC JDBC MATCH (INVALID)
< setBlob(null) IC JDBC MATCH (INVALID)
< setBlob(null) as batch IC JDBC MATCH (INVALID)
---
> setClob() getString=72 was null false CLOUD EXT (OK)
> setClob() as batch getString=72 was null false CLOUD EXT (OK)
> setClob(null) getString=null was null true CLOUD EXT (OK)
> setClob(null) as batch getString=null was null true CLOUD EXT (OK)
> setBlob() getString=EncodedString: > 12867 29251 55 < was null false CLOUD
> EXT (OK)
> setBlob() as batch getString=EncodedString: > 12867 29251 55 < was null
> false CLOUD EXT (OK)
> setBlob(null) getString=null was null true CLOUD EXT (OK)
> setBlob(null) as batch getString=null was null true CLOUD EXT (OK)
<snip>
2291,2294c1698,1701
< setBinaryStream() IC JDBC MATCH (INVALID)
< setBinaryStream() as batch IC JDBC MATCH (INVALID)
< setBinaryStream(null) IC JDBC MATCH (INVALID)
< setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
---
> setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null
> false CLOUD EXT (OK)
> setBinaryStream() as batch getString=EncodedString: > 33347 51966 50 < was
> null false CLOUD EXT (OK)
> setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
> setBinaryStream(null) as batch getString=null was null true CLOUD EXT (OK)
2299,2306c1706,1713
< setClob() IC JDBC MATCH (INVALID)
< setClob() as batch IC JDBC MATCH (INVALID)
< setClob(null) IC JDBC MATCH (INVALID)
< setClob(null) as batch IC JDBC MATCH (INVALID)
< setBlob() IC JDBC MATCH (INVALID)
< setBlob() as batch IC JDBC MATCH (INVALID)
< setBlob(null) IC JDBC MATCH (INVALID)
< setBlob(null) as batch IC JDBC MATCH (INVALID)
---
> setClob() getString=72 was null false CLOUD EXT (OK)
> setClob() as batch getString=72 was null false CLOUD EXT (OK)
> setClob(null) getString=null was null true CLOUD EXT (OK)
> setClob(null) as batch getString=null was null true CLOUD EXT (OK)
> setBlob() getString=EncodedString: > 12867 29251 55 < was null false CLOUD
> EXT (OK)
> setBlob() as batch getString=EncodedString: > 12867 29251 55 < was null
> false CLOUD EXT (OK)
> setBlob(null) getString=null was null true CLOUD EXT (OK)
> setBlob(null) as batch getString=null was null true CLOUD EXT (OK)
I will make the behavior of the NetworkClient to that of the Engine in
concerning part around this patch ....
> Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce
> memory usage
> ---------------------------------------------------------------------------------------
>
> Key: DERBY-1535
> URL: http://issues.apache.org/jira/browse/DERBY-1535
> Project: Derby
> Issue Type: Sub-task
> Components: Network Server
> Reporter: Tomohito Nakayama
> Assigned To: Tomohito Nakayama
> Attachments: DERBY-1513_1535.patch, DERBY-1535.patch,
> serverMemoryUsage.xls, serverMemoryUsage_1513_1535.xls
>
>
> Through DERBY-1513, Trial 1 for DERBY-550,
> it was suggested that NetworkServer seems to use Engine inefficiently and use
> too much of memory.
> This task try to improve the use of Engine from NetworkServer and try to
> reduce memory usage.
--
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
