Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: neutral (herse.apache.org: local policy)
Message-ID: <4671BDED.8080806@sbcglobal.net>
Date: Thu, 14 Jun 2007 15:15:09 -0700
From: Kathey Marsden <kmarsdenderby@sbcglobal.net>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
To: derby-dev@db.apache.org
Subject: Re: plzz help me
References: <c25576af0706081140q3b24845bo6ac072e0090f511f@mail.gmail.com>
  <56a83cd00706081436s47ad6e1fma2db1f1e7ff19701@mail.gmail.com>
  <Pine.LNX.4.64.0706090422170.7605@students.iiit.ac.in>
 <d9619e4a0706111119p7bf13c84ha62eda02a63e35d4@mail.gmail.com>
 <Pine.LNX.4.64.0706120002070.19192@students.iiit.ac.in>
 <Pine.LNX.4.64.0706142239550.19468@students.iiit.ac.in>
 <4671840C.8090307@apache.org>
 <Pine.LNX.4.64.0706150307420.29388@students.iiit.ac.in>
In-Reply-To: <Pine.LNX.4.64.0706150307420.29388@students.iiit.ac.in>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Ravinder Reddy wrote:
>>
>     Thank You Dan for your valuable comments/suggestions.
>      Upon careful Observation of Existing JUnit tests I came to know that
>  many tests are using SQLState for asserting.For this we should know 
> the SQLState codes to compare with the Expected SQLState code in any 
> assertion.
> n e way From where can I get The List of SQLState codes.
>
Typically the canon (the .out file in the master directory( has the 
expected SQLStates, but I see for master/declareGlobalTempTableJava.out 
that is not the case.  One option is to change  the test to print out 
the SQLState  of the exception so you can see what it is.

SQLStates are listed here:
http://db.apache.org/derby/docs/10.2/ref/rrefexcept71493.html

But I think the test does not even print out the exception text so it 
would be hard to reconstruct what exception is expected from that list.

Kathey