[hibernate-commits] Hibernate SVN: r15880 - core/branches/Branch_3_3/testsuite/src/test/java/org/hibernate/test/sql/hand/custom/sybase.

Author: gbadner Date: 2009-02-03 22:36:37 -0500 (Tue, 03 Feb 2009) New Revision: 15880 Modified: core/branches/Branch_3_3/testsuite/src/test/java/org/hibernate/test/sql/hand/custom/sybase/Mappings.hbm.xml Log: HHH-3685 - Sybase - SchemaExport cannot create stored procedures in chained transaction mode Modified: core/branches/Branch_3_3/testsuite/src/test/java/org/hibernate/test/sql/hand/custom/sybase/Mappings.hbm.xml =================================================================== --- core/branches/Branch_3_3/testsuite/src/test/java/org/hibernate/test/sql/hand/custom/sybase/Mappings.hbm.xml 2009-02-04 03:03:40 UTC (rev 15879) +++ core/branches/Branch_3_3/testsuite/src/test/java/org/hibernate/test/sql/hand/custom/sybase/Mappings.hbm.xml 2009-02-04 03:36:37 UTC (rev 15880) @@ -193,9 +193,19 @@ DROP PROCEDURE selectAllEmployments </drop> </database-object> - + + <!-- The following is a workaround for HHH-3685 so that SchemaExport --> + <!-- changes the transaction mode of selectAllEmployments to "chained" --> <database-object> <create> + sp_procxmode selectAllEmployments, 'chained' + </create> + <!-- no drop command corresponding to "sp_procxmode ..." --> + <drop/> + </database-object> + + <database-object> + <create> CREATE PROCEDURE paramHandling @j int, @i int AS SELECT @j as value, @i as value2 </create> @@ -204,8 +214,18 @@ </drop> </database-object> + <!-- The following is a workaround for HHH-3685 so that SchemaExport --> + <!-- changes the transaction mode of paramHandling to "chained" --> <database-object> <create> + sp_procxmode paramHandling, 'chained' + </create> + <!-- no drop command corresponding to "sp_procxmode ..." --> + <drop/> + </database-object> + + <database-object> + <create> CREATE PROCEDURE simpleScalar @number int AS SELECT @number as value, 'getAll' as name </create> @@ -214,4 +234,14 @@ </drop> </database-object> + <!-- The following is a workaround for HHH-3685 so that SchemaExport --> + <!-- changes the transaction mode of simpleScalar to "chained" --> + <database-object> + <create> + sp_procxmode simpleScalar, 'chained' + </create> + <!-- no drop command corresponding to "sp_procxmode ..." --> + <drop/> + </database-object> + </hibernate-mapping>