Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 76087 invoked from network); 7 Dec 2010 17:05:51 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 7 Dec 2010 17:05:51 -0000 Received: (qmail 6714 invoked by uid 500); 7 Dec 2010 17:05:51 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 6691 invoked by uid 500); 7 Dec 2010 17:05:50 -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 6684 invoked by uid 99); 7 Dec 2010 17:05:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Dec 2010 17:05:50 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Dec 2010 17:05:50 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 642B423889DA; Tue, 7 Dec 2010 17:05:29 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1043130 - in /db/derby/code/trunk/java/demo/vtis/sql: demoFileVtis.sql demoForeignDbmsVtis.sql Date: Tue, 07 Dec 2010 17:05:29 -0000 To: derby-commits@db.apache.org From: rhillegas@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20101207170529.642B423889DA@eris.apache.org> Author: rhillegas Date: Tue Dec 7 17:05:29 2010 New Revision: 1043130 URL: http://svn.apache.org/viewvc?rev=1043130&view=rev Log: DERBY-4932: Update the vti demo scripts to use an in-memory database. Modified: db/derby/code/trunk/java/demo/vtis/sql/demoFileVtis.sql db/derby/code/trunk/java/demo/vtis/sql/demoForeignDbmsVtis.sql Modified: db/derby/code/trunk/java/demo/vtis/sql/demoFileVtis.sql URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/vtis/sql/demoFileVtis.sql?rev=1043130&r1=1043129&r2=1043130&view=diff ============================================================================== --- db/derby/code/trunk/java/demo/vtis/sql/demoFileVtis.sql (original) +++ db/derby/code/trunk/java/demo/vtis/sql/demoFileVtis.sql Tue Dec 7 17:05:29 2010 @@ -30,30 +30,15 @@ -- ---------------------------------------------------------------------------------------- -connect 'jdbc:derby:vtitest;create=true'; +connect 'jdbc:derby:memory:vtitest;create=true'; ---------------------------------------------------------------------------------------- -- --- Drop and recreate the database procedures and tables needed +-- Create the database procedures and tables needed -- by this demonstration script. -- ---------------------------------------------------------------------------------------- --- --- Drop procedures and tables --- -drop procedure registerXMLRowVTIs; - --- --- Drop miscellaneous table functions --- -drop function svnLogReader; -drop function propertyFileVTI; - - --- --- Recreate procedures --- create procedure registerXMLRowVTIs( className varchar( 32672 ) ) language java parameter style java Modified: db/derby/code/trunk/java/demo/vtis/sql/demoForeignDbmsVtis.sql URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/vtis/sql/demoForeignDbmsVtis.sql?rev=1043130&r1=1043129&r2=1043130&view=diff ============================================================================== --- db/derby/code/trunk/java/demo/vtis/sql/demoForeignDbmsVtis.sql (original) +++ db/derby/code/trunk/java/demo/vtis/sql/demoForeignDbmsVtis.sql Tue Dec 7 17:05:29 2010 @@ -30,30 +30,15 @@ -- ---------------------------------------------------------------------------------------- -connect 'jdbc:derby:vtitest;create=true'; +connect 'jdbc:derby:memory:vtitest;create=true'; ---------------------------------------------------------------------------------------- -- --- Drop and recreate the database procedures and tables needed +-- Create the database procedures and tables needed -- by this demonstration script. -- ---------------------------------------------------------------------------------------- --- --- Drop procedures and tables --- -drop procedure registerQueryRowVTIs; - -drop procedure closeConnection; - -drop procedure createSubscription; -drop procedure dropSubscription; - -drop table countryLanguage; - --- --- Recreate procedures --- create procedure registerQueryRowVTIs ( className varchar( 32672 ), connectionURL varchar( 32672 ) ) language java