Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <330137466.1217604871886.JavaMail.jira@brutus>
Date: Fri, 1 Aug 2008 08:34:31 -0700 (PDT)
From: "Junjie Peng (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-3801) Convert
 "org.apache.derbyTesting.functionTests.tests.lang.holdCursorIJ.sql" to
 junit.
In-Reply-To: <1414263751.1217236172567.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-3801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12619044#action_12619044 ] 

Junjie Peng commented on DERBY-3801:
------------------------------------

Myrna , thanks for your verbose advices!
I'm still not so clear about:
1. For my code in testDropTableWithOpenHoldCursor() Line 227-231, 
                         try{
		dropTable("t1");
	    }catch (SQLException e) {
		assertSQLState("X0X95", e);
	    }
which is in embed mode,  when I want to drop a table with an open hold cursor, It should fail with a SQLException "X0X95 ". I have expected it ,but in fact, it prompts ".ComparisonFailure: Unexpected SQL state. ex 
pected:<42Y5...> but was:<X0X9...> ", why is it not ".ComparisonFailure: Unexpected SQL state. expected:<X0X95...> but was:<******.> " ?
Furthermore, if I change the coed into
  try{
		dropTable("t1");
	    }catch (SQLException e) {
		assertSQLState("0000", e);
	    }
The exception message is still "ComparisonFailure: Unexpected SQL state. expected:<42Y5...> but was:<X0X9...> ".  why is it not "ComparisonFailure: Unexpected SQL state. expected:<0000.> but was:<******.> " ?
Is there something wrong with my code?

2. I have read through the four tools you mentioned. They are all good tools, but I feel puzzled, if translating holdCursorIJ.sql use tools, will we  lose the junit view for this test on some degree? 

Thank you!
Junjie


> Convert "org.apache.derbyTesting.functionTests.tests.lang.holdCursorIJ.sql" to junit. 
> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-3801
>                 URL: https://issues.apache.org/jira/browse/DERBY-3801
>             Project: Derby
>          Issue Type: Test
>            Reporter: Junjie Peng
>            Assignee: Junjie Peng
>         Attachments: derby-3801-1-patch.txt
>
>
> Convert "org.apache.derbyTesting.functionTests.tests.lang.holdCursorIJ.sql" to junit. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.