Hibernate version:3.0

I don't know the way exactly that how to use stored procedures
using hibernate. I didn't find any detailed documentation on stored procedures in Hibernate 3.0.
I am using the following code to understand the usage of stored procedures in Hibernate 3.0.

Please anyone help me by providing a simple example!!! Otherwise i will provide my code, please correct it.

Thanks,
Kumar.

whats wrong with the examples in the hibernate documentation ?

And you didnt seem to include any code in your comment ?

ok I am pasting my code, which executes the stored procedure...
-------------------------------------------------------------------------------
Following is the XML mapping document for persisting "Company" object:
----------------------------------------------------------------------------------

<hibernate-mapping>
<class name="hibernate.Company" table="dp_company">
<id column="company_id" name="id" type="long">
<generator class="hilo"/>
</id>
<property column="company_name" length="255" name="companyName" not-null="true" type="string"/>
<sql-delete callable="true">{? = call deleteCompany (?)}</sql-delete>
</class>
</hibernate-mapping>

------------------------------------------------------------------------------------
Following is the stored procedure created in MS-SQL Server 2000:
-----------------------------------------------------------------------------------
CREATE procedure deleteCompany
@ID bigint
as
/*
** Update the company object
*/
begin transaction
delete from dp_company where company_id = @ID
commit
return @@ROWCOUNT
GO
-------------------------------------------------------------------------------------
Following is the code I am executing from command prompt:
-------------------------------------------------------------------------------------
// 1. Build a Company

Company comp = new Company();
comp.setCompanyName(args[0]);
System.out.println(comp);
CompanyPersistenceCrudService comcrud = new CompanyPersistenceCrudService();
comcrud.save(comp);
System.out.println("Company after hibernating:");
System.out.println(comp);

Its same as you do it using JDBC. Probably you can open the hibernate session, begin the transaction, call the stored procedure,commit the transaction, close the session,if any exceptions rollback.
If you are still having the problem , i will probbaly paste the snippet of the code tommorrow.

Thanks
Yenne

I need code snippet, I followed all the steps, you can see that from my code which i pasted in my previous message.
Thanks,
Kumar.

Rotte,

I don't know what you are asking for ? You apparently have mapped the thing correctly and I don't see any stacktrace or any errors ?

my question is why my procedure is not getting executed, looks everything correct to me. Why don't you try executing the above code as a standalone application.

for one thing - you dont call delete so how do you expect sql-delete to be used in your code ?

Hi Rotte,

I think you got something backwards here ;)

Do you expect hibernate to invoke your stored procedure to delete your Companies without you have told Hibernate to do it ? How should hibernate know that you want to delete something without you calling delete() ?

And if delete() works fine for you then why are you using stored procedures ? Stored procedures is an *option* not an requirement in Hibernate. Its you who decide to use stored procedures instead of the sql generated by hibernate.

And I find it hard to belive that the stored procedure is not called when you call delete() - our unittests states otherwise. you would need to provide a failing test case for this if you still consider it a bug.

Okey I'm soon out of words.

If hibernates default behavior is perfectly valid for you - why are you even adding <sql-delete callable="true">{? = call deleteCompany (?)}</sql-delete> ? <sql-delete> is not *required* its only a hook for you to provide a custom sql string if there is something else you want to be done - like e.g. calling a stored procedure because its a company policy or it does something magically.

so I dont understand why you ask *me* why you should use sql-delete, because obviously you should.