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 "Bryan Pendleton (JIRA)" <de...@db.apache.org> on 2006/04/28 16:17:40 UTC
[jira] Reopened: (DERBY-125) Network Server can send DSS greater
than 32K to client, which breaks DRDA protocol.
[ http://issues.apache.org/jira/browse/DERBY-125?page=all ]
Bryan Pendleton reopened DERBY-125:
-----------------------------------
Reopened to merge this fix to the 10.1 branch.
> Network Server can send DSS greater than 32K to client, which breaks DRDA protocol.
> -----------------------------------------------------------------------------------
>
> Key: DERBY-125
> URL: http://issues.apache.org/jira/browse/DERBY-125
> Project: Derby
> Type: Bug
> Components: Network Server
> Reporter: A B
> Assignee: Bryan Pendleton
> Fix For: 10.2.0.0
> Attachments: changes.html, offByOne.jar, repro.java, svn_jan_12_2006.status, svn_jan_22_2006.diff
>
> BACKGROUND:
> DRDA protocol, which is the protocol used by Derby Network Server, dictates that all DSS objects "with data greater than 32,763 bytes" should be broken down into multiple "continuation" DSSes.
> PROBLEM:
> When Network Server receives a "prepareStatement" call that has a very large number of parameters, it can end up sending a reply DSS that is greater than 32K long to the client; doing so breaks DRDA protocol.
> REPRODUCTION:
> Note that this reproduction does NOT cause a protocol exception against the JCC driver--without further investigation, it would appear JCC doesn't mind that the DSS is too long. However, other DRDA clients (such as the DB2 ODBC client) will see that the data is too long and will fail because of it.
> To reproduce, one can create a simple table and then prepare a statement such as:
> SELECT id FROM t1 WHERE id in ( ?, ?, [ ... lots and lots of param markers ... ], ?)
> Note that JCC uses deferred prepare by default; when connecting, one must append the "deferPrepares=false" attribute to the end of the URL in order to reproduce the problem (that or just try to execute the statement, since preparation will be done at execution time). When doing the prepare, I added a line in the "flush" method of org.apache.derby.impl.drda.DDMWriter.java to see how large the reply DSS was, and for cases where the number of parameter markers was high, the number of bytes in the single DSS would surpass 32K, and thus break protocol.
> NOTES:
> Network Server correctly uses continuation DSSes for LOBs and for result set data (data returned as the result of a query) that is greater than 32K. The problem appears to be in "other" cases, such as for the prepareStatement call described above.
--
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
Re: [jira] Reopened: (DERBY-125) Network Server can send DSS greater
than 32K to client, which breaks DRDA protocol.
Posted by "David W. Van Couvering" <Da...@Sun.COM>.
Nah, the bug just went away, that's all :)
David
Bryan Pendleton wrote:
> Bryan Pendleton (JIRA) wrote:
>> [ http://issues.apache.org/jira/browse/DERBY-125?page=all ]
>> Bryan Pendleton reopened DERBY-125:
>> -----------------------------------
>>
>> Reopened to merge this fix to the 10.1 branch.
>
> This one may take me a few days. The subversion merge is straightforward
> and clean, and all the tests pass.
>
> Unfortunately, the regression test now passes even *without* the fix.
>
> This was a *very* delicate regression test to write (Army and I co-wrote
> it over a period of several weeks), so I want to take a bit of time to
> study this, and see if there's something deeper going on here, or whether
> I just have to fiddle the regression test a bit.
>
> thanks,
>
> bryan
>
Re: [jira] Reopened: (DERBY-125) Network Server can send DSS greater
than 32K to client, which breaks DRDA protocol.
Posted by Bryan Pendleton <bp...@amberpoint.com>.
Bryan Pendleton (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-125?page=all ]
>
> Bryan Pendleton reopened DERBY-125:
> -----------------------------------
>
> Reopened to merge this fix to the 10.1 branch.
This one may take me a few days. The subversion merge is straightforward
and clean, and all the tests pass.
Unfortunately, the regression test now passes even *without* the fix.
This was a *very* delicate regression test to write (Army and I co-wrote
it over a period of several weeks), so I want to take a bit of time to
study this, and see if there's something deeper going on here, or whether
I just have to fiddle the regression test a bit.
thanks,
bryan