db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1313) SUR: Use DRDA's extended diagnostic to send ROW_UPDATED and ROW_DELETED warnings.
Date Thu, 08 Jun 2006 15:07:31 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1313?page=comments#action_12415363 ] 

Kathey Marsden commented on DERBY-1313:
---------------------------------------

Thanks Dag for the check and the clarification. 

Fernanda said:
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. 

I would be of tremendous help to the community if there were a write up of what was done and
how it might be exapanded to cover other warnings and multiple exceptions. There are oustanding
issues (DERBY-159,  DERBY-1011) related to this.  There is a lot I don't understand about
the change  like how it fits into our current message localization scheme which uses a stored
procedure to retrieve the message.  Does the stored procedure get called multiple times for
each row returning a warning? If so what impact might this have on transaction semantics and
performance? etc...

Unfortunately I am not educated enough on change to ask intelligent questions. I hope others
will pursue a more detailed review. As said a write up of the changes, their impact, and how
they might be adapted to other cases would sure be helpful.

Kathey





> 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, derby-1313v2.diff, derby-1313v2.stat,
derby-1313v3.diff, derby-1313v3.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