views and stored procedure

tarun walia · **Joined:** Sat Aug 01, 2009 5:28 am **Posts:** 42

does hibernate support calling views and stored procedure
is there any tutorial how to access view and stored procedure

Cameron McKenzie · **Posted:** Sat Sep 05, 2009 8:39 am

Here's a thread about calling stored procedures from Hibernate:

https://forums.hibernate.org/viewtopic.php?f=1&t=999169

Quote:

The CallableStatement interface used to execute SQL stored procedures. The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. This escape syntax has one form that includes a result parameter and one that does not.

Here's a thread about mapping JavaBeans to database views using Hibernate:

http://www.coderanch.com/t/218656/Object-Relational-Mapping/java/Hibernate-views#1036491

Quote:

Does Hibernate support database views?

Of course. From the point of view of Hibernate, a view is just like any other table (except that you might not be able to update or insert to a view). You can easily map a class to a view by specifying table="view_name".

In Hibernate3, you may even map an entity class to a SQL query result set using the <subselect> mapping element. This is useful if you are unable to define new views in your database.

tarun walia · **Joined:** Sat Aug 01, 2009 5:28 am **Posts:** 42

Thanks Cameron....
Its always pleasent to see the quick response from someone when u r eagerly looking for it.