Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to call Stored Procedure in hibernate which doesn't return results from any specific tables

 
Niranjan Welankiwar
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

I have a stored Procedure which doesn't return result set from any specific tables. Below is the SP :

PROCEDURE [dbo].[spCMTGetClientSummaryRegion]
AS
BEGIN
SELECT 'North East' AS 'Region', '1' AS 'ActiveClients', '3.03%' AS 'Percentage', '1' AS 'Prospects', '3.03%' AS 'TotalPercentage'
END

Output :

Region ActiveClients Percentage Prospects TotalPercentage
North East 1 3.03% 1 3.03%

Now, I want to call this SP from Hibernate and store the result in a java bean object. Below is the hibernate call:

<sql-query name="callCMTGetClientSummaryRegion" callable="true">
<return alias="Client" class="ClientSummaryRegionVO"/>
{call spCMTGetClientSummaryRegion() }
</sql-query>

Where my bean object is ClientSummaryRegionVO. Please help.

Thanks in advance.

Regards,
Niranjan
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic