Hi All,

Does Hibernate support full fledge use of views, DB API functions and Stored procedures ???

I tried to look for documenation but didnt really get more information on the same. If somebody has already done this or knows more about what to read in order to get this done please provide me with the links.

Also would be helpful if ppl who have already implemented stuff like this can send me some examples on how things work with views and DB functions ...

Thanks in advance

Ok I found about Stored Procedures in chapter 17 of the documentation ....

how about Views and DB API functions ???

Does anybody know if Hibernates supports Views and DB Functions ?????

You can map entity to view or use it in SQL query without problems (views are transparent for application).
Functions are supported in HQL and SQL queries, you can customize hibernate to add more dialect specific functions (dialects are plugable and have default implementations)

Does and one know of any working examples I can have a look at ???

A view is a table, virtual. There is no difference. That's the whole point.

How about functions?

This question was already answered. If your big picture about what SQL functions are, and how they are typically used is still unclear, consult a SQL documentation.