Hi,

I am a newbie to Hibernate. I am trying to implement hibernate for our stored procedure calls. Right now hibernate supports stored procedure with tweaking the code. Here is an expample.

http://forum.hibernate.org/viewtopic.ph ... +persister

Here is my thoughts on approaching it.....

How about getting HQL modified to take in not only simple sql statements but also stored procedure calls along with the parameters.

The stored procedure statements can be converted @ getQueries() method to the adaptable database language.

The other process remains the same.

Is my plan, good, bad, ok...


Thoughts pls....

-Gana.

Max is implementing SP support in v22branch. This work is already mostly done.

Thanks for the reply.. I am in the process of evaluating Hibernate for the new upcoming project.

Any reference documentation on how to make use of the functionality for stored procedures?

Thanks

-Gana

In 2.1, get a connection() from the session and execute SQL.

Thanks for the reply.

How about the set up on the hibernate.cfg.xml and the hibernate-mapping xml files.

- Gana.

Read the documentation.

The support for stored procedure is new to 2.2.

I am looking for the xml configuration for this new functionality.

-- Gana.

There is no 2.2, only a CVS pre-alpha branch. Don't use it.

Any idea on when 2.2 is to be launched???

-gana.

Actually, this branch is part of Hibernate3.

http://blog.hibernate.org/cgi-bin/blosx ... 4/02#three

Any apecific daates has been finalised for the 2.2 or 3 release.

Thanks
Gana.

No.