cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aadamc...@apache.org
Subject svn commit: r504907 - in /cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl: db2/create-update-sp2.sql db2/drop-update-sp2.sql oracle/create-update-sp2.sql sybase/create-update-sp2.sql sybase/drop-update-sp2.sql
Date Thu, 08 Feb 2007 14:27:29 GMT
Author: aadamchik
Date: Thu Feb  8 06:27:29 2007
New Revision: 504907

URL: http://svn.apache.org/viewvc?view=rev&rev=504907
Log:
CAY-750 Stored procedures without parameters fail on Postgres 8
(unit tests for other dbs)

Added:
    cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql
    cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql
    cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql
    cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql
    cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql

Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql
(added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql
Thu Feb  8 06:27:29 2007
@@ -0,0 +1,8 @@
+CREATE PROCEDURE cayenne_tst_upd_proc2
+	MODIFIES SQL DATA
+	LANGUAGE SQL
+BEGIN 
+	UPDATE
+	PAINTING SET ESTIMATED_PRICE = ESTIMATED_PRICE * 2;
+	COMMIT;
+END

Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql
(added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql
Thu Feb  8 06:27:29 2007
@@ -0,0 +1 @@
+DROP PROCEDURE cayenne_tst_upd_proc2
\ No newline at end of file

Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql
(added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql
Thu Feb  8 06:27:29 2007
@@ -0,0 +1,7 @@
+ CREATE OR REPLACE PROCEDURE cayenne_tst_upd_proc2
+ AS
+ BEGIN
+        SET TRANSACTION READ WRITE;
+        UPDATE PAINTING SET ESTIMATED_PRICE = ESTIMATED_PRICE * 2;
+        COMMIT;
+ END;

Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql
(added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql
Thu Feb  8 06:27:29 2007
@@ -0,0 +1,6 @@
+CREATE PROCEDURE cayenne_tst_upd_proc2 AS 
+BEGIN 
+	BEGIN TRANSACTION UPDATE
+	PAINTING SET ESTIMATED_PRICE = ESTIMATED_PRICE * 2
+	COMMIT 
+END

Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql
(added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql
Thu Feb  8 06:27:29 2007
@@ -0,0 +1,4 @@
+if exists (SELECT * FROM sysobjects WHERE name = 'cayenne_tst_upd_proc2') 
+BEGIN 
+	DROP PROCEDURE cayenne_tst_upd_proc2
+END
\ No newline at end of file



Mime
View raw message