db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r542080 - in /db/derby/code/trunk/java: demo/toursdb/ToursDB_schema.sql testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out
Date Mon, 28 May 2007 02:20:26 GMT
Author: myrnavl
Date: Sun May 27 19:20:25 2007
New Revision: 542080

URL: http://svn.apache.org/viewvc?view=rev&rev=542080
Log:
DERBY-1797 - Building toursdb would go a little faster if it used autocommit off. Patch contributed
by James F. Adams.


Modified:
    db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out

Modified: db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql?view=diff&rev=542080&r1=542079&r2=542080
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql Sun May 27 19:20:25 2007
@@ -13,6 +13,8 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
+AUTOCOMMIT OFF;
+
 CREATE TABLE AIRLINES
    (
       AIRLINE CHAR(2) NOT NULL ,
@@ -179,3 +181,4 @@
 CREATE TRIGGER TRIG2 AFTER DELETE ON FLIGHTS FOR EACH STATEMENT
 INSERT INTO FLIGHTS_HISTORY (STATUS) VALUES ('INSERTED FROM TRIG2');
 
+COMMIT;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out?view=diff&rev=542080&r1=542079&r2=542080
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out
Sun May 27 19:20:25 2007
@@ -14,7 +14,8 @@
 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
-CREATE TABLE AIRLINES
+AUTOCOMMIT OFF;
+ij> CREATE TABLE AIRLINES
    (
       AIRLINE CHAR(2) NOT NULL ,
       AIRLINE_FULL VARCHAR(24),
@@ -161,6 +162,7 @@
 ij> CREATE TRIGGER TRIG2 AFTER DELETE ON FLIGHTS FOR EACH STATEMENT
 INSERT INTO FLIGHTS_HISTORY (STATUS) VALUES ('INSERTED FROM TRIG2');
 0 rows inserted/updated/deleted
+ij> COMMIT;
 ij> ij version 10.3
 WARNING 01J01: Database 'toursDB' not created, connection made to existing database instead.
 CONNECTION0* - 	jdbc:derby:toursDB



Mime
View raw message