db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fernanda Pizzorno (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1313) SUR: Use DRDA's extended diagnostic to send ROW_UPDATED and ROW_DELETED warnings.
Date Wed, 17 May 2006 23:05:06 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1313?page=all ]

Fernanda Pizzorno updated DERBY-1313:
-------------------------------------

    Attachment: derby-1313.diff
                derby-1313.stat

In the server side, SQLDIAGGRP had been implemented on the DRDAConnThread, but it was commented
out. This implementation has been uncommented in this patch and SQLDIAGGRP are now sent if
the client requests diagnostic level != SQLDIAG0. The implementation of SQLDIAGGRP has also
been changed so that only ROW_UPDATE AND ROW_DELETED warnings will be sent to the client.

The client has been changed so as to request diagnostic level SQLDIAG2 (which means that SQLDIAGGRP
will be sent by the server, but the error message will not be sent), and to be able to parse
SQLDIAGGRP.

A test has been added to SURTest that verifies that a row can return true for both rowUpdated()
and rowDeleted().

Can someone please review this patch?

Thank you in advance :-).

> SUR: Use DRDA's extended diagnostic to send ROW_UPDATED and ROW_DELETED warnings.
> ---------------------------------------------------------------------------------
>
>          Key: DERBY-1313
>          URL: http://issues.apache.org/jira/browse/DERBY-1313
>      Project: Derby
>         Type: Bug

>   Components: JDBC
>     Reporter: Fernanda Pizzorno
>     Assignee: Fernanda Pizzorno
>  Attachments: derby-1313.diff, derby-1313.stat
>
> Detectability of own changes is implemented in the client using warnings cf the write-up
for DERBY-775. When a row has been deleted and/or updated, a warning will be sent to the client
to indicate that fact. Presently, only one warning can be sent each time a data row is sent
from to the client, that means that some warnings may be lost. Using extended diagnostic allows
us to send several warnings for each data row.
> I propose to use extended diagnostics to send ROW_UPDATED and ROW_DELETED warnings when
necessary. This may later be extended for other warnings, but I do not plan to do it as a
part of the work in this issue.

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