Hello !

I searched everywhere but I didn't find an answer...

I want to call a Stored Procedure but it doesn't return anything. It is just a simple procedure that upgrades a table for a given ID :



Is it possible to call such a procedure with hibernate ?

I think it should be something like :



But I can't call "executeUpdate" or something like that...

Do you have an idea ?

Thanks in advance.

I read a lot of posts and articles about my problem...
It seems that Hibernate can't handle Stored Procedures with No ResultSet as result.
Even if the Stored Procedure returns a value, it's impossible to use Hibernate with it.

Maybe I am wrong but that is my conclusion for the moment...

section 17.3.2 of Hibernate 3 documentation:
Hibernate 3 introduces support for queries via stored procedures. The stored procedures must return a resultset as the first out-parameter to be able to work with Hibernate.

That said, you could use a SP to update data in the database and then return a cursor that contains the number of updated rows.

Curtis ...

section 17.3.2 of Hibernate 3 documentation:
Hibernate 3 introduces support for queries via stored procedures. The stored procedures must return a resultset as the first out-parameter to be able to work with Hibernate.

That said, you could use a SP to update data in the database and then return a cursor that contains the number of updated rows.

Curtis ...