[ 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