<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="guid">
<class name="HTest" table="test_table">
    <id name="guid" column="guid_volumn">
    	<generator class="guid"  />
    </id>
   <property name="val" not-null="true"/>
   <sql-insert callable="true" >{call master.dbo.add_val(?,?)}</sql-insert>
 </class>												
</hibernate-mapping>

CREATE TABLE [dbo].[test_table] (
	[guid_column]  uniqueidentifier ROWGUIDCOL  NOT NULL ,
	[val] [int] NULL 
) ON [PRIMARY]
GO

CREATE   PROCEDURE add_val
	@ip int,
	@op uniqueidentifier  OUTPUT
AS	
 	 Set @op = newid()
	 insert into test.dbo.test_table (guid_column,val) values (@op,@ip)
GO

 public   class  HTest {
	 private  String guid;
	 private   int  val;
	 public  String getGuid() {
		 return  guid;
	}
	 public   void  setGuid(String guid) {
		 this .guid = guid;
	}
	 public   int  getVal() {
		 return  val;
	}
	 public   void  setVal( int  val) {
		 this .val = val;
	}
	 public   void  save(){
		Session session = HibernateUtil.currentSession();
		Transaction t = session.beginTransaction();
		session.save( this );
		t.commit();
	}
}

guid.HTest t =  new  guid.HTest();
t.setVal( 222 );
t.save();