Hi!

I've read some posts about stored procedures in Hibernate.
It seems that this features will be fully supported in the 3.0 release.

Am I right? If yes, do you have any idea of the date it will be available?

Thanks in advance.

Xavier

http://www.hibernate.org/200.html

http://www.hibernate.org/187.html

do you need more info?

Thanks a lot for your quick answer!

In fact I'm using Hibernate 2.1 on my project and we wanted to centralize database access/calls thanks to Hibernate.

Is it realistic to use it to call stored procedures? I guess we don't have all elements in our version to run them. Otherwise, we thought to call the proc with JDBC through the same connection pool. Do you think it could be a good patch for waiting the 3.0 release?


Xavier

this can be a good way, what does your stored procedure do?
massive updates? complex queries? both?
you can get the jdbc connection from the hibernate session then use it in jdbc.
Don't forget to discard the hibernate session then (1st level cache can be corrupted because of stored procedure updates) and to manage second level cache if you use it.