[Hibernate-commits] Hibernate Code SVN: r10041 - trunk/Hibernate3/test/org/hibernate/test/sql

[<hib...@li...>]

Author: ste...@jb...
Date: 2006-06-22 16:07:07 -0400 (Thu, 22 Jun 2006)
New Revision: 10041

Modified:
   trunk/Hibernate3/test/org/hibernate/test/sql/OracleEmployment.hbm.xml
Log:
modified to test new check attribute (i.e. <sql-XXX check="xyz"/>)

Modified: trunk/Hibernate3/test/org/hibernate/test/sql/OracleEmployment.hbm.xml
===================================================================
--- trunk/Hibernate3/test/org/hibernate/test/sql/OracleEmployment.hbm.xml	2006-06-22 19:51:43 UTC (rev 10040)
+++ trunk/Hibernate3/test/org/hibernate/test/sql/OracleEmployment.hbm.xml	2006-06-22 20:07:07 UTC (rev 10041)
@@ -42,7 +42,7 @@
         </id>
         <property name="name" not-null="true"/>
         <loader query-ref="person"/>
-        <sql-insert>INSERT INTO PERSON (NAME, PERID) VALUES ( UPPER(?), ? )</sql-insert>
+        <sql-insert callable="true" check="none">{call createPerson(?,?)}</sql-insert>
         <sql-update>UPDATE PERSON SET NAME=UPPER(?) WHERE PERID=?</sql-update>
         <sql-delete>DELETE FROM PERSON WHERE PERID=?</sql-delete>
     </class>
@@ -191,4 +191,24 @@
         </drop>
     </database-object>
 
+    <database-object>
+        <create>
+            CREATE OR REPLACE PROCEDURE createPerson(p_name PERSON.NAME%TYPE, p_id PERSON.PERID%TYPE)
+            AS
+                rowcount INTEGER;
+            BEGIN
+                INSERT INTO PERSON ( PERID, NAME ) VALUES ( p_id, UPPER( p_name ) );
+                rowcount := SQL%ROWCOUNT;
+                IF rowcount = 1 THEN
+                    NULL;
+                ELSE
+                    RAISE_APPLICATION_ERROR( -20001, 'Unexpected rowcount [' || rowcount || ']' );
+                END IF;
+            END;
+        </create>
+        <drop>
+            DROP PROCEDURE createPerson;
+        </drop>
+    </database-object>
+
 </hibernate-mapping>