[jira] Updated: (DERBY-1313) SUR: Use DRDA's extended diagnostic to send ROW_UPDATED and ROW_DELETED warnings.

2006-07-07 Thread Kathey Marsden (JIRA)
 [ http://issues.apache.org/jira/browse/DERBY-1313?page=all ]

Kathey Marsden updated DERBY-1313:
--

   type: Improvement  (was: Bug)
Fix Version: 10.2.0.0
Version: 10.2.0.0

Change to improvement and set affects and fix version

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

>   Components: JDBC
> Versions: 10.2.0.0
> Reporter: Fernanda Pizzorno
> Assignee: Fernanda Pizzorno
>  Fix For: 10.2.0.0
>  Attachments: derby-1313.diff, derby-1313.stat, derby-1313v1.pdf, 
> 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



[jira] Updated: (DERBY-1313) SUR: Use DRDA's extended diagnostic to send ROW_UPDATED and ROW_DELETED warnings.

2006-06-22 Thread Fernanda Pizzorno (JIRA)
 [ http://issues.apache.org/jira/browse/DERBY-1313?page=all ]

Fernanda Pizzorno updated DERBY-1313:
-

Attachment: derby-1313v1.pdf

The attached document (derby-1313v1.pdf) contains a short description of the 
work done in DERBY-1313 and DERBY-1374, and some thoughts of what is needed in 
order to extend this work to cover other warnings and exception.

> 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-1313v1.pdf, 
> 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



[jira] Updated: (DERBY-1313) SUR: Use DRDA's extended diagnostic to send ROW_UPDATED and ROW_DELETED warnings.

2006-06-01 Thread Fernanda Pizzorno (JIRA)
 [ http://issues.apache.org/jira/browse/DERBY-1313?page=all ]

Fernanda Pizzorno updated DERBY-1313:
-

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

I am submitting a new patch with the following changes done to derby-1313.diff:

> * DRDAConnThread.java
> - spurious blank line introduced: 63

The blank line has been removed.

> - wrong comment:
>
> // DRDA diagnostic level -> DIAGLVL - SQL Error diagnistic level
> // DIAGLVL1 (0xF0) - Null SQLDIAGRP (DEFAULT)
> // DIAGLVL1 (0xF1) - Non-null SQLDIAGRP
> // DIAGLVL1 (0xF2) - Non-null SQLDIAGRP, and null message text fields
> private byte diagnosticLevel = (byte)0xF0;
>
> They are all called DIAGLVL1 ;) Maybe point to CodePoint.java
> instead to avoid redudancy?

This comment has been changed to:
// DRDA diagnostic level, DIAGLVL0 by default

I have successfully run derbyall. Can someone please review?

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



[jira] Updated: (DERBY-1313) SUR: Use DRDA's extended diagnostic to send ROW_UPDATED and ROW_DELETED warnings.

2006-05-30 Thread Fernanda Pizzorno (JIRA)
 [ http://issues.apache.org/jira/browse/DERBY-1313?page=all ]

Fernanda Pizzorno updated DERBY-1313:
-

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

The patch derby-1313v2.diff addreses the review comments.

[...]

> * NetCursor.java
>  - Several readFdoca* methods are very similar, and you have
>introduced yet another. Use of some minion code would be in order
>to remove redundancy here, I think, but maybe as part of another
>patch.

I don't think this should be done as a part of this patch

> - I also note that the parsing methods in general in NetCursor to a
>   large degree duplicate similar methods in NetConnectionReply;
>   candidate for refactoring, too. Another time...!

I agree that some refactoring could be done here, but I don't think
it should be done as a part of this issue.

> - It is OK that not all protocol elements have parsing code added,
>   since the server currently doesn't send them and you *do* throw an
>   exception if they are encountered (e.g. NetCursor#parseSQLDIAGCN).
>   Maybe a list somewhere (like an overview) of which elements are only
>   partially implemented would be nice. But this is probably more a
>   general peeve for this code. Your call (itch?) ;)

The partially implemented elements introduced by this patch are:
- SQLDIAGSTT
- SQLDIAGCN
- SQLDCTOKS
- SQLDCXGRP

> * DRDAConnThread.java
> - spurious blank line introduced: 63

The blank line has been removed.

> - wrong comment:
> 
> // DRDA diagnostic level -> DIAGLVL - SQL Error diagnistic level
> // DIAGLVL1 (0xF0) - Null SQLDIAGRP (DEFAULT)
> // DIAGLVL1 (0xF1) - Non-null SQLDIAGRP
> // DIAGLVL1 (0xF2) - Non-null SQLDIAGRP, and null message text fields
> private byte diagnosticLevel = (byte)0xF0;
> 
>   They are all called DIAGLVL1 ;) Maybe point to CodePoint.java
>   instead to avoid redudancy?

This comment has been changed to:
// DRDA diagnostic level, DIAGLVL0 by default

> * SURTest.java
> - Is the detectability methods tested in connection with problems seen
>   in DERBY-1249, for the client case? Or should
>   testRowUpdateAndRowDeleted have some tests for the conflict case as
>   well?

Detectability methods are tested in connection with cursor operation 
conflict. These tests were added as a part of the work done for
DERBY-1251.

> Finally, you did not mention which tests have been run, if any?

I have successfully run derbyall.


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



[jira] Updated: (DERBY-1313) SUR: Use DRDA's extended diagnostic to send ROW_UPDATED and ROW_DELETED warnings.

2006-05-17 Thread Fernanda Pizzorno (JIRA)
 [ 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