db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
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 GMT
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



Mime
View raw message