Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 36115 invoked from network); 15 May 2006 23:34:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 15 May 2006 23:34:21 -0000 Received: (qmail 91592 invoked by uid 500); 15 May 2006 23:34:20 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 91569 invoked by uid 500); 15 May 2006 23:34:20 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 91558 invoked by uid 99); 15 May 2006 23:34:20 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 May 2006 16:34:20 -0700 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 15 May 2006 16:34:19 -0700 Received: (qmail 35981 invoked by uid 65534); 15 May 2006 23:33:59 -0000 Message-ID: <20060515233359.35980.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r406775 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/updatableResultSet.out Date: Mon, 15 May 2006 23:33:59 -0000 To: derby-commits@db.apache.org From: fuzzylogic@apache.org X-Mailer: svnmailer-1.0.8 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: fuzzylogic Date: Mon May 15 16:33:58 2006 New Revision: 406775 URL: http://svn.apache.org/viewcvs?rev=406775&view=rev Log: DERBY-1309: Update j9_foundation/updatableResultSet.out canon Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/updatableResultSet.out Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/updatableResultSet.out URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/updatableResultSet.out?rev=406775&r1=406774&r2=406775&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/updatableResultSet.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/updatableResultSet.out Mon May 15 16:33:58 2006 @@ -1,29 +1,13 @@ Start testing delete and update using JDBC2.0 updateable resultset apis Negative Testl - request for scroll insensitive updatable resultset will give a read only scroll insensitive resultset -WARNING 01J03: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented. -requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not supported -Make sure that we got TYPE_SCROLL_INSENSITIVE? true -Make sure that we got CONCUR_READ_ONLY? true -ownDeletesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false -othersDeletesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false -deletesAreDetected(ResultSet.TYPE_SCROLL_INSENSITIVE)? false -JDBC 2.0 updatable resultset api will fail on this resultset because this is not an updatable resultset -SQL State : XJ083 -Got expected exception 'deleteRow' not allowed because the ResultSet is not an updatable ResultSet. -SQL State : XJ083 -Got expected exception 'updateRow' not allowed because the ResultSet is not an updatable ResultSet. -Negative Test2 - request for scroll sensitive updatable resultset will give a read only scroll insensitive resultset +This test has been removed because scrollable insensitive updatable result sets have been implemented. +Negative Test2 - request for scroll sensitive updatable resultset will give an updatable scroll insensitive resultset WARNING 01J02: Scroll sensitive cursors are not currently implemented. -WARNING 01J03: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented. requested TYPE_SCROLL_SENSITIVE, CONCUR_UPDATABLE but that is not supported Jira issue Derby-154 : When client connects to Network Server using JCC, it incorrectly shows support for scroll sensitive updatable resultsets Make sure that we got TYPE_SCROLL_INSENSITIVE? true -Make sure that we got CONCUR_READ_ONLY? true -JDBC 2.0 updatable resultset api will fail on this resultset because this is not an updatable resultset -SQL State : XJ083 -Got expected exception 'deleteRow' not allowed because the ResultSet is not an updatable ResultSet. -SQL State : XJ083 -Got expected exception 'updateRow' not allowed because the ResultSet is not an updatable ResultSet. +Make sure that we got CONCUR_UPDATABLE? true +Rest of the test removed because scrollable insensitive updatable result sets have been implemented. Negative Test3 - request a read only resultset and attempt deleteRow and updateRow on it Make sure that we got CONCUR_READ_ONLY? true Now attempting to send a deleteRow on a read only resultset. @@ -51,7 +35,6 @@ Negative Test6 - request updatable resultset for sql with FOR READ ONLY clause Make sure that we got CONCUR_READ_ONLY? true Jira issue Derby-159 : Warnings raised by Derby are not getting passed to the Client in Network Server Mode -Will see the warnings in embedded mode only WARNING 01J06: ResultSet not updatable. Query does not qualify to generate an updatable ResultSet. Now attempting to send a delete on a sql with FOR READ ONLY clause. SQL State : XJ083 @@ -2771,7 +2754,7 @@ Got expected exception: Invalid cursor state - no current row. Negative test 40 - Try to insert row from currentRow SQL State: XJ086 -Got expected exception: This method cannot be invoked unless the cursor is positioned on the insert row. +Got expected exception: This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY. Positive test 41 - try to insertRow from all posible positions Positive test 42 - InsertRow leaving a nullable columns = NULL Positive and negative tests 43 - Commit while on insertRow