db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tomohito Nakayama (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage
Date Thu, 20 Jul 2006 12:17:14 GMT
    [ 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.

naka@rufelza:~/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

        

Mime
View raw message