You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by rh...@apache.org on 2010/12/07 18:05:29 UTC
svn commit: r1043130 - in /db/derby/code/trunk/java/demo/vtis/sql:
demoFileVtis.sql demoForeignDbmsVtis.sql
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