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 "Deepa Remesh (JIRA)" <de...@db.apache.org> on 2005/11/07 23:47:21 UTC

[jira] Updated: (DERBY-682) Add tests for error codes for severe exceptions

     [ http://issues.apache.org/jira/browse/DERBY-682?page=all ]

Deepa Remesh updated DERBY-682:
-------------------------------

    Attachment: derby-682.diff
                derby-682.status

Attaching 'derby-682.diff'. This patch adds SQLStates with severity >=session_severity to the test lang/errorCode.sql. It also updates master files. With this patch, I ran the test lang/errorCode.sql with Sun JDK 1.4.2 and IBM WSDD5.6 j9_13 VM. 

This patch covers only embedded driver. I will submit another patch for client driver tests. I will also open another JIRA issue to clean up duplicate entries for SQLStates.

> Add tests for error codes for severe exceptions
> -----------------------------------------------
>
>          Key: DERBY-682
>          URL: http://issues.apache.org/jira/browse/DERBY-682
>      Project: Derby
>         Type: Bug
>   Components: Test
>     Versions: 10.2.0.0
>     Reporter: Deepa Remesh
>     Assignee: Deepa Remesh
>     Priority: Minor
>  Attachments: derby-682.diff, derby-682.status
>
> Add tests to test error codes for disconnect exceptions and other severe errors for client and embedded drivers.

-- 
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] Updated: (DERBY-682) Add tests for error codes for severe exceptions

Posted by Deepa Remesh <dr...@gmail.com>.
Thanks David for looking at the patch.

For connection pooling, these error codes are used to determine
whether the connection is valid. The test is just to  flag if those
error codes change. I found the test lang/errorCode.sql to be a good
place to add this since it was already testing error messages. I am
also planning to add tests for client error code -4499 (disconnect
error). I will upload a patch for this separately.

Thanks,
Deepa

On 11/7/05, David W. Van Couvering <Da...@sun.com> wrote:
> Hi, Deepa.  It looks like the original intent of this test is just to
> make sure that the ErrorMessages VTI looked sane.
>
> Why are you adding all these extra select statements to specifically
> look for every single message with a severity >= session?  Were there
> certain bugs that you were encountering that motivated you to add these
> tests?
>
> Thanks!
>
> David
>
>
> Deepa Remesh (JIRA) wrote:
> >      [ http://issues.apache.org/jira/browse/DERBY-682?page=all ]
> >
> > Deepa Remesh updated DERBY-682:
> > -------------------------------
> >
> >     Attachment: derby-682.diff
> >                 derby-682.status
> >
> > Attaching 'derby-682.diff'. This patch adds SQLStates with severity >=session_severity to the test lang/errorCode.sql. It also updates master files. With this patch, I ran the test lang/errorCode.sql with Sun JDK 1.4.2 and IBM WSDD5.6 j9_13 VM.
> >
> > This patch covers only embedded driver. I will submit another patch for client driver tests. I will also open another JIRA issue to clean up duplicate entries for SQLStates.
> >
> >
> >>Add tests for error codes for severe exceptions
> >>-----------------------------------------------
> >>
> >>         Key: DERBY-682
> >>         URL: http://issues.apache.org/jira/browse/DERBY-682
> >>     Project: Derby
> >>        Type: Bug
> >>  Components: Test
> >>    Versions: 10.2.0.0
> >>    Reporter: Deepa Remesh
> >>    Assignee: Deepa Remesh
> >>    Priority: Minor
> >> Attachments: derby-682.diff, derby-682.status
> >>
> >>Add tests to test error codes for disconnect exceptions and other severe errors for client and embedded drivers.
> >
> >
>
>
>

Re: [jira] Updated: (DERBY-682) Add tests for error codes for severe exceptions

Posted by "David W. Van Couvering" <Da...@Sun.COM>.
Hi, Deepa.  It looks like the original intent of this test is just to 
make sure that the ErrorMessages VTI looked sane.

Why are you adding all these extra select statements to specifically 
look for every single message with a severity >= session?  Were there 
certain bugs that you were encountering that motivated you to add these 
tests?

Thanks!

David


Deepa Remesh (JIRA) wrote:
>      [ http://issues.apache.org/jira/browse/DERBY-682?page=all ]
> 
> Deepa Remesh updated DERBY-682:
> -------------------------------
> 
>     Attachment: derby-682.diff
>                 derby-682.status
> 
> Attaching 'derby-682.diff'. This patch adds SQLStates with severity >=session_severity to the test lang/errorCode.sql. It also updates master files. With this patch, I ran the test lang/errorCode.sql with Sun JDK 1.4.2 and IBM WSDD5.6 j9_13 VM. 
> 
> This patch covers only embedded driver. I will submit another patch for client driver tests. I will also open another JIRA issue to clean up duplicate entries for SQLStates.
> 
> 
>>Add tests for error codes for severe exceptions
>>-----------------------------------------------
>>
>>         Key: DERBY-682
>>         URL: http://issues.apache.org/jira/browse/DERBY-682
>>     Project: Derby
>>        Type: Bug
>>  Components: Test
>>    Versions: 10.2.0.0
>>    Reporter: Deepa Remesh
>>    Assignee: Deepa Remesh
>>    Priority: Minor
>> Attachments: derby-682.diff, derby-682.status
>>
>>Add tests to test error codes for disconnect exceptions and other severe errors for client and embedded drivers.
> 
> 

Re: [jira] Updated: (DERBY-682) Add tests for error codes for severe exceptions

Posted by "David W. Van Couvering" <Da...@Sun.COM>.
Deepa, I'll take a look at this.

David

Deepa Remesh (JIRA) wrote:
>      [ http://issues.apache.org/jira/browse/DERBY-682?page=all ]
> 
> Deepa Remesh updated DERBY-682:
> -------------------------------
> 
>     Attachment: derby-682.diff
>                 derby-682.status
> 
> Attaching 'derby-682.diff'. This patch adds SQLStates with severity >=session_severity to the test lang/errorCode.sql. It also updates master files. With this patch, I ran the test lang/errorCode.sql with Sun JDK 1.4.2 and IBM WSDD5.6 j9_13 VM. 
> 
> This patch covers only embedded driver. I will submit another patch for client driver tests. I will also open another JIRA issue to clean up duplicate entries for SQLStates.
> 
> 
>>Add tests for error codes for severe exceptions
>>-----------------------------------------------
>>
>>         Key: DERBY-682
>>         URL: http://issues.apache.org/jira/browse/DERBY-682
>>     Project: Derby
>>        Type: Bug
>>  Components: Test
>>    Versions: 10.2.0.0
>>    Reporter: Deepa Remesh
>>    Assignee: Deepa Remesh
>>    Priority: Minor
>> Attachments: derby-682.diff, derby-682.status
>>
>>Add tests to test error codes for disconnect exceptions and other severe errors for client and embedded drivers.
> 
>